hi all..
i have excel formula this :at first, this formula is working, but after i closed the file then open again, the formula not working...=OFFSET($AX$2;MATCH(1;(L2=AV$3:AV$100)*(M2=AW$3:AW$100);0);;COUNTIFS(AV$3:AV$100;L2;AW$3:AW$100;M2))
after that...i delete formula in DV then copy again the formula is work...
how to fix it?
my target is cell N2 down (yellow areas)
any help much appreciated...
john m
Bookmarks