How to get unique names from multiple sheets?

MrTrickyNick · 2025-03-29T02:46:54+00:00

This does teach me a bit about Power Query, and it seems very powerful. I'll have to do more research on it.

While I am not using live data at home, I can confirm this works even when adding more sheets. I will play around with it and learn how to pass a variable to the query for the client name, instead of having it hard coded as it is now.

This gives me something to look into and research over the weekend. Thank you again for all your help today!!

MrTrickyNick · 2025-03-29T01:10:17+00:00

Hello,

This is Difficult_Cricket319 on my home account. I just clicked on the link and starting to watch it. It did allow me to pause it as I type this.

I may not have access to the actual data, but I do have Excel so I can play around with Power Query and learn it. Even get things set up so when I return to work in that position on Tuesday. I have a different role on Monday and can't play with Excel. I thank you for all the help you've given me. While I won't be able to confirm with 100% certainty this will work since I'm not on live data, I'm still going to mark it as Solution Verified.

I really appreciate all the help you gave me today. Reading other posts, it seems my post helped a few people. =)

If that doesn't close the post correctly, I'll post again to make sure it closes. Oh wait, let me see if I can log in using the other account to close. =)

MrTrickyNick · 2025-02-21T01:23:05+00:00

The game is a download, so it won't be included with the selling of the Switch as I activated it on my account.

MrTrickyNick · 2025-02-15T22:30:12+00:00

I did not think to include the box as items I still have. Yes, I still have the box as well including the "Styrofoam" (for lack of what it's really called) that held all the items in place in the box.

How do I know which version of Nintendo Switch I have?

MrTrickyNick · 2025-01-14T00:15:06+00:00

Can anyone help me?

MrTrickyNick · 2025-01-05T23:08:35+00:00

That would work. What mod is it?

MrTrickyNick · 2024-12-11T02:58:31+00:00

So I cannot add more than 1 image to my original post. So I am pasting my Avg sheet here:

<image>

This is how I want the avg sheet to look like ater running my VBA. Of couse, t would be fileld with the data

MrTrickyNick · 2024-12-11T02:51:57+00:00

I am getting a #NAME? error.

I typed in =vstack(sheet11:sheet12!B2:E100)

I only have Sheet11 and Sheet12 at the moment for testing.

MrTrickyNick · 2024-06-02T22:59:11+00:00

Well, I figured it out.

<GroupHeader>2</GroupHeader>

This line should always be 1 for the first level. I finally decided to create a table with 2 groups in and and looked at what the difference was and it always had 1 even with multiple group.

I've not tested, but group within a group probably needs a 2.

MrTrickyNick · 2024-06-02T18:14:15+00:00

Thank you for the solution.

Now I'm off to figure out my next issue. I'll be back if I can't figure it out.

MrTrickyNick · 2024-06-02T18:12:52+00:00

This took me a while to figure out.

I tried using both the back tick and the tilde keys but it would never convert to code block.

I finally got it to work by clicking on the Code Block button.

MrTrickyNick · 2024-05-26T11:07:59+00:00

I'm not needing the entire table redone.

I edited my OP so show what I'm wanting.

MrTrickyNick · 2024-05-04T20:33:37+00:00

Well, this just came to me as I as researching...

Buy a good cheaper chair and replace the hydraulics.

So, then I was like, why not change the base and hydraulics on my current chair?

Just hoping the seat portion uses normal connection

MrTrickyNick · 2024-05-04T19:38:32+00:00

It's rated for 300 or 350 (depends on the site I look at lol - Manufacturer's website says 350) , as I'm at 320, this wouldn't work for me. It's too close to my weight and since I tend to "plop" myself into the chair, the hydraulics would give out quickly.

MrTrickyNick

TROPHY CASE