Results 1 to 5 of 5

Sorting cells and deleting duplicates except for first instance

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    Swindon
    MS-Off Ver
    Excel 2010
    Posts
    9

    Sorting cells and deleting duplicates except for first instance

    Hi There,

    I am looking to create a formula or set of formulas that sorts two sets of Data (Start & Finish Times) and then deletes duplicates, except for the original data. I have attached an example spreadsheet of my solution so far, it's almost there, except that my formulas are deleting both instances of the duplicate (the original and the duplicate). I have included more information in my spreadsheet on what my formulas do.


    Thanks for any help you can provide.

    Dan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1