S
Steve
Morning.
Back in January I'd posted looking for some help on a function, and T.Valko
helped, solving my issue.
In using the function, I've run across something I was not expecting, and
need to now solve that.
The original post was:
http://www.microsoft.com/communitie...75a6&mid=487ddd9f-1b00-466c-ab5d-6f72a2f875a6
The problem that I've now recognized is that if there is a blank cell in my
data on my source sheet, the first equation from the excel sheet provided
will result in there being a false positive.
I.e., it will show the count for all cells that are blank.
In my initial function I'm checking to see how many names are missing, if
any.
As there'd normally have SOME value, regardless, I need to ignore blanks,
and the placement of the blanks is not predictable, or standardized.
Back in January I'd posted looking for some help on a function, and T.Valko
helped, solving my issue.
In using the function, I've run across something I was not expecting, and
need to now solve that.
The original post was:
http://www.microsoft.com/communitie...75a6&mid=487ddd9f-1b00-466c-ab5d-6f72a2f875a6
The problem that I've now recognized is that if there is a blank cell in my
data on my source sheet, the first equation from the excel sheet provided
will result in there being a false positive.
I.e., it will show the count for all cells that are blank.
In my initial function I'm checking to see how many names are missing, if
any.
As there'd normally have SOME value, regardless, I need to ignore blanks,
and the placement of the blanks is not predictable, or standardized.