+ Reply to Thread
Results 1 to 4 of 4

Display Text Entries according to Latest Time and date

  1. 11-05-2014, 06:10 AM #1
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Display Text Entries according to Latest Time and date

    Hello Friends

    Display Text Entries according to Latest Time and date

    Version : MS Excel 2010
    Attached file : Display Text Entries according to Latest Time and date.xlsx

    Please find the attached file, my requirement is i want to display the text by the first date and first time.


    thanks in advance

    thilag
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-05-2014, 06:52 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Display Text Entries according to Latest Time and date

    Simply select your range of data

    - Data - Sort
    - Sort By - By Column A (Oldest to Newest)
    - Then By - Column B (Smallest to largest)

    Ok
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 11-05-2014, 10:50 AM #3
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Display Text Entries according to Latest Time and date

    But i need to do by formula instead using Sort manually.
    Reply With QuoteRegister To Reply
  4. 11-12-2014, 05:03 AM #4
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Display Text Entries according to Latest Time and date

    This forum is solved. Kindly refer the attched file <Display Text Entries according to Latest Time and date - Overall.xlsx>

    http://www.excelforum.com/excel-form...ml#post3897239
    http://www.excelforum.com/excel-form...ml#post3897267
    http://www.excelforum.com/excel-form...ml#post3897317

    Thanks to Naveed Raza & azumi

    thanks

    thilag
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. get earliest Date-time and Latest Date-time based on 2 criterias (first & last name)
    By ag273n in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2014, 06:39 AM
  2. Find max/min value from latest three entries by date
    By jschatte in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-25-2014, 01:31 AM
  3. Finding latest date where for multiple entries
    By CrystalM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 08:28 PM
  4. How to combine identical entries with different dates to reflect the latest date
    By Pr0ph3ts2 in forum Excel General
    Replies: 3
    Last Post: 01-11-2012, 03:37 AM
  5. Finding latest text entries
    By jonhall in forum Excel General
    Replies: 0
    Last Post: 07-27-2010, 12:39 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1