Hello,
Since my last question got me a near immediate solution, I figured I would try again...
I have a table that lists PO details and I have used the following formula to get a count of the unique values:
=IF(COUNTIF($F$2:F2,F2)=1,1,"")
The table currently has 432 lines and the above formula works fine and I get a total of 137 unique records.
If I create a pivot table within the same workbook, everything works fine but I am trying to create my pivot table in a new file by linking the new file to the master file on the network. When I pull in the Sum of unique values, I get a total of 0. When I do a count, I get a total of 432 which the number of lines in the report.
I am not sure why this would work within the workbook but not with an external connection set up.
Thanks in advance for your help.
Since my last question got me a near immediate solution, I figured I would try again...
I have a table that lists PO details and I have used the following formula to get a count of the unique values:
=IF(COUNTIF($F$2:F2,F2)=1,1,"")
The table currently has 432 lines and the above formula works fine and I get a total of 137 unique records.
If I create a pivot table within the same workbook, everything works fine but I am trying to create my pivot table in a new file by linking the new file to the master file on the network. When I pull in the Sum of unique values, I get a total of 0. When I do a count, I get a total of 432 which the number of lines in the report.
I am not sure why this would work within the workbook but not with an external connection set up.
Thanks in advance for your help.
