ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Sort (https://www.excelbanter.com/excel-discussion-misc-queries/107836-data-sort.html)

SJT

Data Sort
 
I have a database of four columns. The first column is product type and the
second column is client name. The first product type consumes approximately
the first 20 rows. If I wanted to just sort those first twenty clients
alphabetically w/o affecting the rest of the data can I do that? or does the
entire table have to be sorted? Thank you in advance for your assistance.

Bob Umlas

Data Sort
 
If you select more than one cell, Excel will sort the selection. Otherwise
it will sort the current region. Therefore, select A1:A20 (or whatever the
range is you want to sort).

"SJT" wrote in message
...
I have a database of four columns. The first column is product type and
the
second column is client name. The first product type consumes
approximately
the first 20 rows. If I wanted to just sort those first twenty clients
alphabetically w/o affecting the rest of the data can I do that? or does
the
entire table have to be sorted? Thank you in advance for your assistance.




SJT

Data Sort
 
Thank you for your hlep.

"Bob Umlas" wrote:

If you select more than one cell, Excel will sort the selection. Otherwise
it will sort the current region. Therefore, select A1:A20 (or whatever the
range is you want to sort).

"SJT" wrote in message
...
I have a database of four columns. The first column is product type and
the
second column is client name. The first product type consumes
approximately
the first 20 rows. If I wanted to just sort those first twenty clients
alphabetically w/o affecting the rest of the data can I do that? or does
the
entire table have to be sorted? Thank you in advance for your assistance.





Dave Peterson

Data Sort
 
I never let excel guess what I want sorted. I always explicitly select the
range.

SJT wrote:

I have a database of four columns. The first column is product type and the
second column is client name. The first product type consumes approximately
the first 20 rows. If I wanted to just sort those first twenty clients
alphabetically w/o affecting the rest of the data can I do that? or does the
entire table have to be sorted? Thank you in advance for your assistance.


--

Dave Peterson


All times are GMT +1. The time now is 08:27 PM.

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