12.9. Scatter plot | Excel pivot tables COURSE

[@jameswelch122]

For anyone else reading this who may want to copy the function, here's the first instance of it in the video:
=OFFSET(Sheet1!$A$2;0;0;COUNTA(Sheet1!$A:$A)-1;1)
(I am using 2019 Excel and had to use commas rather than semicolons)
##############################################################
The 5 arguments are as follows:
- Reference: Where you want to start in reference to
(The first row with data in the first column)

- Rows: How many rows over from the reference point you want to use as a starting point
(We are using this cell as a start, so 0)

- Columns: How many columns over from the reference point you want to use as a starting point
(We are just using this cell as a start, so 0)

- Height: How many rows down do you want to capture from the reference point
(COUNTA gets the number of non-empty cells in the column, then we subtract 1 for the header line above)

- Width: How many columns wide you want to capture from the reference point
(We just want this column, so 1)

[@aditimehta4248]

thnkss dude.. i thought why the formula was not working for me

[@jlruivo]

Thanks! You saved my day!

[@stefdereys9155]

Thanks. This was really magical. Great help.

[@SkuteczneRaporty]

Nice to hear that 🙂

[@guthrie_the_wizard]

Very cool - thanks!