Formula or else ???

[Solved/Closed]
Report
-
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
-
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 replies

Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
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
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
:)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!