ignore duplicates

  1. 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...
  2. 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...
  3. 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 ...
  4. 0

    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...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top