Need to know if it is possible to right a formula that would auto sort in abc order column 1 but move all the data in the row with it.
Need to know if it is possible to right a formula that would auto sort in abc order column 1 but move all the data in the row with it.
You could do this in a separate table using the first one as data source. But why not just use AutoSort?
Select all the data in the table and with the sort field (column A ?) the active cell click Data and then click Sort. When the field sorts it will carry each record (row) with it.
Dave
That worked great. TY
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks