Thursday, January 26, 2012
Surfing For In More Than Name Only?
Charles asks…In Excel how do I hi-light duplicate cells in a list if they appear more than 10 times?I have a spreadsheet where column A contains a list of User IDs. It is an audit report that shows invalid logons. If a certian name appears on this list more than 10x times, I want each one to be hilighted. I know how to use conditional formatting to hilight duplicates - but that is only for it appearing 2x or more. I only want it to show names that appear more than 10x. Since this list
