Quote:
Originally Posted by Spencer101
|
I will be checking that out!
Quote:
Originally Posted by Spencer101
Having had a look again at your formula I an confused as to why you're using the IF(ISERROR approach. Are you just using this to produce a zero if no match is found?
|
Yes the in the real workbook I will return several no match's that need to reflect a 0 vs an error.
Quote:
Originally Posted by Spencer101
I presume from the number of rows in your example workbook (1million+) that you're using Excel 2007 or later?
If this is the case then you can use =IFERROR() rather than an IF and ISERROR then doubling up the formula. So the formula in F5 and copied down would be:
|
Yes we just upgraded from 2003 to 2010 and I am still getting used to the expanded functionality and new functions. Thanks for the tip on IFERROR the formula works perfectly!
Your post has been EXTREMLEY helpful in furthering my understanding of this combination of functions. Thanks so much!
Similar Threads
Threaded Mode
