Multi Row Formula help

[WestonProhaska]

I want to create a new column and every time my condition is met with the value of the row directly under said condition. My data is super messy because it's being read from a pdf. There's no other identifiers that would grab those rows of numbers I need or else I'd just use a filter and wouldn't be here. I've included an example of my data and what I would want the output to be if my logic flow isn't clear. 

Here's the logic:

IF row above = "LPartner'scapitalaccountanalysis:" THEN output column = row below ELSE do nothing

AND IF row above = "CapitalContributedduringtheyear$" THEN output column + 1 = row below  ELSE do nothing

AND IF row above = "YOUREFFECTIVEPERCENTAGEIS" THEN output column + 1 = row below ELSE do nothing  

ENDIF

The data repeats every 1000 records or so for 66,000, so all the naming is the same. Essentially I'd want this to repeat for my whole set of data. 

Data                                                      Output column

LPartner'scapitalaccountanalysis:	1
1	2
m	name
Beginningcapitalaccount$	5
mm	6
Capitalcontributedduringtheyear$	name 2
2
YOUREFFECTIVEPERCANTAGEIS
Name
LPartner'scapitalaccountanalysis:
5
m
Beginningcapitalaccount$
mm
Capitalcontributedduringtheyear$
6
YOUREFFECTIVEPERCANTAGEIS
Name2

[fmvizcaino · Accepted solution]

Hi @WestonProhaska ,

Attached is an example with the logic you need. I understood your table but the logic was not clear to me, so maybe I oversimplified your problem.

Please, if this is what you are expecting, mark the answer as correct, if not, let me know 🙂

Best,

Fernando V.

[WestonProhaska]

It took some tweaking because I simplified down the data, but it works. Thank you so much!