how to sort the same as column a

  • Thread starter Thread starter How
  • Start date Start date
H

How

Hello,

I would like to sort my column B data in same sequence as column A.
Anyone please advice

Example.
Before sort::

ColumnA ColumnB
1 2
2 5
3 3
4 1


After sort::
ColumnA ColumnB
1 1
2 2
3 3
4
5 5
 
Sort the first column (A) without expanding the seletion to the second column
(b), then, use the following formula in column C to match the values:

=IF(ISERROR(INDEX(YourData,MATCH(A1,YourData,0),1)), "",
INDEX(YourData,MATCH(A1,YourData,0),1))

"YourData" refers to column B. You might want to give it a name to make life
easier. Then, simply drag the formula down.

--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
LATEST INTERACTIVE TUTORIAL:
http://www.msofficegurus.com/videos/StepByStep_HT_Chart.asp
FORUM: http://www.msofficegurus.com/forum/
 
thanks. but i am not able to sort. My excel version is 2002.

Secondly, I would not like to sort A. Is it possible to do that?
 
Back
Top