Thank you for the information. Any chance how to automate adding the new roles to the lookup table? If that lookup table is the one being loaded into PowerPivot, it needs to be up to date because it is the chain between two data tables (who would have an impossible many-to-many relationship without this lookup table)
In Power Query you could automatically append any missing codes to the dimension table but I’m not sure it would help as you still wouldn’t have any description of what that code was.
Ok so seems to be all experts here and a good place to ask: I have 3 cells, A, B, and C. C=A/B. Simple. However, I'd like A or B to be also solved for any input I put into C. Is there some Excel method where this type of entering 2 parameters solves for a 3rd can be done? I do not know VBA.
I’d suggest posting your question here aka.ms/excelcommunity Sounds a bit like using Solver: support.microsoft.com/en-us/office/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040
Nice Video As usual Wyn, keep them going, In the future may you can have a video on how did you create the Toolbar, as I really want to create one for myself Thanks in advance
Great video as always. Couple of things: 1. can you go over the countif formulas that you brought up with the shortcuts. 2. I think you over complicated the hyperlink formula, why not just refer to the cell in 2nd sheet above the table.
Here’s my autocorrect video th-cam.com/video/3xK_e7HQgSE/w-d-xo.html I prefer to link to the actual table, that way it doesn’t matter where the table is moved to. Liking to a cell can break if someone deletes the row or column the hyperlink references
nasty. someone else do exactly what I do. You're the you're the first I've seen. I also use the colored font like blue to designate any calculations in a column as opposed to normal black for static or external data. except for the MMM thing - neat
Wyn, that's a wynner. It's really too bad Tables lack the ability to have spilling in them. It would be easy to just have UNIQUE extract all the Roles or WOs from the Query table and it would be dynamic.
Wow, Wyn so many tips packed in this video. Thanks
You’re welcome Grainne
I love "best practices" videos. This one is a gold mine. Thanks Wyn!
Cheers ziggle314
What is that "ACCESS ANALYTICS RIBBON 🎀🎀"!!!!?????
AMAZING 🤩🤩🤩🤩
Grab yourself a free copy 😁
This is my kind of Excelling, spot on 👏🏼 never thought of using autocorrect for fast formula entry, genius! Off to watch the other video now!
Good stuff Dave!
Thank you for the information. Any chance how to automate adding the new roles to the lookup table? If that lookup table is the one being loaded into PowerPivot, it needs to be up to date because it is the chain between two data tables (who would have an impossible many-to-many relationship without this lookup table)
In Power Query you could automatically append any missing codes to the dimension table but I’m not sure it would help as you still wouldn’t have any description of what that code was.
Ok so seems to be all experts here and a good place to ask: I have 3 cells, A, B, and C. C=A/B. Simple. However, I'd like A or B to be also solved for any input I put into C. Is there some Excel method where this type of entering 2 parameters solves for a 3rd can be done? I do not know VBA.
I’d suggest posting your question here aka.ms/excelcommunity
Sounds a bit like using Solver: support.microsoft.com/en-us/office/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040
Can we create a drop down list in single cell to navigate sheets or different tables by using hyperlink function?
Sure can Emre, I have a video here th-cam.com/video/dNXGODP0oOM/w-d-xo.html
really enjoy this video
Thank you
Nice Video As usual Wyn, keep them going,
In the future may you can have a video on how did you create the Toolbar, as I really want to create one for myself
Thanks in advance
I used the custom ui tool: it was 10 years ago so things may have changed 😆 rlbcontractor.com/using-a-microsoft-office-custom-ribbon-ui-editor
Great stuff 👏👏👏👏👏
Thanks
great content
Cheers
Great video as always.
Couple of things: 1. can you go over the countif formulas that you brought up with the shortcuts.
2. I think you over complicated the hyperlink formula, why not just refer to the cell in 2nd sheet above the table.
Here’s my autocorrect video th-cam.com/video/3xK_e7HQgSE/w-d-xo.html
I prefer to link to the actual table, that way it doesn’t matter where the table is moved to. Liking to a cell can break if someone deletes the row or column the hyperlink references
@@AccessAnalytic thanks for the link to your previous video.
No worries Ron
nasty. someone else do exactly what I do. You're the you're the first I've seen. I also use the colored font like blue to designate any calculations in a column as opposed to normal black for static or external data. except for the MMM thing - neat
Not sure on the “nasty” but thanks I think 😀
Wyn, that's a wynner. It's really too bad Tables lack the ability to have spilling in them. It would be easy to just have UNIQUE extract all the Roles or WOs from the Query table and it would be dynamic.
Yep indeed. I have a video planned to look at a workaround
what did you do after clicking "dddl"..the formula doesn't pop-up for me?
Hi, you need to watch my autocorrect video th-cam.com/video/3xK_e7HQgSE/w-d-xo.html
Which part of Wales are you from Wyn?
Swansea, but now live in Australia 😀
@@AccessAnalytic I thought so, as I am too. Thanks for the videos, I've recently discovered your channel and your tutorials are top class. Diolch
Croeso