maybe you can add another criteria using if inside the match something like
=OFFSET(Pivot!$B$1, MATCH($A5, IF(Pivot!$C$2:$C$17="N",Pivot!$A:$A, 0))-1, , $B5, )
maybe you can add another criteria using if inside the match something like
=OFFSET(Pivot!$B$1, MATCH($A5, IF(Pivot!$C$2:$C$17="N",Pivot!$A:$A, 0))-1, , $B5, )
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks