Forum Discussion
Filter not working (monetary values)
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, locati...
Hi, Mathetes, and thanks a lot for your interest!
Let's see if my link would work here:
https://greenworking-my.sharepoint.com/:x:/r/personal/damian_dellamico_greenworking_fr/Documents/Documents/01%20Office%20Management/Evenements/2023.01.26%20Petit-d%C3%A9jeuner%20de%20pr%C3%A9sentation.xlsx?d=wf370098120c44e2599a6d68675e0d844&csf=1&web=1&e=XaEPNH
Maybe it won't work. I'm based in France, Europe, and my table is in French (including my costs in Euros).
Yes, I'm aware of the nuance between sorting and filtering. While indeed I just want to sort it through my Costs column only (column A, aka "PRIX TTC", in Euros), my managers may want to sort the data by name of the venues (column C) or their location, and that's why I thought of simply adding a filter and let each one sort it out (or filter it out) as they like best. Perhaps this may result in confusion to you?
I also tried with both ways (only sorting, and only filtering) alternatively. All my values are monetary values, there are no hidden apostrophes, text, or whatever. It must be something very stupid, but so far I'm failing (miserably) to see it. Hence the idea that someone else might be able to see at once what I've been failing to see since a couple of hours ago.
Let's see if my link would work here:
https://greenworking-my.sharepoint.com/:x:/r/personal/damian_dellamico_greenworking_fr/Documents/Documents/01%20Office%20Management/Evenements/2023.01.26%20Petit-d%C3%A9jeuner%20de%20pr%C3%A9sentation.xlsx?d=wf370098120c44e2599a6d68675e0d844&csf=1&web=1&e=XaEPNH
Maybe it won't work. I'm based in France, Europe, and my table is in French (including my costs in Euros).
Yes, I'm aware of the nuance between sorting and filtering. While indeed I just want to sort it through my Costs column only (column A, aka "PRIX TTC", in Euros), my managers may want to sort the data by name of the venues (column C) or their location, and that's why I thought of simply adding a filter and let each one sort it out (or filter it out) as they like best. Perhaps this may result in confusion to you?
I also tried with both ways (only sorting, and only filtering) alternatively. All my values are monetary values, there are no hidden apostrophes, text, or whatever. It must be something very stupid, but so far I'm failing (miserably) to see it. Hence the idea that someone else might be able to see at once what I've been failing to see since a couple of hours ago.
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?
- Sure! Let's see if this time it would work:
https://docs.google.com/spreadsheets/d/1fw-9ui1xsf3ZrluNlr5ecfwW6pSNNguC/edit?usp=share_link&ouid=116582150317483862540&rtpof=true&sd=true- You also need to grant access. I've sent you a request for that
- Many thanks again for your interest, Mathetes!
I've just modified the permission so that anybody with the link can access the copy and play.
Hopefully this time will work?
Now it's 18:03 over here, and it would seem I'm like 9 hours ahead of you. As I'm shutting down to go home, I thank you again and wish you a nice day. I'll see your answer, if any, tomorrow.
Keep well!