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
|