Jan 04 2023 06:36 AM
Hi, y'all! Tis weird, but the most basic function of Excel (filtering values) is not working as it should.
I'm building a table with a colum for costs, and the other columns for descriptions, locations, hyperlinks, etc.
I just want to order my table by costs, smallest to biggest, and the filter should do this. However, it isn't working, it leaves everything in roller-coster/zigzag mode, alternating cheap and expensive.
All my costs values are in monetary values. Tries removing that and jsut use the number, same old S.
Wondering what the f I must be doing wrong. Any ideas?
Cheers,
D
Jan 04 2023 06:43 AM
Well, one thought for starters: Filtering and Sorting are two different things. So I'm struck by your use of the word "filtering" when what you're describing as desired is clearly sorting. Are you, in other words, inadvertently using the wrong button or menu command?
If some of the values are text masquerading as values, that can cause difficulties. You seem to address that, and to know the difference. But depending on how the entries in your Cost column are sourced, is it possible that they're not all consistent?
Final question/suggestion: if the workbook in question doesn't contain confidential information, would it be possible for you to post a copy of it on OneDrive or GoogleDrive, and then paste a link here that grants edit access to it. That way we could have a look at the actual workbook.
Jan 04 2023 07:28 AM
Jan 04 2023 07:49 AM
I'm not authorized to use that sharepoint resource. (I suspect it's specific to your company.)
Is it possible to put a copy, so long as there's no confidential data in it, in a more "public" space like GoogleDrive or OneDrive?
Jan 04 2023 07:57 AM
Jan 04 2023 08:52 AM
Jan 04 2023 09:05 AM
Jan 04 2023 11:26 AM
It works if in PRIX TTC column you replace texts like "2 500,00 €" on numbers (2500 in this case) and apply to them currency format.
Jan 04 2023 11:32 AM
The "values" in your PRIX TTC column are a mix of numeric and other. Several rows at the bottom of the table are text rather than numbers. That is evident if you try to sort by that column and what appears is this
When the "Order" appears as "A to Z" it's telling you that what's in the column is text rather than numbers.
I added a column with the english title "Price" and converted the several bottom rows to numbers, and now the Sort window shows this
And sorts (I believe) as desired.
Attached below is the sheet is with that change.