🔵 The Excel OFFSET function returns a reference, based on a row and column number.
The OFFSET function can:
-- Find sales amount for selected month
-- Sum the selected month's sales
-- Create a dynamic range based on count
-- Sum the last n month's sales
✅ Get the sample Excel file to follow along
► https://myctx.link/offset
🔶 Instructor: Debra Dalgleish, Contextures Inc.
💡 Get Debra's monthly Excel tips ► https://myctx.link/CtxNews
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips