Outlook Calendar - mark / show duplicate based on "Start"-date only


  1. Posts : 868
    Windows 10 x64
       #1

    Outlook Calendar - mark / show duplicate based on "Start"-date only


    Due to migrating Google Calendar into Outlook latter has a number of duplicates.

    However, the issue is, they are -not- exact duplicates, only the Start date-time are duplicates.
    The end-timestamp may differ slightly and also the title.

    Most duplicate checkers are checking on exact duplicates, so they are of no use.

    How to find and show duplicates based on the Start-date/time only.

    Show .. not delete, I would like to verify first which one should be deleted.

    Any suggestions?

    Thanks!
      My Computer


  2. Posts : 16,955
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #2

    You could use the View menu to change Current view to something in list form such as All appointments that you can then sort by the Start column.

    Do note what your Current view is beforehand so you can get back to it easily.

    Denis
      My Computer


  3. Posts : 868
    Windows 10 x64
    Thread Starter
       #3

    Try3 said:
    You could use the View menu to change Current view to something in list form such as All appointments that you can then sort by the Start column.
    Do note what your Current view is beforehand so you can get back to it easily.

    Denis
    Many thanks indeed.
    I tried your way but regretfully I could get it done. Sorry.

    However, I also went on myself and have found a workaround and solved the matter.

    Workaround:
    1. Calendar - set view to list (details view)
    2. Select all
    3. Ctrl-C and paste it into Excel
    4. Remove the 'days text' in the 'Start' column (Monday, Tuesday, etc.) so you will get 'clean' date-times
    5. Sort the column
    6. Add a new column - "Duplicates"
    6. Then use a formula to mark the possible duplicates in "Start"-column.

    For instance, when "Start"-dates are in column C , one might use a formula like =IF(C3=C2;"Delete";"")

    this way duplicate rows are marked with 'Delete'

    from that point on manually delete the entries.
    As said, a workaround.

    Anyway, thanks again.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 21:51.
Find Us




Windows 10 Forums