Seaching a range

  • Thread starter Thread starter Robo
  • Start date Start date
R

Robo

Hi,

I have a column on Sheet 2, say A1:A5, with a series of test results in it.
If any of the data is missing I've flagged that cell as "Results due"

My sheet 1 is a summary sheet. I want cell A1 to tell me if any of the
cells in the range have missing data, I'm not bothered about it which bit of
data is missing though.

Can anybody tell me which function might be best to use - I'm sure its
pretty simple.

Cheers,
 
Hi

Try something like this:

=IF(COUNTIF(Sheet2!A1:A5,"Results due")>0,"Missing data","OK")

Regards,
Per
 
Back
Top