View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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