Forum Discussion
Relative Reference
I am trying to write a formula for PowerQuery that looks at a cell value and if it equals a specified value retuns the value of a cell that is in the next row and over one column. I want this value t...
Since i could not get the ref to work i ended up doing the following
Adding two Index columns one starting with 0 the other with 1
Doing a merge table with itself and refrencing the two index columns. this shifted the time values to the same line as the Action and then it became a simple if statment without the ref.
Thanks all for the ideas& help on this one!
I do have an "Index" column that I added when trying to figure this out. It starts at a count of 1.