+ Reply to Thread
Results 1 to 4 of 4

Looking for last row. But want to ignore ""!

  1. 05-13-2015, 03:43 PM #1
    silentcarl
    silentcarl is offline
    Registered User
    Join Date
    03-17-2015
    Location
    South Carolina, USA
    MS-Off Ver
    2010
    Posts
    59

    Looking for last row. But want to ignore ""! 

    Please Login or Register  to view this content.
    I have many lines that are forced "" by their formula. I want to find the last row that is not "".

    Thanks!
    Reply With QuoteRegister To Reply
  2. 05-13-2015, 04:21 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Looking for last row. But want to ignore ""! 

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 05-13-2015, 04:21 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Looking for last row. But want to ignore ""!

    Duplicate Deleted.
    Reply With QuoteRegister To Reply
  4. 05-14-2015, 08:00 AM #4
    silentcarl
    silentcarl is offline
    Registered User
    Join Date
    03-17-2015
    Location
    South Carolina, USA
    MS-Off Ver
    2010
    Posts
    59

    Re: Looking for last row. But want to ignore ""!

    Brilliant.

    Works perfect. I can use this on at least two of my spreadsheets.

    Rep added. Thank you!
    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. Data Validation - how to ignore cells with "0" or "-"
    By dgibney in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-29-2015, 08:16 PM
  2. [SOLVED] Counting data only contains text (ignore mark "-" & "")
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2014, 09:45 PM
  3. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. VB Macro for Proper Case to Ignore "/" & "-"
    By jlcford in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2008, 07:49 AM

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