Hi,
as in topic is it possible to pull out values from eg. row+3 based on specified value. (in this example I woullike to pull out the value which is 3 rows below value "Peter")
IN:
Name |
Peter |
Blue |
Green |
Pink |
Yellow |
Peter |
Yellow |
Red |
Purple |
Red |
Peter |
Black |
Gray |
Orange |
Gray |
OUT:
New_1 |
Pink |
Purple |
Orange |
Mutli-Row tool is not good for this case :(
Thanks !
Solved! Go to Solution.
Hey @Wojtek_Dz, I'd say you were on the right lines with the Multi-Row Formula. However, for this case I'd just use it to apply a flag like so:
Which we can then use as a Filter condition to remove the other records:
Following this, you can either leave it or add a select to remove the newly-created [Flag] field.
😮 thanks @DataNath for this pro-tip