Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for
Did you mean:
Creator

## Count amount of duplications/COUNTIFS for column

Hello All,

I am trying to find amount of duplications within a database, based on certain columns.

Below is a sample of the data I have:

• ID, VednorCode, ItemName is the raw data.
• Duplications is what I am trying to get (In Yellow)

 ID VendorCode ItemName Duplications 1 H90042800 6251 3 2 H90042800 6251 3 3 H90042800 6251 3 4 H90042800 PD-6251-300 2 5 H90042800 PD-6251-300 2 6 H90042800 PD-6252-300 1 7 H03000773 PD-6252-300 1 8 H03000773 PD-6011-300 3 9 H03000773 PD-6011-300 3 10 H03000773 PD-6011-300 3

Duplications should show the total amount of times each combination of VednorCode and ItemName appears.

Duplications amount in each line refers to VendorCode and ItemName in the same line.

Basically, it is the same as if I would use COUNTIFS(B:B,\$B2,C:C,\$C2) in excel.

Any ideas?

1 Solution

Accepted Solutions
MVP

May be like this

Count(TOTAL <VendorCode, ItemName> ID)

6 Replies

Why 1, 1 for Item code of PD-6252-300 ?? I am assuming, It would be 2, 2

Count(TOTAL <ItemName> ItemName)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP

May be like this

Count(TOTAL <VendorCode, ItemName> ID)

Creator
Author

Hi Anil,

It is 1,1 because the VendorCode is different.

I want to count the amount of times each unique combination VednorCode and ItemName  appears.

MVP

Sample attached

After that, I came to know

Count(TOTAL <VendorCode,ItemName> ItemName)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Many thanks Sunny and Anil

Community Browser