check for double information

[Guest]

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?

 

[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
(e-mail address removed)
www.nickhodge.co.uk