=COUNTA(UNIQUE(FILTER(C$2:C2,B$2:B2=B2)))
The Name recordNum refers to
=ROW(LOKASI)-1
= MATCH(
LOKASI,
INDEX(
LOKASI,
SMALL(
IF(
MATCH(LOKASI,LOKASI,0)
=recordNum,
recordNum),
recordNum)
),
0 )
It gives the same results as the OP wants (and as my formula in msg #5) so I'd guess yes!So
would at least be a correct formula to try to refactor?Code:= LET(list, UNIQUE(FILTER(LOKASI, CUSTOMER=@CUSTOMER)), XMATCH(@LOKASI, list) )
= MATCH(TRUE, list=aLOKASI, 0)
and
= MATCH(aLOKASI, list, 0)
filtered:= IF(CUSTOMER=aCUSTOMER, LOKASI,"")
ptr:= IF((MATCH(filtered, filtered, 0)=recordNum)*(filtered<>""), recordNum)
list:= INDEX(LOKASI, SMALL(ptr, recordNum))