+ Reply to Thread
Results 1 to 3 of 3

Formula Return result from non empty cell

  1. #1
    Registered User
    Join Date
    05-14-2008
    Location
    Philippines
    Posts
    2

    Formula Return result from non empty cell

    Does it applicable also to arrays of data?.... I have to get rid of those blank cells in between.
    This is my sample table
    NUmber______ Model
    123 _________ PEn

    456__________ BAll

    I want to it to look like this..
    Number________ Model
    123___________ PEn
    456___________ BAll

    What function will I use? Please help.....
    Last edited by innocent_eyes; 05-22-2008 at 12:58 AM.

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    493
    Note: I'm using xl 2007.

    you can use this formula:

    for the numbers in column A:
    Please Login or Register  to view this content.
    copy down

    for the text in column B:
    Please Login or Register  to view this content.
    copy down

    formula for column B are confirmed with CTRL+SHIFT+ENTER, formula will be enclosed with brackets {}.
    Corine

  3. #3
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    493
    sample file attached.
    Attached Files Attached Files

+ 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