+ Reply to Thread
Results 1 to 4 of 4

Find out Last Non Empty in a Column Range

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    9

    Find out Last Non Empty in a Column Range

    Hi,
    i have List B8:E37 generated using data validation table.in Column E, i have use formula as =IFERROR(INDEX(Choices!$F$2:$F$90,SMALL(IF(($C$4=Choices!$F$2:$F$90)*IF($D$4="ALL",1,($D$4=Choices!$G$2:$G$90)),ROW(Choices!$F$2:$F$90)-ROW(Choices!$F$2)+1,""),ROWS(Choices!$F$2:F2))),"") in which if the data is not present it will added "" in that cell of E Column.

    E8:E24 contains data whereas E25:E37 is displayed as blank but formula is there.

    Since in my case E24 is the last Non Empty Cell. but when i use formula to find out Last Column number I get as 37.

    pl help to find out last Non Empty Cell.

    below is the code i used to verify
    Please Login or Register  to view this content.
    Below is the code which i am using
    Please Login or Register  to view this content.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Find out Last Non Empty in a Column Range

    try
    Please Login or Register  to view this content.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,344

    Re: Find out Last Non Empty in a Column Range

    See Test3 below

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    06-03-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    9

    Re: Find out Last Non Empty in a Column Range

    Great! it is Working. i really appreciate your support

    Please Login or Register  to view this content.

+ 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. Find the next non-empty cell in column range
    By Rajendra_kodavaty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2016, 03:40 PM
  2. [SOLVED] How do I find the first empty cell in a range of cells in a column
    By Nirmall in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-12-2015, 01:20 PM
  3. [SOLVED] Find next empty cell (Row)within a specific range in column A
    By JRidge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2014, 05:39 AM
  4. Replies: 5
    Last Post: 05-13-2014, 10:19 AM
  5. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  6. Replies: 4
    Last Post: 03-04-2013, 07:41 PM
  7. Macro to Find any empty cell within a range and show result in another column
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2008, 11:32 AM

Tags for this Thread

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