formula or else ???Solved/Closed

Question

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.
:)

tompols · Answer

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

GALAPAGO · Answer

PERFECT !!!! YAHOOOOOOOOOOOOOOO!!!!!!!!

If you were closer I would kiss you all over................

THANKS -THANKS - THANKS--------------------------TOMPOLS

tompols · Answer

:)

Formula or else ???

3 responses

Similar discussions

Subscribe To Our Newsletter!