Excel 2010 Unique Count in Pivot Tables with Helper Cells/Columns and Sumproduct

[Tony_Caliente]

I am sure many are familiar with this work-around for counting unique values.
Does anyone know if the column, from which the unique values are being sought, needs to be sorted so they the duplicate values are placed one under the other?

My second questions is: may I copy and paste the 1's and 0's calculated by the sumproduct formula so that I don't have to store a formula in a pivot table.

Lastly, and thank you for your patience, may I use the above in a Table (control T Table, not a datasheet)?

Thank you!

[excelgeek]

It will depend on the formula used. Generally it will be a lot more efficient if the data is sorted by the correct column(s).
The formula is not stored in the pivot table, it is in the raw data but, as long as your data is static, you can convert the formula to values.
And lastly, yes you can.