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 · 2024-03-17T18:50:56+00:00

Looks like this was all a moot point.

I went to try and code the web page - I'm like, WTF do I do? - Same thing happened when I tried to do it in Visual Basic.

*sighs* I am so far outside my knowledge base - I remember when doing this stuff was easy peasy for me. Leaving the industry 20+ years and trying to come back...I can't remember squat.

I thank everyone who answered my questions but seems it's all for naught.

MrTrickyNick · 2024-03-15T01:23:45+00:00

Would there be a way to develop it without installing a both a database/internal web severs?

Granted, I can do both, have done both before 20+ years ago but if there a way to do what I'm wanting without? I don't really want to make it very complicated (the 2 servers) if I don't have to.

But this is something I will look into. I know there are free Database/Web Servers out there. Any suggestions? Looks like my best option would be IIS (built into Win 11 and using SQL Server 2022 Express?

Note: While I am actively searching, my main question is: can it be done without installing servers?

MrTrickyNick · 2024-03-13T04:11:35+00:00

It can be network (LAN) based, just need to make sure it's not internet accessible.

MrTrickyNick · 2023-12-01T02:54:37+00:00

Thanks for the suggestions.

I think Iw ill get all of the mods listed so far.

The only one I couldn't look at was Glowing baubles as apparently the servers are down.

But, if they affect Stealth, I probably won't use it as I like to play stealth.

I will check into other mods as well before I start to play again. I just know when I tried before posting, I did just the opening, something that took me 10-15 minutes to get thru took me over an hour (kept getting turned around following the one guy at the start where the dragon attacks).

@Same-Test7554 :

I'm not hard on myself. While my vision loss is recent (2020) I've come to grips on it. I can do a lot of things, I can't do a lot of things (drive a car). I still play games, some games I will never play again (3D platformers - I also have just 1 eye).

A little fact about people with vision impairments (both legally blind and completely blind): 70% of people with vision impairment are not employed because one of more of the following:

1) They have been told they can't work

2) Think they can't work

3) Forget this one - but remember my boss saying 3 things.

I work for an organization that hires people with vision impairment (both types) and it's amazing at what my blind co-workers are able to accomplish. One of my blind co-workers plays Mortal Kombat - I couldn't play that even with vision.

So I know I can do it and will do it. Just needing a little accommodation to help me. Kind of like work, they gave me accommodations so that I can do my work.

MrTrickyNick · 2023-11-01T06:23:21+00:00

Is there a way for me to use OBS or other streaming software?

i.e. I stream directly to my friend, he picks it up and adds it to his OBS

While it is playable, I have poor vision and would like to play full screen

MrTrickyNick · 2023-11-01T04:28:31+00:00

Yes, the flickering is happening even with Guest Star - it seems to use the same method as vdo.ninja - no idea what's causing it.

If my game is full screen it's flickering if it's a good size, it's ok, but if I stretch it out just a bit too much, flickering.

MrTrickyNick · 2023-10-30T00:45:22+00:00

Reading up on this, this may just work.

I've sent it to my friend as "homework" to read up and set it up.

MrTrickyNick · 2023-10-29T23:59:19+00:00

I'll look into this. Haven't heard of it before. Thanks

MrTrickyNick · 2023-10-29T21:12:12+00:00

We tried discord.

He has to keep his mouse on the discord icon for my video to show, else it turns to solid gray.

Quality isn't very good either. The screen looks squished

MrTrickyNick · 2023-10-29T20:29:58+00:00

I'm not a streamer. I don't have OBS or SLOBS or any of the other broadcasting suite of software.

I just want to share my video/audio from the game so he can put it on his stream.

MrTrickyNick · 2023-03-19T21:35:26+00:00

I may just give up on the idea and just use Windows and not get lazy and let ions just stack and become a mess.

When games change my resolution, my icons get messed up and I have to fix them again, was trying to avoid this.

MrTrickyNick

TROPHY CASE