| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating Blank Rows + "COUNTIF"
Hi
I am using the formula below which was posted recently, to count the number of rows in the defined range excluding duplication which works great. How would I change this to also exlcude blank rows from the defined range ? Thanks for your hel Mik =SUMPRODUCT((A13:A100<"")/COUNTIF(A13:A100,A13:A100&"")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered | Excel Worksheet Functions | |||
| "Last Cell" to find last row, but can't delete blank rows | Excel Discussion (Misc queries) | |||
| Pivot Tables - "(blank)" in rows and cells | Excel Discussion (Misc queries) | |||
| blank rows still "read" by excel | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
