Number position

[smandula]

I would like to count the Lottery position as a total per number .
Such as Sheet2 would have the base data:
Date 1 2 3 4 5 6
12/22/2006 40 3 38 22 25 48
12/23/2006 40 48 1 49 13 14

On Sheet1 the count would occur. Therefore, 6/49
would be the following.
Number 1 2 3 4 5 6
1 1
2 1
:
40 2
:
48 1
1
49 1


The position total would increment with each date.

With Thanks

 

[T. Valko]

Try this on sheet1 cell B2:

=SUMPRODUCT(--(ISNUMBER(MATCH(Sheet2!B$2:B$3,$A2,0))))

Copy across then down as needed.

If you don't want to see all the 0's format the cells as 0;-0;;

Biff

 

[smandula]

Thanks a Million.

It works great.

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff