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