check for double information

A

art

How can I make a formula in one cell, to check in a list of products if there
is any double information. Like if there is twice "Eggs" in the list?
 
N

Nick Hodge

If your data is in say A1:A100, then in B2 enter

=COUNTIF($A$1:$A$100,A1)

and copy down. This will give you a column alongside in B, with 1,2,3,etc,
which is the number of times that entry appears in the dataset

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
www.nickhodge.co.uk
 
Top