| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Seaching with no results | Excel Discussion (Misc queries) | |||
| Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Linear Mode
