Google Sheets Data Cleaning | Find & Highlight Errors Automatically

In this video we start a new series on google sheets data cleaning techniques. The first technique is to automatically find and highlight errors in your dataset based on a master list. This will allow you to identify where values do not match a master value list and make filtering and visualisation easier.
► Support DSMStrength HERE: www.buymeacoff...
►Purchase The Athlete Dashboard HERE: tinyurl.com/DS...
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength...
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength

[@m.debaser4]

I did this formula with other dataset as a way of practice, but I had to put one more row (in your example D3) to get the highlights right and I dunno why, weird lol

[@kateorias3328]

Thank you so much, this helped me a lot!

[@DSMStrength]

no problem thanks for watching