Welcome Guest
Log In | Register )
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
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
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 :
   


ABCDEFGHIJ
112345678910
20244656130
30112344566
410182934657

 

    Can this be done ? Thank you very much everyone for helping.