Forum Discussion
Display Last Value in Column when certain criteria match
Hello all, I am trying to find a way of displaying the last value in a column when certain criteria match... Criteria that need to match would be Design, Colour and Size, so the quantity column...
In cell P2 apply the below formula:
=BYROW(M2:M9 & N2:N9 & O2:O9, LAMBDA(a, TAKE(TOCOL(CHOOSECOLS(D5:K18, XMATCH(TRUE,
SCAN("", D1:K1, LAMBDA(a,b, IF(b = "", a, b))) & D2:K2 & D3:K3 = a)), 1), -1)))It is a dynamic formula and is applied only once. If necessary, you can change the range D5:K18 in the formula.
Hope this helps.
IlirU