Excel 2010, Highlight Unique top 10 and bottom 10 dates in column
Posted on 2011-02-16
Hi, as per the title...
I have a list of 80 dates that I would like to highlight the top 10 unique values. It is the 'unique' part I am having a problem with as there a multiple entries with the same date. I would like all entries with the same date to only be recognised as only 1 value within the top 10. So there could be 18 of the 80 dates that fall within the top ten highest date range. Then I want to be able to highlight the 18 entries. Similar issue with the bottom 10. The worksheet has two separate macros to sort by two different columns so the cells will move per the sorting rules and rows are deleted and added as required. I would like not have to re-enter the formulas each time a row is deleted or added.