Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell value in formula
I want to use the COUNTBLANK formula to count the number of empty cells in a column up until the end of the list of records. I don't know the definite number of records so i need to dynamically assign the number that the cell number that the formla should count up to. ie COUNT BLANK(D2:Dxxx) where Dxxx is equal to the following function =MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1 how do i generically insert formular into functions or is this even possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using cell value in formula
You could try:
=COUNTBLANK(D2:INDIRECT("D"&(MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1))) -- David Biddulph "Engels" wrote in message ... I want to use the COUNTBLANK formula to count the number of empty cells in a column up until the end of the list of records. I don't know the definite number of records so i need to dynamically assign the number that the cell number that the formla should count up to. ie COUNT BLANK(D2:Dxxx) where Dxxx is equal to the following function =MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1 how do i generically insert formular into functions or is this even possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Isblank vs CountBlank
Per the help files in Excel,
CountBlank will count any cell with a "" as blank, while IsBlank("")=False. So I don't think your two formulas are truly equal. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Isblank vs CountBlank
So I don't think your two formulas are truly equal.
They're not. ISBLANK is incorrectly named. It should be named ISEMPTY. Biff <Mark C wrote in message ... Per the help files in Excel, CountBlank will count any cell with a "" as blank, while IsBlank("")=False. So I don't think your two formulas are truly equal. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |