I have a pivot table., i am trying to insert offset formula for this table.=OFFSET($A$1,,,COUNT($A:$A),12) but when ever i try to do like that the error message Reference Not Valid has displayed. Any idea to resolve this matter ?
The second problem is in my book I have four sheets in that Exc 1 and Exc 2 sheets are for turnover for different exchanges having date wise data.so what i need is the same data have to be updated automatically in 3 rd sheet that is Both sheet.
but the problem is here in the Both sheet some of the columns need not to be shown.
And the third one , Is there any chance to show the different line graphs for total clients individually? (daily data will be added ).
I am giving my file link here https://www.dropbox.com/s/c7lp0u9cnu...rnover%20.xlsx
Advanced thanks for your help