Formula showing changes and evolution

[sanastasova]

Hi, 

I have a data set containing information about year 2021 and year 2022. The column year 2021 is fixed and is not going to change. However column "Actual "changes with new name every week. I want to create a new column that shows me only the changes. Ex: if I have Silver in column 2021 and it stays silver I don't need it to be shown, but however if silver becomes gold I need it in the data base. Attached also is an example of the data. Thanks a lot !!!

[atcodedog05 · Accepted solution]

Hi @sanastasova 

You can accommodate it with a filter like the below.

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @sanastasova 

Use a formula tool like below

Hope this helps : )

[atcodedog05]

Happy to help : ) @sanastasova 

Cheers and have a nice day!

[NikyN · Accepted solution]

Hello @sanastasova,

please find attached solution. 

As per table below, you can see on what color in Year 2021 change happened -- if you would like to see only changed items/or not matching ones just apply filter :) 

This way you won't have duplications and see what row/columns has been udpated.

Best Luck!

Niky

[sanastasova]

Thanks a lot for the help and the quick answers !