ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I permute the cells of a column (https://www.excelbanter.com/excel-discussion-misc-queries/39319-how-do-i-permute-cells-column.html)

How do I permute the cells of a column

How do I permute the cells of a column
 
I was wondering if there is a function or a command or macro that lets me
permute the contents of a column - such that the resulting column has the
same entries but in different order?

Dave O

As an idea, you could insert a new column that holds random numbers,
and perform a sort on that column.



All times are GMT +1. The time now is 10:17 PM.

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