Hi. I want to display the number of times a number is picked by representing
them in cells on top of each other with no spaces. I tried doing it in a
pivot table/chart but it didn't work.

I have a worksheet with numbers 1-8 (for WEEKS) in column cells A1 - A8
I then have the numbers 1-10 in row cells B9-K9 for the numbers actually
picked.

e.g.
WEEK 1. If in week one numbers 1, 2, 5, 7, 9 and 10 are picked then row
cells B1, C1, F1, H1, J1 and K1 contain the number 1 for WEEK 1

WEEK 2. In week two numbers 1, 2, 5, 7, 8 and 10 are picked. Cells B2, C2,
F2, H2 and K2 will all have the number 2 in for WEEK 2. But 8 is a new
number so I want the number 2 for WEEK 2 to be displayed in cell I1.

Simply, I want the numbers displayed on top of each other in cells with no
spaces depending on the weeks they are picked.

I've got the formaula (below) which displays the numbers but not without the
spaces. The cell references are different.

=IF(OR($E20=B$10,$F20=B$10,$G20=B$10,$H20=B$10,$I2 0=B$10),$A20,"")

Any ideas anyone?