Sorting data by highlighting?
Hi all,
Any way to sort data by which columns are highlighted? I currently have a s/s of about 20,000 rows and there are rows that are highlighted throughout that I'd like to separate--what is the best way to go about doing this? Thanks! -Jonathan |
Sorting data by highlighting?
hi
by highlighted do you mean colored? if so then sorting by color is built in for 2007. (i think) but for all version back, there is no built in way to do this. it is done but usually with a helper column where the diferent colors are assign a different number or letter in the helper column and the sort is done on the helper column. you could write a macro to assign the values to the helper column. you might find help in the following site. http://cpearson.com/excel/colors.htm it contains custom functions to count, sum and sort by colors. Regards FSt1 "Jonathan" wrote: Hi all, Any way to sort data by which columns are highlighted? I currently have a s/s of about 20,000 rows and there are rows that are highlighted throughout that I'd like to separate--what is the best way to go about doing this? Thanks! -Jonathan |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com