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?
Gelöst! Gehe zu Lösung.
I tweaked it a bit to fit other scenarios but this method works perfectly! Thank you