# Formula or else ???

Solved/Closed
GALAPAGO - Jan 14, 2010 at 03:59 PM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 04:44 PM
Hello,
I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH
So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to the end of the name.
In cell B22 I need it to check the range B5:AC5 if it has one "A" or more and if it does, write "A" in cell B22, if no "A" then leave B22 blank.
In cell B23 I need it to check the range B5:AC5 if it has one "B" or more and if it does, write "B" in cell B23, if no "B" then leave B23 blank.
In cell B24 I need it to check the range B5:AC5 if it has one "C" or more and if it does, write "C" in cell B24, if no "C" then leave B24 blank.
And so on for all the alphabets.

Big thanks for your help and time!

Happy New Year 2010 to all.
:)

## 3 responses

tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 28
Jan 14, 2010 at 04:18 PM
hello
try this in B22 : =IF(ISERROR(SEARCH("A";B5&C5&D5&F5&H5&etc...));"";"A")
i did not type the whole list of cells but it should work....
EDIT : sorry, missed the AC25...that's quite a lot of cells, could you give more explanations on your speadsheet and what you want to do, there must be another way to do it...otherwise some vba code....let me know..
PERFECT !!!! YAHOOOOOOOOOOOOOOO!!!!!!!!

If you were closer I would kiss you all over................

THANKS -THANKS - THANKS--------------------------TOMPOLS
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 28
Jan 14, 2010 at 04:44 PM
:)