Originally Posted by
all4excel
Dear vane,
Your formula works excellently, no doubts about it however when I tried to add it to my Sheet with other details its not getting added.
I mean the Name---> Criteria3
[ Criteria3-MAX(IF(TRANSPOSE(ROW(INDIRECT("1:"&COUNTA(Tabnames))))<>MATCH("Consolidation",Tabnames,0),IF(T(OFFSET(INDIRECT("'"&Tabnames&"'!A3:A13"),ROW(INDIRECT("3:13"))-3,0,1))=$A2,N(OFFSET(INDIRECT("'"&Tabnames&"'!H3:H13"),ROW(INDIRECT("3:13"))-3,0,1))))) ]
I am able to add the formula but somehow not able to add the criteria it keeps on giving error..
Im using Excel-2003...
So please advise on the same...
Bookmarks