If number to be searched is in A1, then put in C1
=COUNTIF(Sheet2!B:B;A1)
Regards,
Stefi
€˛PaulGrowns1€¯ ezt Ć*rta:
I have 2 worksheets.
I need to compare a single figure in column A on sheet 1 to the entire
column B on sheet 2 and count how many times the figure in A appears in
column B and then place this in Column C on sheet 1.
CAn somebody please help me with the formula???????????
|