See there are 2 rows and 6 columns
1st row has values : 4,232,808,4444,909,45
2nd row has values : 39,4545,444,343,455,66
now when i sort using the simple sort function it is displaying
Frst row : 4,45,232,808,909 ,4444
second row : 39,66,444,343,455,4545
i.e,. it is just sorting the row..but the 39 present in the second row should come to the frst row after 4 for my requirement like
Frst row : 4,39,45,66,232,343
Second row :444,455,808,909,4444,4545
i dnt need excel to differentiate the rows and columns...it should combine accordingly i.e., values from second row should be shifted to frst row if needed like 39 which is present in the second row should come to frst row bcos it is the next greater digit after 4.... I think there must be some simple way which i am unable to find![]()
Bookmarks