ignore duplicates

  1. M

    Return a sum values as based on task ID and Ledger by ignoring duplicates

    Hi, Required a formula help to as per data available in working sheet, return a sum values in column C as based on task ID and Ledger by ignoring duplicates whatever available in column A and B (task ID and Ledger) in the summary sheet. Expected results are available in summary sheet column E...
  2. Y

    Check for existng appointments in calendar to prevent duplicate entries when importing from excel

    Hey Guys, I'm stuck trying to prevent duplicate appointments being created when i run the following code to import excel dates to outlook. Public Sub CreateOutlookMeetings() Sheets("sheet1").Select On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As...
  3. D

    Macro to copy template, named based on cell value in order & allowing data to be added to original list

    Hi there, I'm a complete newbie at VBA, only looked at my first code this week! After searching many forums (thanks for your help everyone!) I have modified code to work somewhat. My macro currently copies a template and renames it based on data on my "estimate" sheet, what I need help with...
  4. S

    countif multiple criteria but ignore duplicates

    Hi Guys, hope you can help me with a countif formula to count the days the running activity was done and ignore the amount of times it might have been done in the same day. The count for running days must equals 3 in the example table below. <tbody> Activity Date Total Running Days ...
  5. 03856me

    Countifs on Unique Records with Multiple Criteria

    I have Excel 2007, using a Table called sawmillTable I am looking for the count of days the machine ran. There are multiple days because of breaking down dimensions, specie, etc. So I need to ignore duplicates in the [date] field, I think. If someone could help get me started that would be...

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