On 27 Oct 2006 12:33:51 -0700, "Johnny Meredith" wrote:

To reproduce your results from your posted data, you can use sorting or, if you
want to use a formula, you could use the VSORT function from Longre's free
morefunc.xll add-in.

Can you post a link for this? All the links I've found in Groups are
broken.

http://xcell05.free.fr/



I inadvertantly produced an example where pairing Term and Category
always results in a unique combination. In real life, that won't
necessairly be the case.

VSORT won't be the entire answer, then.
--ron