How can I sort a spreadsheet of data by colour?

[Guest]

I have 4 colours on my spreadsheet, how do I sort the data by the colour?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html#sorting for a
working solution

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)