Yes, that's the limitation of the criteria formula suggested in col C. The
set-up will return only & all the unique pairs that you seek from cols A and
B, arranged in an ascending sort order based on the 1st character in col A.
I'm not sure whether it's possible to emulate via formulas a "real" sort
order as per Excel's native Data Sort functionality. Perhaps it's easier
to consider bolting-on a recorded macro to copy n paste as values the
results returned in cols D and E into cols F and G, and then sort cols F and
G using Data Sort?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vsoler" wrote
Max,
I've just realized it does not do a real sort, it works only on first
letter.