On 2002-04-24 16:39, Aladin Akyurek wrote:
On 2002-04-24 16:36, Mark W. wrote:
On 2002-04-24 16:34, Aladin Akyurek wrote:
On 2002-04-24 16:31, Mark W. wrote:
Or, have and additional column containing the formula, =IF(ISNA(A1),0,A1), where A1 contains your VLOOKUP. You may choose to hide column A so that viewers of the worksheet are oblivious the the presence of #N/A errors.
I bet COUNTIF will be as fast as that & will not waste space/memory.
Time vs. Size -- the classic worksheet design tradeoff! It all depends on the size of the table array and the average successful hit rate.
My fear is that you're not trading off size/memory against time: you're spending memory.
On 2002-04-24 16:48, Parra wrote:
Here's the formula
=IF(ISNA(B8,display2002,2,FALSE),0,(B8,display2002,2,FALSE))
and I'll try the count if too. Thanks
On 2002-04-24 16:48, Parra wrote:
Here's the formula
=IF(ISNA(B8,display2002,2,FALSE),0,(B8,display2002,2,FALSE))
and I'll try the count if too. Thanks
On 2002-04-24 16:48, Parra wrote:
Here's the formula
=IF(ISNA(B8,display2002,2,FALSE),0,(B8,display2002,2,FALSE))
and I'll try the count if too. Thanks