Stocks

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

Duration : 0:7:59

[youtube pZ1ncHkzjt0]

2 Responses

1. ExcelIsFun Says:
   October 30th, 2009 at 5:08 am

   Dear motifman22,
   …
   Dear motifman22,

   Life is like a boomerang!

   –ExcelIsFun

2. motifman22 Says:
   October 30th, 2009 at 5:08 am

   It’s a shame that …
   It’s a shame that these are great tutorials, but us viewers are so highly distracted by the speaker’s voice that it isn’t worth watching. It’s easy to find other tutorials that are much easier to listen to.

   You’re your own worst enemy.

Leave a Comment