How to use OFFSET
In this Video I show you how to use the OFFSET Function within Excel to select a cell or cells based on a given start point,
I combine Office with SUM and MATCH to make a dynamic formula that can change and calculate based on a cell changing.
Please excuse the intro being for the wrong video, it had been a long day.
For more on SUM check out • Basic Formulas in Excel
Form more on MATCH Check out • How to use index and Match
Music: https://www.bensound.com
If you like this video check out my channel at:
/ baldgeekuk
Check out my other videos on
Smart List • How to Create SMART Drop Down Lists in Excel
DSUM • How to use DSUM in Excel
If you are interested in full day session on any Microsoft Office products check out my website at
http://mpm-computers.co.uk/
Let's Connect on Social Media
Instagram: / bald.geek.uk
Twitter: / markmpmcomputer
LinkedIn: / markmckenna1