Hi guys I am desperate believe me I need your help. I have to sort row B which is unsorted so that it looks the same like row A which is sorted. Data is the same but in different order . I have sorted row A: a321 a123 a526 a978 a654 etc and unsorted row B with same values but in different order a654 a321 a978 a123 a526 I want to sort row B so it look the same as the row A a321 a123 a526 a978 a654 Can anybody help me? I have to finish it till tomorrow and If I will have to do this one by one I will be finished at the same time when I have to go to work. pls anybody??!