non-unique

  1. A

    countifs multiple criteria

    I'm trying to convert a countifs that currently counts non-unique values into one that counts unique values. The non-unique formula: =COUNTIFS('FULL RAW'!$H:$H,'Summary - Non Unique Counts'!$A6,'FULL RAW'!$D:$D,"B",'FULL RAW'!$T:$T,"Yes",'FULL RAW'!$P:$P,"High") How do I convert that into one...
  2. I

    Non-unique first column, multiple matches in second column

    Hi all, I'm sure the solution to this is easy, but I cannot work it out nor find the solution on the board. I have 2 columns... Staff Element A1 1z A1 2y A1 3x A1 4w A1 5v A1 6u A1 7t A1 8s B2 1z B2 2y B2 3x B2 4w B2 5v B2 6u B2 7t B2 8s C3 1z C3 2y C3 4w C3 5v C3 7t C3 8s What I need to do...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top