Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. erikhertzel

    Excel manipulation question

    OK, just checking.....and thanks.
  2. erikhertzel

    Excel manipulation question

    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?
  3. erikhertzel

    Excel manipulation question

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

    Excel manipulation question

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

    Excel manipulation question

    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?
  6. erikhertzel

    Excel manipulation question

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

    Excel manipulation question

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

    Mail Merge Date field issue in Excel

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

    Mail Merge Date field issue in Excel

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

    Office 2003 Excel rounding issue when combining two numbers

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

    Office 2003 Excel rounding issue when combining two numbers

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

    Wireless hop to my home from neighbors link I had installed

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

    Excel IF question

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

    Excel IF question

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

    Excel IF question

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

    Excel IF question

    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))
  17. erikhertzel

    Excel IF question

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

    Remove command in XP with empty sub directories

    Thanks both of you!
  19. erikhertzel

    Remove command in XP with empty sub directories

    ...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 not work with the RMDIR, syntax issue, so how can I remove just the subfolders?
  20. erikhertzel

    Remove command in XP with empty sub directories

    ...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: D:\directory\021207\ This...

Part and Inventory Search

Back
Top