LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default T.Valko function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To Mr. T. Valko John[_22_] Excel Worksheet Functions 5 May 30th 09 01:21 AM
T.Valko aussiegirlone Excel Discussion (Misc queries) 1 December 17th 08 05:31 PM
Hey! T. Valko JLatham Excel Discussion (Misc queries) 7 December 17th 08 02:10 PM
TO mr t.valko... pierre Excel Discussion (Misc queries) 7 May 31st 08 07:30 PM
mr t.valko ..help pierre Excel Discussion (Misc queries) 8 May 28th 08 06:46 AM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"