-
Solved: Offset Function
Need some help generating some named ranges with the OFFSET function. I have a data table that needs to define names. I need to define the OFFSET ranges A4:A500, B4:B500, C4:C500, D, and E. What I need is to make a dynamic chart and use these defined ranges names to make the chart dynamic.
I attached a sample work book.
Any input is in advance appreciated
-
This is what you need for column A name
=OFFSET(Sheet1!$A$4,,,COUNTA(Sheet1!$A:$A)-COUNTA(Sheet1!$A$1:$A$3),1)
adjust the others to suit.
-
Thanks Xld, works very well.:thumb