I have data in listbox1 as follows:
Id b1 b2 b3 b4 b5 b6 P1 P2 P3
1 1 3 5 9 8 7 - - -
2 1 5 4 8 6 9 1 - -
3 3 5 7 9 7 9 1 1 0
4 4 5 8 9 6 5 2 2 1
5 3 2 7 9 5 4 1 2 0
6 3 4 8 9 4 5 2 3 2
P1 is the rezult of equal values of b1,b2,b3,b4,b5,b6 when Id is 1and2,2and3,3and4,4and5, 5and6 while
P2 is the rezult of equal values of b1,b2,b3,b4,b5,b6 when Id is 1and3,2and4,3and5,4and6 while
P3is the rezult of equal values of b1,b2,b3,b4,b5,b6 when Id is 1and4,2and5,3and6
Id is increasing every week
Listbox2 need to return P1,P2,P3 etc.
How do i use code to get this