Jan 01 2021 05:49 PM
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
Jan 02 2021 03:26 AM
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.
Jan 02 2021 11:13 AM