Forum Discussion

BSantos0312's avatar
BSantos0312
Copper Contributor
May 08, 2024
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 ...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
May 08, 2024

BSantos0312 

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)
)

 

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 08, 2024

    Patrick2788 , BSantos0312 

    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
    )
)

Resources