| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding error in range
Is there a way via formula (not code - as I want it to refresh on every calc)
to find if there is an error in a range. I tried an array formula - but woking only for the first cell (B5) {=ISError(B5:G5)} Many thanks, Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
finding error in range
=SUMPRODUCT(--(ISERROR(B5:G5))) 0
will return true if there are any errors. -- Gary''s Student - gsnu200770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding a value between a range | Excel Worksheet Functions | |||
| Error finding match looking for intersection | Excel Programming | |||
| Finding error messages in a workbook | Excel Programming | |||
| Help finding error setting range to Visible Cells | Excel Programming | |||
| Finding Procedure which generated error | Excel Programming | |||
Linear Mode
