Forum Discussion

ablackwell1205's avatar
ablackwell1205
Copper Contributor
Sep 23, 2023

Function to Reference Multiple Cells for Values

Hi there! So I want to use Excel to have a cell reference 4 other cells. The 4 other cells will either contain a number (1, 2, 3, or 4) or N/A (these 4 cells are also using IF functions so if their conditions aren't met, N/A is the entry).

Which formula can I use for my cell with "VALUE!" to only paste the data from the cells below it that actually has a numerical value, not N/A? Hope that made sense. Thanks!

 

 

Excel
Formulas and Functions
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Sep 23, 2023

    ablackwell1205 

    =TEXTJOIN(",",,FILTER(E2:E5,NOT(ISNA(E2:E5))))

    If you have access to TEXTJOIN and FILTER you can try this formula. The formula is in cell E1 and copied to cell F1.

Resources