CODEWITHSUNDEEP
excelexcel-formula
Craig Ross
Craig Ross

Reputation: 1

Formula returning multiple info and going to new row

I am trying to figure out a formula, have no idea where to start, that will bring back multi cell information, based on if one cell has a "x." Data Source

Using the spreadsheet attached, I need the information in Start Date, Full Name, and EEID to be return to a new spreadsheet if the cell A (before the date) has a X in it. It then needs to put the next line with a X on the next available line on the new spreadsheet. Thank you

Upvotes: 0

Views: 74

Answers (1)

Ike
Ike

Reputation: 13064

If you have Excel 365 current channel you can use this formula:

=CHOOSECOLS(FILTER(A2:I100,A2:A100="x"),2,7,9)

Assuming that your table starts in A1

UPDATE - avoid using CHOOSECOLS

=LET(v,FILTER(A2:I100,A2:A100="x"),
INDEX(v,SEQUENCE(ROWS(v)),{2,7,9}))

Upvotes: 1

Related Questions