+ Reply to Thread
Results 1 to 2 of 2

Valeu in the Cell of the Largest nonempty row reference

  1. #1
    Registered User
    Join Date
    06-06-2014
    Posts
    3

    Valeu in the Cell of the Largest nonempty row reference

    Hello!

    I need to create a formula that will retrieve the value in the largest nonempty row reference.
    On the attached file, this formula would look at row Data!N:N, then would find the largest nonempty row in that column (row 190), and then would retrieve the value 6, since it is the value in that row.

    Thanks so much!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,915

    Re: Valeu in the Cell of the Largest nonempty row reference

    =LOOKUP(10^50,Data!N:N)

+ 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. Return a the latest Valeu (TEXT) entered based on a criteria
    By asantos80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2017, 02:44 PM
  2. search the Max Valeu in the Column J
    By Khemisset in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-09-2017, 09:12 AM
  3. [SOLVED] Highlight entire row based on nonempty cell
    By surePac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2014, 03:19 PM
  4. [SOLVED] Find nonempty cell above in column and increase number
    By davegscott in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 09-18-2012, 07:01 PM
  5. Replies: 1
    Last Post: 06-18-2008, 02:42 PM
  6. Delete empty cells within row until you hit nonempty cell
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2008, 12:55 PM
  7. Largest difference from reference value
    By jzifodya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2007, 10:02 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