OFFSET formula returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.

Live Example here:

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

You can find a lot of useful Excel resources on the following site:

#Excel #ExcelTips #ExcelTutorial

Nguồn: https://otrasnoviaxeiro.com/

Xem thêm bài viết: https://otrasnoviaxeiro.com/category/cong-nghe

Leave a Reply

Your email address will not be published. Required fields are marked *

Comments

Raj Najat December 28, 2019 at 3:34 am

A very informative video explained with simplicity. Thanks for the effort !

Reply

J C December 28, 2019 at 3:34 am

This is really done quite well. Thank you. Really, this is a terrific picture. One could just pause the video and think about it with the power you've given one. Thanks again, and God bless.

Reply

sheetal kumari December 28, 2019 at 3:34 am

Thank u sir..

Reply

Luke O'Neill December 28, 2019 at 3:34 am

Thank you! Very clear explanation.

Reply

zak zeko December 28, 2019 at 3:34 am

I used offset with counta function to create automatically extended plot range… but it was according to a cells computed from formule… so it does not work well with me …do you have a solution for this? Thanks at all

Reply

Romesh Kirpalani December 28, 2019 at 3:34 am

But what is the use of offset function in a broader context?

Reply

Jagadeep Reddy M December 28, 2019 at 3:34 am

Thanks for the clear explanation !

Reply

Niranjan James December 28, 2019 at 3:34 am

Thank you .. that was explained very well.

Reply

Jen Benedix December 28, 2019 at 3:34 am

I'm trying to print multiple columns for each row on 1 line for example
john smith week 1
john smith week 2
john smith week 3
john smith totals
currently i have page breaks between the weeks but that gives me about 800 pages for all my rows.
I saw an answer on in the forums that said to use the offset function but I have no idea where to put it or how it would really work?

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *