Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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/communities...d-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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To Mr. T. Valko | Excel Worksheet Functions | |||
T.Valko | Excel Discussion (Misc queries) | |||
Hey! T. Valko | Excel Discussion (Misc queries) | |||
TO mr t.valko... | Excel Discussion (Misc queries) | |||
mr t.valko ..help | Excel Discussion (Misc queries) |