how can you sort the below one?

December 30, 2010 at 21:40:03
Specs: Windows XP
there are data in two columns as appears:

121212 154878
145785 255478
154878 121212
255478 145785

I need it to be like this, as given below:

121212 121212
145785 145785
154878 154878
255478 255478

The first column being static. Some one help me please.


See More: how can you sort the below one?

Report •

#1
December 31, 2010 at 05:45:17
If your data looks like this:

     A       B
1) 121212  154878
2) 145785  255478
3) 154878  121212
4) 255478  145785

Then simply doing a Sort Smallest To Largest on
column B will result in your data looking like:

     A       B
1) 121212  121212
2) 145785  145785
3) 154878  154878
4) 255478  255478 

Or am I missing something?

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question