Welcome Guest
You last visited January 20, 2017, 11:12 pm
All times shown are
Eastern Time (GMT-5:00)

# Xls formula help

Topic closed. Posted 7 years ago. No replies.

 Page 1 of 1
Los Angeles
United States
Member #75410
June 2, 2009
489 Posts
Offline
 Posted: April 10, 2010, 11:55 pm - IP Logged

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.

 Page 1 of 1