Excel Shift Function vs Chart

The Excel Shift function is a great formula with unique capabilities. Yet this one gets little attention from Excel users and is overshadowed by its more glamorous cousins: the search functions.

Why is this?

The purpose of this video is to explore further possibilities and shed light on the capabilities of the feature.

Maybe it can inspire you to use it in your work.

​

Be sure to download the practice file used in this video.

In a previous video you saw what the basic elements of the shift function can be and 2 simple examples of what they can do.

Now going one step further, we're going to work hand in hand with the compare function to get a value through this, so that the user can see the result in a graph, as well as get a clear search result.

Definitely try to work together with the practice file and try to master the function better.

In another video the shift function is used along with a selection list.

Watch the video HERE

​

Best of luck!

​

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.