What's the Excel equivalent to Google Sheets' FILTER(range, condition)?
One of the benefits I am seeking is that the formula allows you to return a big range of data from i.e. another sheet, but the formula itself only occupies one cell.
What's the Excel equivalent to Google Sheets' FILTER(range, condition)?
One of the benefits I am seeking is that the formula allows you to return a big range of data from i.e. another sheet, but the formula itself only occupies one cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks