Forum Discussion
Formula - to bring back first 5 valuess
I have this Scenario:
Insert a column before column A, rename the column 'Account'
In column B, Filter the data to text/values that are not a date
In column A, Insert formula to bring back the first 5 values in column B
Unfilter & Fill down the account for blanks
The issue I have is, to determine what formula would work to bring back the first 5 values.
Thanks for any help
2 Replies
After filtering, select the first 5 empty cells in column A (below the header in A1).
Let's say that A2 is the active cell in the selection.
Enter the formula =B2 and confirm it with Ctrl+Enter. The row number 2 in B2 is that of the active cell.
