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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

pini

Try here

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"pini35" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/