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!
=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.
