Comparing text values in excel and

Intel / E4500
January 5, 2009 at 13:35:53
Specs: Windows XP, Core 2 Duo, 2 gig

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

Any ideas on how this can be achieved?


See More: Comparing text values in excel and

Report •

January 5, 2009 at 16:59:25
How about this:


Report •

January 5, 2009 at 17:03:24
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.

Report •

January 6, 2009 at 08:48:48
How about this? Note this assumes the data can ONLY be PASS, FAIL or "" (blank). I've set A1:A9 as the range.


Report •

Related Solutions

January 7, 2009 at 12:31:22
That's superb thanks, exactly what I needed :)

Much appreciated

Report •

Ask Question