Here is an example data table with the 4th column "Desired Formula Column" showing the outcome I am trying to get.
I am looking for a column formula that will enter the data value for sample 1 for each group.
Any help appreciated!
Go to Solution
Hi,Here is a simple formula that I use all the time:
If( Row() == 1,
If( Lag( :Group, 1 ) != :Group,
Lag( :Desired Formula Column, 1 )
View solution in original post
this is a fun question try adding a column to the table with this formula.
If( :Sample Number == 1,
Lag( :Column 5, 1 )
this is not robust but if you do not change row order you should be fine. otherwise just delete the formula once you have the numbers where you want them.
There are no labels assigned to this post.