As the title suggests, I want to conditionally format data that appears in a spreadsheet more than 10 times; I’ll be using a unique file reference in one column to determine the number of occurrences.
My initial thoughts were to use countif or vlookup but neither seem to work?
Last edited by BaronDJB; 08-27-2010 at 07:54 AM.
Try =COUNTIF(N:N,N3)>10
Column of data is N and the value being check is N3 - when you drag down it will check for every value greater than 10
edvwvw
Thanks, that has worked a treat! :
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks