Yeah, I did that and it helps, but what about those with a little slight variation in their first name (i.e. Joe vs. Joey or Tim vs. Timmy). Any ideas here?
One final question, I am using this technique to match the two fields (mailing name vs. combined name)
=IF(AT82=V82,"Yes","No")
The problem is if they are just a tad bit different (space, or slight deviation of the first name) then the "match" does not happen. Example:
Joe C Bob and Joey B...
The primary name = the Mailing Name so it's kind of two steps
1. Match the F/M/L name to the mailing name
2. Find which records with the same name match the mailing name then drop that record (so all I have left are secondary names taht will not match the mailing name)
So, in the example...
I have a spreadsheet of data with some numbers associated with names. The primary number should be associated with only one name, but it currently is not.
So, I am trying to figure out how to seperate the primary number out and then issue a new number to the rest of them (mostly husband and...
I have an excel spreadsheet that has a field of Date
So, Column A is
5/15/2006
6/15/2008
etc...
Anyhow, the dates exported from an external source and in excel show up like above but if you click on them it's showing the full date and timestamp.
I need to do a mail merge in Word, and it's...
Skip, that is great. Thanks. One more question.
I combined two columns into one in a txt delimiter
So I have this
Column A
0047 5547
0049 0934
0050 1565
I just need to get the space out of each one of these in this column and have this:
00475547
00490934
00501565
It's 8 char plus that...
I have a columnA and columnB with numbers in those and want to have a comlumnC with the combination of A+B
Column A is 16 digits and B is 6 digits
So, here is what I have
A B C
5511291000000000 230512 5511291000230510
C is almost right but is rounding the...
Hi,
I live in a rural area without DSL, cable, etc and we do have a wireless Internet company that I tried to get access from. We did not qualify since our home sits in the valley, but our neighbors 1/2 mile up the hill can get excellent signal.
So, they agreed to install it there, but it's...
John,
I see what you are saying:
In E or F one of those values is always going to be a zero value, so I always want the value that is greater than zero in either E or F compared against G and then decision from that.
Thanks for your clarification.
No, my bad. I must not be explaining quite right.
Basically, if E or F are greater than G (4%), I want it to return G.
But if E or F is less than G, then I want it to return the number in E or F.
So, I have now:
E F G H
0 35 41.44 41.44
0 75 69.15 75
133...
That's very close.
E F G H
133 0 106.67 0
But, I am getting a 0 for this H column now, which should be just the G value of 106.67
Here is my formula:
=IF(OR(MAX(E5,F5)>G5),F5,MAX(E5,F5,G5))
I have a Excel question, have this formula:
IF(OR(E3>G3,F3>G3),F3
E F G H
0 35 41.44 FALSE
133 0 106.67 106.67
Basically, if E or F are greater than G (4%), I want it to return G -- which is working.
But if E or F is less than G, then I want it to return...
That is great, except it wants to delete the D:\directory
It wants to delete the folder and all subfolders, I do not want the top-level directory deleted, just the subfolders....
Here is what I have:
del D:\directory\*.* /Q /S
RMDIR D:\directory\ /Q /S
pause
I can't use the *.* as that does...
I have the following bat file I am running and it does not work quite right (it's a bat file that I want to schedule to run using Windows scheduler):
del D:\directory\*.* /Q /S
pause
This works great except that I have a subdirectory in this directory called the date like this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.