How can I find Duplicate Cells or Rows

[pini35]

Hi there,

Need code or Excel function to enable me to find duplicates in a
worksheet.

Unsure yet if am required to find duplicate *Cells* or *Rows* in a
range so would like to know the solution for either or both scenarios
please.

Please let me know if more information is needed.

Many thanks in advance

ps I am using Excel '97

 

[Dick Kusleika]

pini

Try here

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[pini35]

Many thanks Dick. This looks like the solution I require.

Will look at it in the morning (22:46 in the UK here) and update you
tomorrow.

Thanks again.

 

[pini35]

Dick, just tried one of the solutions in the link and it solved my
problem.

A very useful site to have in your favourites.

Again, many thanks

pini