+ Reply to Thread
Results 1 to 4 of 4

latest data in range

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Dhaka
    MS-Off Ver
    Excel 2016
    Posts
    70

    latest data in range

    I have data in cell A1 to cell A30 (update everyday – incrementally) now I also need a way to show the last updated data in C1 cell. can anyone please help

    thank you

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,861

    Re: latest data in range

    Hi there. You didn't say if the data were text or numbers. This works with both, though:

    LOOKUP(2,1/(A1:A100<>""),A1:A100)
    Glenn



  3. #3
    Registered User
    Join Date
    05-07-2012
    Location
    Dhaka
    MS-Off Ver
    Excel 2016
    Posts
    70

    Re: latest data in range

    worked like a charm :-)

    you are king

    :-)

    thank you

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,861

    Re: latest data in range

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 05-23-2015, 12:08 PM
  2. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  3. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  4. Return Latest Date from a range of data
    By Kenji in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2010, 06:19 AM
  5. Open Latest TextFile with latest TimeStamp
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 10:03 AM
  6. Populate Latest Date From A Range
    By Kumara_faith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-22-2008, 05:01 PM
  7. Function to return the latest non-zero value in a range of cells .
    By hungryman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1