Use this:
![]()
=OFFSET($H$2,MATCH(1,($F$3:$F$15=A3)/($G$3:$G$15=$B$3),0),,COUNTIFS($F$3:$F$15,A3,$G$3:$G$15,B3))
Use this:
![]()
=OFFSET($H$2,MATCH(1,($F$3:$F$15=A3)/($G$3:$G$15=$B$3),0),,COUNTIFS($F$3:$F$15,A3,$G$3:$G$15,B3))
Quang PT
If the data is shuffled, this formula might fail though.
E.g. all the values that OFFSET combines need to be a contiguous range in the original data set.
Last edited by AliGW; 05-23-2020 at 03:11 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks