+ Reply to Thread
Results 1 to 7 of 7

Formula is working on Text but not on Numbers

Hybrid View

  1. #1
    Registered User
    Join Date
    10-08-2011
    Location
    Mellieha, Malta
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Formula is working on Text but not on Numbers

    Thanks Again

    This formula ommits empty cells so my final report will skip empty cells and have cells that contain text or numbers stacked below each other.

    Unfortunately when I enter the formula you gave me I get a notification that there is something wrong with the formula
    Last edited by shg; 10-08-2011 at 05:53 PM. Reason: deleted quote

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,702

    Re: Formula is working on Text but not on Numbers

    mmmm...can't get anything right tonight

    This is what I meant

    =IF('Statement Info'!A8<>"",ROW(),"")
    Audere est facere

  3. #3
    Registered User
    Join Date
    10-08-2011
    Location
    Mellieha, Malta
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Formula is working on Text but not on Numbers

    Quote Originally Posted by daddylonglegs View Post
    mmmm...can't get anything right tonight

    This is what I meant

    =IF('Statement Info'!A8<>"",ROW(),"")
    Thank you, it worked to perfection......You got this one right.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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