same thing, I always muddle the words.

That thing at the bottom is it.

That's what I can't find. In a normal table I can't see the option. I know where it is in a pivot.

So yeah, slicers have issues.....

Here was my workaround: https://exceljet.net/formula/get-month-name-from-date

And here's an explanation of the issues, although his workarounds didn't work for me. Because I can't delete the original dates, and doing a custom list is impractical.

https://www.myonlinetraininghub.com/sorting-excel-date-slicers

Hello all, I can't yet load my own copy of Excel to try stuff out. But looking at the progress you've been making Face, I will simply ask instead. I have only four work days left (which would normally be spent chucking pallets around) and have suddenly been asked if could create a sign in and out system for the trucks and stuff. I've discussed the political stuff with them, I've let them know what their responsibilities will be, and now I'm neck deep in Excel and have no way to practise at home until my account is unfrozen

So erm, HALP, are you using a form to input data. If so can I create cascading choices based on other sheets/books? So in an ideal world I run this off two master tables. One that is all the vehicles, their reg, model, type. Then a second with all employees, what vehicles they are qualified to drive. The idea being that they scan their card, it looks them up in the driver/operator/employee table and then the next contextual drop down (I think contextual is a keyword that I should google later) only offers vehicles they are qualified to drive. The next offers the registrations of the vehicle type they chose. Then I need to add more as well

Turns out a dude on the Excel forum had the answer for me, I'll post it later.

Cheers Face, should be free tomorrow and I'll have deep dive. Trying to do everything within Excel because I want the guys to be able to maintain it themselves after I've gone

It's a warehouse environment, as with other retailers I've worked with the IT is dedicated to the webshop, and ignores the nuts and bolts. A guy created a sign in sheet once with a load of VB Macros, but they can't get any help with it, because he's on other projects. Being as I'm leaving next week, I want to build something simple that they can build on top of, as long as I leave enough documentation

As a SQL/DB/BI dev, I'll never argue against "OG Tables"

hmmm.

Toying with various methods of comparing new vs old client lists to find differences. After a bit of playing with power query, it seems easy enough to spit out a table with 2 tables joined side by side. 

Found a vid online that seemed to show how to make just unique rows appear, but mine isn't quite doing the same. (filtering by blank in first column seems to get same result though.)

My issue is I want this to be doable by a muppet, and it needs to be done monthly. Do I show someone power query, or do I create something using formulas etc to get same result that works in more traditional way for regular folks?

I hate that, I totally get it, I know why it's super useful, and it is super impressive. It's a layer of abstraction I always worry about what other assumptions it might make about my data. I really should just chill out about it, but I'd get annoyed when Analysis Services would automagically create heirarchies for my dates or addresses. Although I say annoyed, I might have just been jealous that I didn't know how to do it as quickly or simply, and it hides it under the hood so I can't reapply it elsewhere. 99.9% of the time it works perfectly and is exactly what yo wanted but I'm always reminded of

cockbeard wrote:

I hate that, I totally get it, I know why it's super useful, and it is super impressive. It's a layer of abstraction I always worry about what other assumptions it might make about my data. I really should just chill out about it, but I'd get annoyed when Analysis Services would automagically create heirarchies for my dates or addresses. Although I say annoyed, I might have just been jealous that I didn't know how to do it as quickly or simply, and it hides it under the hood so I can't reapply it elsewhere. 99.9% of the time it works perfectly and is exactly what yo wanted but I'm always reminded of

It's a tool like any other. Fit for certain purposes. It's still always best to "know the data" before using a tool to do any heavy lifting.

lol. IT just screwed Power Automate by changing sign in stuff and adding 2f autho to everything. Pain in the ass. Don't mind not using PA as much, but it does mean I need to revisit a spreadsheet I made for one of the programs and rebuild it basically from scratch using Power Queries.

OK. I make macros at work and put together recs that run off of them.
I used to like Excel until it because a unified Office suite of software and now it's rife with bugs.

The most maddening thing though is that if you run a macro that can take a while Office locks your Outlook as well meaning that you can't send emails while you wait for the macro to finish running.

I've tried googling to see if there's a way to disassociate outlook from the macro's process but I haven't managed to find a solution that works.

cockbeard wrote:

Have a chrome tab open at owa as a fallback position ???

Tends not to play well with shared inboxes