Forum Discussion
Solved
Need help ordering duplicated values in table
Hello! I have a table with thousands of duplicate IDs and I am trying to create an sequential order to show how many times the IDs are listed. The CountIF function gives me the total count listed on ...
A 365 solution with MAP:
MBR_CONTR_EXT_ID is defined as a dynamic item
=LET(
seq, SEQUENCE(ROWS(MBR_CONTR_EXT_ID)),
CountID, LAMBDA(s, ID, COUNTIF(TAKE(MBR_CONTR_EXT_ID, s), ID)),
MAP(seq, MBR_CONTR_EXT_ID, CountID)
)
As variant
=LET(
rng, MBR_CONTR_EXT_ID,
n, ROWS(rng),
SumIt, LAMBDA(v, SUM(v) ),
BYROW( (TRANSPOSE(rng)=rng )*
(SEQUENCE(n) >= SEQUENCE(,n) ),
SumIt
)
)