Formula - to bring back first 5 valuess

%3CLINGO-SUB%20id%3D%22lingo-sub-2026285%22%20slang%3D%22en-US%22%3EFormula%20-%20to%20bring%20back%20first%205%20valuess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20Scenario%3A%26nbsp%3B%3C%2FP%3E%3CP%3EInsert%20a%20column%20before%20column%20A%2C%20rename%20the%20column%20'Account'%3CBR%20%2F%3EIn%20column%20B%2C%20Filter%20the%20data%20to%20text%2Fvalues%20that%20are%20not%20a%20date%3CBR%20%2F%3EIn%20column%20A%2C%20%3CFONT%20color%3D%22%23FF0000%22%3EInsert%20formula%20to%20bring%20back%20the%20first%205%20values%20in%20column%20B%3C%2FFONT%3E%3CBR%20%2F%3EUnfilter%20%26amp%3B%20Fill%20down%20the%20account%20for%20blanks%3C%2FP%3E%3CP%3EThe%20issue%20I%20have%20is%2C%20to%20determine%20what%20formula%20would%20work%20to%20bring%20back%20the%20first%205%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2026285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026518%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20-%20to%20bring%20back%20first%205%20valuess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915646%22%20target%3D%22_blank%22%3E%40mjw0429%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20filtering%2C%20select%20the%20first%205%20empty%20cells%20in%20column%20A%20(below%20the%20header%20in%20A1).%3C%2FP%3E%0A%3CP%3ELet's%20say%20that%20A2%20is%20the%20active%20cell%20in%20the%20selection.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%20%3DB2%20and%20confirm%20it%20with%20Ctrl%2BEnter.%20The%20row%20number%202%20in%20B2%20is%20that%20of%20the%20active%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026939%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20-%20to%20bring%20back%20first%205%20valuess%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026939%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%20very%20much.%3C%2FP%3E%3CP%3EYou%20may%20have%20helped%20me%20in%20getting%20a%20new%20job.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMichael%20W.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

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

@Hans Vogelaar 

 

Thank You very much.

You may have helped me in getting a new job.

 

Michael W.