This may be a simple formula, but I can't figure out one detail.

=IF(NOT(ISERROR(SEARCH("a",A1:A15))),"a","")

When using a test sheet to try out this formula, I have populated
column A with various single letters of the alphabet. For example, A1
and A15 have the letter "a" in them. A2 and A14 have the letter "b",
(and so on down the column with different letters). The formula is in
column B, staring with B1:B15, and it works-showing B1 and B15 with the
letter "a". What I want to do is sort these letters alphabetically in
order, i.e. B1=a, and B2=a, B3=b, and B4=b. Is it possible with this
formula, or is there another simple way of completing this function.
Also, the way I have the formula, I know it is searching for that one
letter "a". I have put the formula in different columns to search for
individual letters of the alphabet. I would like to write one formula,
but I haven't yet figured that out.

Thanks in advance, you guys are great.


--
johnrhyme1
------------------------------------------------------------------------
johnrhyme1's Profile: http://www.excelforum.com/member.php...o&userid=37828
View this thread: http://www.excelforum.com/showthread...hreadid=573822