Removing duplicate Material Requisitions (MR #) when counting

Katkss

Hello, I am trying to count the number of requisitions (MR ‘s) per shop, minus duplicate MR's.

Duplicate material requests equal one transaction (i.e., "1234" listed multiple times in a column still only equals one transaction). The MR # applies to multiple parts, thus the need for multiple submissions but still only one transaction.

So, essentially, I need the number of transactions per shop, per year. I cannot seem to create a formula that does everything above.

Also, I do not want to hide the duplicate material req's on the grid. Any suggestions are appreciated. 😊

Kathy

Adam Murphy

Hi @Katkss, I would use the DISTINCT function for this, something like =COUNT(DISTINCT([MR #]:[MR 3])) would give you how many distinct values are in the MR # column. Hope this helps!

Paul Newcome

Your formula would be something along the lines of

=COUNT(DISTINCT({MR # Column}))

Katkss

Thank you so much. I will give Distinct a try. 😊

Paul Newcome

Happy to help. 👍️