Forum Discussion

Thomas897's avatar
Thomas897
Icon for Helper I rankHelper I
9 years ago
Solved

Count duplicates

Hello everyone,

 

I want to show how many times my column 'number' appears compared to my column 'week'. Someone could help me please.

 

 

Have a great day :)

Need Help
  • fhill's avatar
    fhill
    9 years ago

     

    Copy Number twice into your table, then make the 2nd Number a 'Count'.

     

    FOrrest

     

     

2 Replies

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

     

    Copy Number twice into your table, then make the 2nd Number a 'Count'.

     

    FOrrest

     

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Thomas897,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale