Sequence Duplicate Number

is there any formula to achive this kind of output? Im referring to count RFP ref duplicates

Best Answer

  • Protonsponge
    Protonsponge ✭✭✭✭✭✭
    edited 12/11/24 Answer ✓

    Hello @Cybsss,

    I believe you will be able to achieve what your looking for with the addition of a [Auto Number] column to your set up and a formula as per below for your [helper DUPLICATE COUNT] column.

    =COUNTIFS([RFP REF NO]:[RFP REF NO], [RFP REF NO]@row, [Auto Number]:[Auto Number], @cell <= [Auto Number]@row)

    [Auto Number] Column:-

    [helper DUPLICATE COUNT] column:

    I hope that is helpful to you in some way,

    Protonsponge

Answers

  • Protonsponge
    Protonsponge ✭✭✭✭✭✭
    edited 12/11/24 Answer ✓

    Hello @Cybsss,

    I believe you will be able to achieve what your looking for with the addition of a [Auto Number] column to your set up and a formula as per below for your [helper DUPLICATE COUNT] column.

    =COUNTIFS([RFP REF NO]:[RFP REF NO], [RFP REF NO]@row, [Auto Number]:[Auto Number], @cell <= [Auto Number]@row)

    [Auto Number] Column:-

    [helper DUPLICATE COUNT] column:

    I hope that is helpful to you in some way,

    Protonsponge

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!