Hi,
I need to read data and see if a value has changed later on down the file and add it to a new column, i can check if a previous or next row has been modified but would like to check all the rows
Name | workerID | Date | Workplace |
john doe | 1 | Jan | home |
john doe | 1 | Feb | home |
john doe | 1 | Mar | home |
john doe | 1 | Apr | office |
mr man | 2 | Jan | home |
Expected outcome
Name | Worker ID | Date | Workplace | current workplace |
john doe | 1 | Jan | home | office |
john doe | 1 | Feb | home | office |
john doe | 1 | Mar | home | office |
john doe | 1 | Apr | office | office |
mr man | 2 | Jan | home | home |
Solved! Go to Solution.
Hi @Fquinn , here is one way to do this:
Hope this helps!
thanks both, tested with the sample method and works perfectly