Forum Discussion

StevenConrad1's avatar
StevenConrad1
Copper Contributor
Dec 30, 2021

Formula to extract running data.

I am using Excel 2010. I have a simple spreadsheet that I am attempting to extract data from. I need a formula in cell E3, E:4, E:5, ect… that will look down column A:A to find a value that starts wi...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 30, 2021

StevenConrad1 

For this

in E3

=IFERROR(  INDEX(A:A, AGGREGATE(15, 6, 1/( LEFT(A:A, LEN($E$1) ) = $E$1)*( ROW(A:A)- ROW($A$1) + 1), ROW() - ROW($E$2) ) ), "" )

in F3

=IFERROR(  INDEX(B:B, AGGREGATE(15, 6, 1/( LEFT(A:A, LEN($E$1) ) = $E$1)*( ROW(A:A)- ROW($A$1) + 1), ROW() - ROW($E$2) ) ), "" )

and drag them down till empty cells appear. Above are regular formulae for 2010.

Resources