| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
complex formula does something simple?
{=IF(SUM(--ISBLANK(M1:M141))-(ABS(ROW(E101)-ROW(E141))-1)<0,SUM(--
ISBLANK(M1:M141)),0)} (Entered as an array formula.) If the count of blank cells in M1:M141 minus (141-101) < 0, then count the blanks in M1:M141, else enter 0. Doesn't this formula essentially count the blanks in M1:M141 and compare that number to the number of rows between E101 and E141? Found in a workbook I'm auditing... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complex & simple database on a single form | Excel Discussion (Misc queries) | |||
| Complex If/Then formula? | Excel Discussion (Misc queries) | |||
| Complex Formula | Excel Worksheet Functions | |||
| Simple, yet complex problem! Using results as new data during calculations? | Excel Worksheet Functions | |||
| I Need Help with complex formula ? | Excel Worksheet Functions | |||
![Dave F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
