+ Reply to Thread
Results 1 to 3 of 3

Refer only cells with content

  1. 07-08-2016, 09:31 AM #1
    magic2finger
    magic2finger is offline
    Registered User
    Join Date
    02-03-2015
    Location
    Larvik, Norway
    MS-Off Ver
    Office MAC 2011
    Posts
    43

    Refer only cells with content

    Refer sheet1 A1:A200 to sheet2 A1:A200 , but not include empty cells from Sheet1.


    So if cell A150-A200 is empty in sheet1 i will not get "0" in sheet2 A150-A200.
    Reply With QuoteRegister To Reply
  2. 07-08-2016, 09:35 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Refer only cells with content

    Try one of these...

    =IF(Sheet1!A1="","",Sheet1!A1)

    If the data is TEXT only...

    =T(Sheet1!A1)

    You may have to replace the commas with semi-colons.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 07-08-2016, 09:36 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Refer only cells with content

    Do you mean you want a direct reference to all cells?

    sheet2 A1 =if(sheet1 A1="","",sheet1 A1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Automatically copy cells content based on the content of another cell.
    By chrisbarlow1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 11:13 AM
  2. [SOLVED] Highlight a cell if its content doesn't match another cells content
    By noxygen in forum Excel General
    Replies: 4
    Last Post: 04-12-2012, 04:36 AM
  3. Refer to cells in the range consisting of non-adjacent cells
    By dmitry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2011, 10:48 AM
  4. How do you refer to the content of one cell for multiple formulas?
    By mk04 in forum Excel General
    Replies: 2
    Last Post: 10-12-2010, 02:02 PM
  5. Excel 2007 : Formula to refer to a cell's content for retrieving information
    By DKACyclone in forum Excel General
    Replies: 5
    Last Post: 09-10-2010, 02:58 PM
  6. Merge the content of 2 cells into 1 (with a comma separating the content)
    By vvvv in forum Excel General
    Replies: 2
    Last Post: 01-29-2007, 12:14 AM
  7. How make hyperlink refer to cell content rather than cell address.
    By Omunene in forum Excel General
    Replies: 3
    Last Post: 03-01-2006, 09:10 PM
  8. [SOLVED] refer to a cells value in a macro
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2005, 10:06 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