I have 2 sheets.
Sheet1 has a layout with numbers in columns C to R on over 500 rows. In these cells are numbers sometimes the same number appears more than once.
Sheet2 in column A there is a list of Unique numbers.
I am trying to figure out a formula that will see if the numbers in sheet2 column A appear anywhere on sheet1 and count the number of times they do. If they do not, show 0 or "not found".
I found this:
=IFERROR(IF(MATCH(A1,Sheet1!$A:$A,0),"yes",),"no") but I can't figure out how to get it to count the number of times a number reoccurs and look at columns C to R.
Any Idea before I do it in PHP?