Recent content by erikhertzel

OK, just checking.....and thanks.

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...

Never mind, I just got it, see what you mean. Thanks sir.

Skip, this is workign great, but I do not see the True option in autofilter. How do I compare the two columns using a true statement?

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...

Never mind, I figured it out that I could fix it in Word using the Shift-F9 function. Thanks!

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...

Yes, I think you are right, thanks to both of you.

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...