Multi Row Formula & Grouping

[MysticalAz]

Hi Community,

I attached a sample input and expected output. What I'm trying to do is group together the rows by device type to see which row had an implant and a replacement device. 

The logic here is:

If patient = row + 1: patient and device type = row +1: device type and explanted date = row +1: implanted date, then the row that has a match should be aligned as a replacement device and not a separate row.

Any idea what formula I could use here?

[SPetrie · Accepted solution]

Without seeing more data examples, I wouldnt feel confident in a multi-row formulas accuracy.

Would a join work?

If you split the data into implant and explant and then test on the fields you mention, you get the same results, at least with this data set.

[MysticalAz]

I tweaked it a bit to fit other scenarios but this method works perfectly! Thank you