| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells since last non-zero value
Try...
=ROWS(A2:A10)-MATCH(TRUE,A2:A100,0) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Bruce" wrote: Great, works a treat... Didn't think i would have to resort to VBA but just the same solved my prob. Gonna think this through now to work out a similar function for the reverse. i.e. Cells since first non-zero value appeared. Rgds, Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count colored cells? | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
Threaded Mode
