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!