If you have an index of the numbers you need to check then use the below
formula to return the number of instances.

The below will return the number of instances 100 is present from columns A
to J.
=COUNTIF(A:J,100)

If this post helps click Yes
---------------
Jacob Skaria


"soodddddddddd" wrote:

I have data in 45 coulmns and 3000 rows. I want to know which numbers are
repeated in each row or coulmn.Please help me to solve this problem.