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!

  • Congratulations SkipVought 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. Joemaha

    D145 printer error

    The printer will only print in red and blue and is very light. Have tried swapping both cartridges and printheads with known good ones. Any ideas?
  2. Joemaha

    Simple Excel formula to purge a simple list

    Think I misunderstood the first time. Try this instead: =IF(VLOOKUP(B1,$1:$65536,2,FALSE),B1,0)
  3. Joemaha

    Simple Excel formula to purge a simple list

    If your data is in rows A and B: In Row C: =IF(A1<>B1,B2,"") Should give you what you need.
  4. Joemaha

    Generating email from daily excel sheet

    I get a daily email regarding employee terminations (always in the same format). What I would like to do is reference a unique ID# to use a vlookup to check if they have a certain asset in "list1", and if they do, use Outlook to email their manager (also contained in term list) and fill in a...
  5. Joemaha

    Cell text manipulation

    Thanks everyone, I took some advice off Bluedragon's post and used the Left and Right commands while modifying the use of Find with the commas. Kind of a roundabout compared to some other solutions, but It's working for me. Thanks alot.
  6. Joemaha

    Cell text manipulation

    Thanks Blue, got closer, but still not getting a usable output... The formula worked on a few, but not that many. Example Jim,Wilson became Wilson,Jim,W Any way to fix this?? Thanks in advance
  7. Joemaha

    Cell text manipulation

    If I have cells with input "FirstName,LastName" in the same cell, what is the best way to manipulate the text into a new cell with the input being "LastName,FirstName"? If possible, I would like to do this without using macros. Any ideas?

Part and Inventory Search

Back
Top