Formula - to bring back first 5 valuess

[mjw0429]

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]

@mjw0429 

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.

[#3]

@Hans Vogelaar 

Thank You very much.

You may have helped me in getting a new job.

Michael W.