Hello,
For an N group of ID´s I need to test the expected behavior. I managed to do this in Excel using, in the Expected ID column, the Offset formula that is =OFFSET(B2,C2,0).
| Group |
Given ID |
Offset |
Expected ID |
Result |
| Group 1 |
A |
0 |
A |
OK |
| Group 1 |
A |
-1 |
A |
OK |
| Group 1 |
B |
0 |
B |
OK |
| Group 1 |
A |
-3 |
A |
OK |
I tried to do this using the multi-row formula however I have to enter a specific number or rows which in my case is dynamic. I´ve attached an Excel spread sheet with an example. The column I need to create is the Expected ID column.
Any help will be appreciated.
Thanks!
