ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i sort items using two rows per item in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/33414-how-do-i-sort-items-using-two-rows-per-item-excel.html)

primus4000

How do i sort items using two rows per item in Excel?
 
Sorting single rows is simple, but is it possible to sort items that contain
information in two rows so that both rows stay together? How?

CLR

You will need a helper column that contains information to tie the two rows
together in their proper relationship, such as Xxxxxx001, Xxxxxx002, etc etc
with the "x"'s being your primary sort data...........then when you sort on
that column things will be together.

Vaya con Dios,
Chuck, CABGx3


"primus4000" wrote in message
...
Sorting single rows is simple, but is it possible to sort items that

contain
information in two rows so that both rows stay together? How?





All times are GMT +1. The time now is 03:11 AM.

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