Excel Database management
 

in an Excel database, how can I see wich value or name is the most recurrent?

Excel Database management
 

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
HIS


"Jessicau" wrote in message
...
in an Excel database, how can I see wich value or name is the most
recurrent?