remove duplicates formula

  1. A

    Trying to edit a formula, not to sum duplicates

    Hi everyone I am new to this forum. Thanks for providing this service. I am trying to edit this formula to don't calculate duplicates, but I am not succeeding. The formula is: =IFERROR(IF(C17<>"", IF(SUMPRODUCT((INT(Table3[Giorno Inizio])='Calcolo...
  2. B

    Remove duplicates from countifs statement based on another column's values

    Hello, I'm looking to accurately countifs a long series of data and remove the duplicates from that series based on another column's values. It seems like it shouldn't be that hard but haven't been able to find a solution. My data set has 10,000 rows, so I am not looking for a pivot table...
  3. J

    Sum based on unique values in separate column without removing duplicates

    This spreadsheet contains order information. When someone places an order, each item in their order is displayed on multiple rows. There could be one item, or many. You can see how Order #5383 had 2 items, thus two rows. I've found a formula...

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