Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Comparing text values in excel and
Name: Isaklas Date: January 5, 2009 at 13:35:53 Pacific OS: Windows XP CPU/Ram: Core 2 Duo, 2 gig Product: Intel / E4500 Subcategory: Microsoft Office
Comment:
Hi
I'm trying to work out how to devise a formula in Excel 2003 which does the following ...
Searches a range of cells for a certain text value 'False' in worksheet "Data", if it finds it, this Text is copied to another cell in a different worksheet called "Work", if the text "False" is not found then it returns the Text "Pass" to the same cell as above in the worksheet called "Work".
Name: Isaklas Date: January 5, 2009 at 17:03:24 Pacific
Reply:
Apologies, just realised I'd forgotten to mention that there are essentially 3 possible text entries into each of the range being search, "Pass","Fail" (not False as I mentioned earlier), or the cell is blank.
Ideally what I'd like is to have something which copies the word "Pass" to another cell if all cells in the range searched contain the word "Pass", Copy the word "Fail" to that other cell if any of the cells are being searched contain the word "Fail" and copy a 'Blank' to the cell if not all the cells in the range actually contain some text.
0
Response Number 3
Name: jon_k Date: January 6, 2009 at 08:48:48 Pacific
Reply:
How about this? Note this assumes the data can ONLY be PASS, FAIL or "" (blank). I've set A1:A9 as the range.
Summary: I have two columns of information. Column A represents original customer names and Column B represents new/updated customer names. I need a formula that can check a text value in a cell in column B ...
Summary: Thanks mike, I tried that and nothing happened, that i think was for numbers. What i am looking for is like the post "compare two columns in excel" he was compairing names of companies, and i am just...
Summary: You don't say where you are getting your lookup values from, so follow this example: - I put your table in A1:E6 - I put 1:00 in G1 - I put 25 May 2009 in H1 =VLOOKUP(G1,$A$1:$E$6,MATCH(H1,$A$1:$E$1,1...
0 
