| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
alphabetical sort
If I have a list of text in column 'C' sorted alphabetically, ascending, is
it possible to show, in 'B', the first instance/occurance of each letter from column 'C'? IE: F Free Four Five G Grand Thanks -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
alphabetical sort
Assuming that C2:C5 contains the data, try...
B2, copied down: =IF(ISNA(MATCH(C2,$C$1:C1,0)),LEFT(C2),"") Hope this helps! On Nov 1, 12:47 pm, Jock wrote: If I have a list of text in column 'C' sorted alphabetically, ascending, is it possible to show, in 'B', the first instance/occurance of each letter from column 'C'? IE: F Free Four Five G Grand Thanks -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
alphabetical sort
In B1:
=LEFT(C1,1) In B2: =IF(LEFT(C2,1)=LEFT(C1,1),"",LEFT(C2,1)) Copy down as far as needed -- Kind regards, Niek Otten Microsoft MVP - Excel "Jock" wrote in message ... | If I have a list of text in column 'C' sorted alphabetically, ascending, is | it possible to show, in 'B', the first instance/occurance of each letter from | column 'C'? IE: | | F Free | Four | Five | G Grand | | Thanks | -- | Traa Dy Liooar | | Jock |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
alphabetical sort
Please ignore...
On Nov 1, 1:04 pm, wrote: Assuming that C2:C5 contains the data, try... B2, copied down: =IF(ISNA(MATCH(C2,$C$1:C1,0)),LEFT(C2),"") Hope this helps! On Nov 1, 12:47 pm, Jock wrote: If I have a list of text in column 'C' sorted alphabetically, ascending, is it possible to show, in 'B', the first instance/occurance of each letter from column 'C'? IE: F Free Four Five G Grand Thanks -- Traa Dy Liooar Jock |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
alphabetical sort
Thanks Niek.
-- Traa Dy Liooar Jock "Niek Otten" wrote: In B1: =LEFT(C1,1) In B2: =IF(LEFT(C2,1)=LEFT(C1,1),"",LEFT(C2,1)) Copy down as far as needed -- Kind regards, Niek Otten Microsoft MVP - Excel "Jock" wrote in message ... | If I have a list of text in column 'C' sorted alphabetically, ascending, is | it possible to show, in 'B', the first instance/occurance of each letter from | column 'C'? IE: | | F Free | Four | Five | G Grand | | Thanks | -- | Traa Dy Liooar | | Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort - Not Alphabetical | Excel Discussion (Misc queries) | |||
| sort last names by in alphabetical order | Excel Discussion (Misc queries) | |||
| Sort other than by alphabetical ascending/ descending | Excel Discussion (Misc queries) | |||
| Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
| how can i sort excel worksheets in alphabetical order? | Excel Worksheet Functions | |||
Linear Mode
