Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data in ascending order
Hi Guys, I need help in sorting a data in ascending order.Hope you guys can help me to solve it.:) Example: BEFORE SORTING: _Column_A_ _Column_B_ _Column_C_ David Student CS Andy Student CU Mandy Faculty CE AFTER SORTING: _Column_A_ _Column_B_ _Column_C_ Andy Student CU David Student CS Mandy Faculty CE I need to sort the data in column A in ascending order. The following columns will changes based on the Column A after sorting. Thanks & Regards Sharon:) -- sharon2006 ------------------------------------------------------------------------ sharon2006's Profile: http://www.excelforum.com/member.php...o&userid=30173 View this thread: http://www.excelforum.com/showthread...hreadid=522012 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data in ascending order
Hi Sharon,
Have you tried the sort function under Data/Sort? This allows you to select which column to sort in what order. The trick is though to make sure you have selected ALL the columns and rows with data in them otherwise excel will sort only those selected columns and you will loose the relationship of data between the sorted columns and those not included in the selection. Hope this helps regards DavidC "sharon2006" wrote: Hi Guys, I need help in sorting a data in ascending order.Hope you guys can help me to solve it.:) Example: BEFORE SORTING: _Column_A_ _Column_B_ _Column_C_ David Student CS Andy Student CU Mandy Faculty CE AFTER SORTING: _Column_A_ _Column_B_ _Column_C_ Andy Student CU David Student CS Mandy Faculty CE I need to sort the data in column A in ascending order. The following columns will changes based on the Column A after sorting. Thanks & Regards Sharon:) -- sharon2006 ------------------------------------------------------------------------ sharon2006's Profile: http://www.excelforum.com/member.php...o&userid=30173 View this thread: http://www.excelforum.com/showthread...hreadid=522012 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pivot Table Ascending Order of Row Field | Excel Discussion (Misc queries) | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions | |||
pivot table in data source order | Excel Discussion (Misc queries) |