View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mossi Mossi is offline
external usenet poster
 
Posts: 4
Default Count without SUMPRODUCT


Im trying to count how may occurrences of a number there are, for a letter
in the same row, for the following table (~{a,b,c}{1,2,3,4,5}~)

|.a c 1 2 3.|
|.b c 2 3 4.|
|.a c 3 4 5.|


The result should be the matrix
1 2 3 4 5
a 1 1 2 1 1
b 0 1 1 1 0
c 1 2 3 2 1


Tanks
Mossi.pt