Formula showing changes and evolution

Question

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 !!!

Book1.xlsx

atcodedog05 · Accepted Answer

Hi @sanastasova

You can accommodate it with a filter like the below.

Hope this helps : )

atcodedog05 · Accepted Answer

Hi @sanastasova

Use a formula tool like below

Hope this helps : )

NikyN · Accepted Answer

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