F
Fawn Lagimodiere
I have a pivot table that I use getpivot data to get the results.
When I copy down formula referencing to the correct cell the data doesn't
read on some cells.
eg
Column A Column B Colmun C
E12546 Dec 100
E14556 Dec 500
E56894 Dec 50
my get pivot will reference Column A
E12546 will not read with the getpivot formula but E14556 and E56894 will
produce the results.
Not sure if there is a formatting issue with the raw data.
Any help is appreciated.
Thanks
When I copy down formula referencing to the correct cell the data doesn't
read on some cells.
eg
Column A Column B Colmun C
E12546 Dec 100
E14556 Dec 500
E56894 Dec 50
my get pivot will reference Column A
E12546 will not read with the getpivot formula but E14556 and E56894 will
produce the results.
Not sure if there is a formatting issue with the raw data.
Any help is appreciated.
Thanks