Is there a way to count unique values in a pivot table? I want to determine if a batch code of stock has more than one expiry date (which it shouldnt) so if the pivot counted more than one it would highlight an error?
Is there a way to count unique values in a pivot table? I want to determine if a batch code of stock has more than one expiry date (which it shouldnt) so if the pivot counted more than one it would highlight an error?
Last edited by katy1985; 06-19-2013 at 06:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks