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 fi...
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.
