Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to sort
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Sort Criteria (or Sort Lists) | Excel Worksheet Functions | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |