Thanks again Max. One last thing i've just realised I need.

If the data is as follows
Week 1 = 1, 2, 3, 4, 8 ,10
Week 2 = 2, 4, 5, 7, 8, 9
Week 3 = 4, 6, 7, 8, 9, 10

Can the results table be displayed as the following so that there are no
gaps at all in the numbers?

week
8
7
6
5
4
3 3 3 3
2 2 2 3 2 2 3
1 1 1 1 1 2 3 2 1 2 1
1 2 3 4 5 6 7 8 9 10 num

"Max" wrote:

Welcome, Mally
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mally" wrote in message
...
Thanks for your help Max. That did the trick!