That's what I have been saying. I have not done anything different that what I have been doing and had said earlier on. I highlight that section, click on filter under the data tab, click on the filter tab that is comes up on "358", click on sort from smallest to largest, and instead of just sorting out 1-10 the whole page is sorted.
I really don't know how else to explain it...
Sorry to labour this but I need to understand exactly which cells you are selecting, filtering and sorting. By that I mean cell references.
'that section' is not explicit enough, what do you mean by 'data tab', what do you mean by 'whole page'.
As I interpret your request, although clearly not presumably what you're doing, when I select A19:M29 with the 'my data has headers' selected and then choose to sort it by the '358' column I end up with exactly what you show in A33:L43.
I'm not clear why you even need to filter it.
If the A19:M29 range in your example is not your complete list of data in the real world then upload an example workbook which does contain a representative sample of your data.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks