Results 1 to 7 of 7

Finding first and last occurances whats the best way?

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2003/2010
    Posts
    3

    Finding first and last occurances whats the best way?

    Hi everyone, I'm new here so please bear with me if I've not given you all the details you need!!

    I have a spreadsheet of data which I need to manipulate. I need to find the first and last entries for a date but I can't work out how best to do it I've provided an example below, have you any suggestions?
    Column A: Date Format YYYY-MM-DD HH:MM
    Row 1: 03/01/2012 09:13
    Row 2: 03/01/2012 09:13
    Row 3: 03/01/2012 09:13
    Row 4: 03/01/2012 16:47
    Row 5: 03/01/2012 16:59
    Row 6: 12/01/2012 09:14
    Row 7: 12/01/2012 09:14
    Row 8: 12/01/2012 09:14
    Row 9: 12/01/2012 17:04
    Row 10: 12/01/2012 17:04
    Row 11: 12/01/2012 17:42

    etc etc...
    Last edited by Mary87; 03-02-2012 at 10:16 AM. Reason: Change to Title as per comment from Pepe Le Mokko

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