Seaching a range
 

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,

Seaching a range
 

Hi

Try something like this:

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

Regards,
Per

"Robo" skrev i meddelelsen
...
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,