Richard, I have modifed the formula to fit the file which has more columns which I use to specify unique products and counts and column K= column AT (in my file) gives me always 0 , I have tried to only copy and paste and also CTRL+SHIFT and ENTER but always 0 , can you pls. take a look at the file here ?
Bookmarks