in an Excel database, how can I see wich value or name is the most recurrent?
J Jessicau Jul 12, 2006 #1 in an Excel database, how can I see wich value or name is the most recurrent?
N Nick Hodge Jul 12, 2006 #2 Jessicau use a helper column and if your recurrent data is in column A then =COUNTIF(A:A,A1) This can then be filtered or sorted and will tell you how much each value occurs in column A -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk [email protected]
Jessicau use a helper column and if your recurrent data is in column A then =COUNTIF(A:A,A1) This can then be filtered or sorted and will tell you how much each value occurs in column A -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk [email protected]
