Hi all
I have a set a data that has N/A in there with numbers also
I have created a pivot table at the back of this data using an average function
How can i get the pivot table to ignore these N/A values that are stored as text
I export this data out and reformat via code therefore I can change the value of N/A to a non text N/A if thats easier to do and then somehow need the pivot table to ignore the N/A in the average section
How can I achieve this
Thank you
I have a set a data that has N/A in there with numbers also
I have created a pivot table at the back of this data using an average function
How can i get the pivot table to ignore these N/A values that are stored as text
I export this data out and reformat via code therefore I can change the value of N/A to a non text N/A if thats easier to do and then somehow need the pivot table to ignore the N/A in the average section
How can I achieve this
Thank you
