Thank you in advance to anyone who can help.
First : can someone help me with a formula that would arrange numbers from a different refence list.
Here are the datas :
In Row 1 and in cell : A1: 1 ; B1: 2 ; C1: 3 ; D1: 4 ; E1: 5 ; F1: 6 ; G1: 7 ; H1: 8 ; I1: 9 ; J1: 10 ; ETC…
In Row 2 and in cell : A2: 0 ; B2: 2 ; C2: 4 ; D2: 4 ; E2: 6 ; F2: 5 ; G2: 6 ; H2: 1 ; I2: 3 ; J2: 0 ; ETC…
Row 1 need to be arrange with the reference of Row 2 in a numeric order and when Row 2 encounter
a duplicate " Conditional Formating " would make thoses cells in "Red " color for the first duplicate,
up to 6 differents color for each different duplicate. ( in this exemple all the datas are not here just a few to explain )
So the result would look like this, in row 3 the datas from Row 2 are in numeric order and in Row 4 are the datas
of the Row 1 arranged.
Row 3 0 1 1 2 3 4 4 5 6 6
Row 4 10 1 8 2 9 3 4 6 5 7
Here all datas together :
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
1 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
2 |
0 |
2 |
4 |
4 |
6 |
5 |
6 |
1 |
3 |
0 |
3 |
0 |
1 |
1 |
2 |
3 |
4 |
4 |
5 |
6 |
6 |
4 |
10 |
1 |
8 |
2 |
9 |
3 |
4 |
6 |
5 |
7 |
Can this be done ? Thank you very much everyone for helping.