Latest entry

  • My spreadsheet has several thousand rows containing, amongst other information, names of clients and the dates they have been visited (these vary from case to case) . To save time I am after code that will enable the row that has the latest date each client was visited to be displayed on a new separate sheet.
    Help here would be well received.


    Sheet 1(existing sheet)
    A B C
    9/April/2015 Bill 3
    8/March/2015 Gavin 3
    8/March/2015 Bill 4
    1/April/2015 Gavin 2


    Sheet 2 (new sheet)
    A B C
    9/April/2015 Bill 3
    1/April/2015 Gavin 2

  • Re: Latest entry


    This should do, BUT...
    You need to fix you data in col.A.
    Some of dates are not serial date, they are text value...7

  • Re: Latest entry


    Thanks for your brilliance Jindon, I changed the date format and it's worked perfectly. If you're ever in Auckland dinner is on me :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!