ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Another sorting problem (https://www.excelbanter.com/excel-discussion-misc-queries/138769-another-sorting-problem.html)

[email protected]

Another sorting problem
 
Is there any way to sort rows to delete duplications, yet keep some of
the information in the row in tact?

As an example, if I have a specific word in column A, lines 2, 19, and
63, with a corresponding 'X' in cells D2, F19, and H63, can I sort so
it removes the duplicated words in column A but keeps the x's all in
one line (so I would end up with the word in A2, with an 'X' in D2,
F2, and H2)?



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

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