Excel Magic Trick #78: OFFSET function
See how to use the OFFSET function to retrieve only a desired cell's content, and how to deliver a range to a Function.
Learn about the OFFSETS 5 arguments:
1. Starting point
2. How many rows (up or down) do you want to move the starting point?
3. How many columns (left or right) do you want to move the starting point?
4. How tall is the range?
5. How wide is the range?
See how the offset FUNCTION can find the latest stock price from a list of prices
See how the OFFSET function can deliver a range to a SUM function
Formula
Author: ExcelIsFun
Length: 07:59
Views: 2648
Tags: cell College Community Deliver desired Excel function Gel Girvin Highline Mike OFFSET only range retrieve to
|
