sorting problem

gsrikanth · #1 02-15-2012, 05:33 AM

whole data in one sheet
1. first column to convert to_number

2. sort by distinct village

zyzzyva57 · #2 02-15-2012, 05:54 PM

Could you be clearer what you mean?

gsrikanth · #3 02-15-2012, 11:14 PM

Quote:

Originally Posted by zyzzyva57

Could you be clearer what you mean?

if i sort first column
second column sorting goes
i need second column sorting with first column
like
1 apple
2 apple
.
.
.
1 banana
2 banana
.
.
.
1 cherry
2 cherry
reference attachment xls file

JBeaucaire · #4 02-15-2012, 11:22 PM

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column A descending

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column B descending

gsrikanth · #5 02-16-2012, 12:30 AM

Quote:

Originally Posted by JBeaucaire

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column A descending

1) Highlight columns A:B
2) Open the Sort Wizard
3) Sort by column B descending

ooooooooooo thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting paragraph numbers	CommDude	Excel	1	01-02-2011 04:38 PM
Sorting elements in a row	Riccardo	Excel	2	12-14-2010 10:08 AM
Macro for automatic sorting	Ziggy-R	Excel	13	10-04-2010 06:57 PM
Sorting question	markg2	Excel	4	01-25-2010 03:13 PM
Sorting Outlook TO: field	anakeimai	Outlook	0	09-30-2009 06:15 AM