alphabetical sort

[Guest]

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

 

[domenic22]

Assuming that C2:C5 contains the data, try...

B2, copied down:

=IF(ISNA(MATCH(C2,$C$1:C1,0)),LEFT(C2),"")

Hope this helps!

 

[Niek Otten]

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

| 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

 

[domenic22]

Please ignore...

Assuming that C2:C5 contains the data, try...

B2, copied down:

=IF(ISNA(MATCH(C2,$C$1:C1,0)),LEFT(C2),"")

Hope this helps!

 

[Guest]

Thanks Niek.