ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I match all columns into descending order (https://www.excelbanter.com/new-users-excel/114175-how-do-i-match-all-columns-into-descending-order.html)

Kiwi Jane

How do I match all columns into descending order
 
I have columns A-Gthat include A - Parents name, C-players name, E- Phone
numbers, and G-email address. I want to sort in Alpha order, but all cells
must match the original imput. How do I do this?

Don Guillett

How do I match all columns into descending order
 
have you looked in the help index for SORT

--
Don Guillett
SalesAid Software

"Kiwi Jane" <Kiwi
wrote in message
...
I have columns A-Gthat include A - Parents name, C-players name, E- Phone
numbers, and G-email address. I want to sort in Alpha order, but all
cells
must match the original imput. How do I do this?




Gord Dibben

How do I match all columns into descending order
 
To keep data together as you sort............

Select all the columns prior to doing the sort on whichever column you wish to
sort on.

Then DataSortpick a column and follow your nose.


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 14:50:01 -0700, Kiwi Jane <Kiwi
wrote:

I have columns A-Gthat include A - Parents name, C-players name, E- Phone
numbers, and G-email address. I want to sort in Alpha order, but all cells
must match the original imput. How do I do this?




All times are GMT +1. The time now is 01:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com