LinkBack URL
About LinkBacks
I'm with rwg for approach but would probably opt for non-volatile INDEX over INDIRECT, eg (based on your earlier upload):
C1: =IF(B3,"",COUNTIF(B3:INDEX(B3:B15,MATCH(1,B3:B15)),0))
I'm with rwg for approach but would probably opt for non-volatile INDEX over INDIRECT, eg (based on your earlier upload):
C1: =IF(B3,"",COUNTIF(B3:INDEX(B3:B15,MATCH(1,B3:B15)),0))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks