View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Des Des is offline
external usenet poster
 
Posts: 19
Default Calculate how many customers take SKU's

Hi
I have 9 columns, each with a SKU no starting series 52000 though 52008
Rows are customer no and name

I want to calculate how many customers take 1 SKU, 2SKU's, 3SKU's etc and
put the result either on another tab, or at the end of the columns as listed
above.

How would I go about achieving that?

Many thanks
Desiré