Greetings all,
im playing with an old if and statement i used long long ago but no im brain dead.
i need to check Cell "X" for the words "pass", "Fail", "Caution" or "No Test".
If the word is present then return "1, 2, 3, 4" respectively...
I can then use this to populate a table which will then be used in a stacked horizontal graph (i hope)
this is probably dead easy for expert regular excel gurus but its been some time for me and i cant seem to get my head round it right now and time is a factor.
Thanks in advance
Dave
Bookmarks