Excel question

[Passacaglia]

So I've got a spreadsheet, and I'm using the AutoFilter function so only some of the rows are visible -- at the moment, it's rows 17, 35, 47, 59, 65, 89, etc. They're sorted by Column V. When I sort them by Column W, the orders get shuffled around like they ought to, but the row numbers stay the same -- 17, 35, 47, 59, 65, 89, etc. What I want is for the row numbers to get reshuffled to where they should be if the filters were off, without having to turn off the filters, sort, then set my filters again. Anyone have ideas?

Thanks!

[SteveMax58]

I don't believe that is possible to do. When Excel resorts filtered columns it only sorts the data that is currently filtered.

You could likely create a macro to unfilter, sort (as desired), then re-filter again but I dont know of any other way to do it while the columns are filtered.

[Suburban Rhythm]

Maybe I am missing the point, but...

If you want the results sorted by column W, and filtering for certain results appearing in column V...sort by column W first. Then filter. You will still only get the results meeting the filter requirement, but already be sorted.

[mrsimperless]

It was described prety well above but...

Filter != Sort

[Passacaglia]

Originally Posted by Suburban Rhythm

Maybe I am missing the point, but...

If you want the results sorted by column W, and filtering for certain results appearing in column V...sort by column W first. Then filter. You will still only get the results meeting the filter requirement, but already be sorted.

This is just one example -- there's many different filters I do, and I don't want to undo the filters, then sort, then redo the filters the way they were before, every time.

[Passacaglia]

Originally Posted by mrsimperless

It was described prety well above but...

Filter != Sort

I don't know what you're trying to say here.

[Suburban Rhythm]

Originally Posted by Passacaglia

This is just one example -- there's many different filters I do, and I don't want to undo the filters, then sort, then redo the filters the way they were before, every time.

Are you going to be altering data to the main table?

If not, and merely need to view the filtered data as sorted as you describe, copy/paste special the values as they are filtered (17,35,47,59,65,89) to another tab, then sort within the new tab.

You'll only be sorting the filtered data, not the full table.

Otherwise, I don't think I know of a way to sort with the filters on to get you what you're looking for.

[bryce]

Insert a pivot table and change that as needed to filter what you want...

[Passacaglia]

That's a good idea, and I might be able to do that. Thanks!

Oh, wait, inspiration hit -- I was able to get what I want by adding a column with the RANK function to my sorting macros. It's still wonky once I do take out the filters, but at least I have the info on where each row should be.