Forum Discussion
ablackwell1205
Sep 23, 2023Copper Contributor
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 c...
OliverScheurich
Sep 23, 2023Gold Contributor
=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.