How can I find the equal cells in Excel
 

In a range of cells I want to mark or find out the equal cells or the
repeated cells at that ring by using a formula.

Thank you

How can I find the equal cells in Excel
 

Hi

If you have numbers in cells A1:A100 and you want to find which are
repeated, in B1 enter
=COUNTIF($A$1:$A$100,A1)
and copy down
This will show the number of times each value appears in the list.

If you just wanted to highlight which rows had repeated numbers then
=IF(COUNTIF($A$1:$A$100,A1)1,"Repeat","")

will show the word Repeat alongside any numbers occurring more than once
in the list.
--
Regards

Roger Govier


"AMJAD" wrote in message
...
In a range of cells I want to mark or find out the equal cells or the
repeated cells at that ring by using a formula.

Thank you