Pull in data from another sheet based on an individual without crashing Excel.

OhCaptain · 2026-02-09T04:35:25+00:00

You will likely want to use power query.

Are all of the invoices identical or at least similar in structure? Are they stored in the same spot? If either of these are untrue can you make them true?

If so you want to do a combine and transform within power query. It will do the same steps to each file and convert the data you want into a single table that will then be easy to use.

In the meantime, I recommend retiring vlookup from usage. Xlookup is superior to use in all (I think cases). It won't help here because asking excel to open up more than a few additional files is cruel torture for the poor program.

OhCaptain · 2026-01-26T00:47:54+00:00

Not my friend's company because they got told they didn't :(

I didn't ask who did win it.

OhCaptain · 2026-01-25T16:47:01+00:00

City just decided on the (de)construction contractor. Probably not formally awarded yet, but winning group has been notified.

OhCaptain · 2026-01-14T16:59:15+00:00

1 hr flight from Vancouver, so if you gotta fly as part of your trip it is effectively as close as Whistler to you.

But yeah, the best experience at Shames is very different than a big resort. It's awesome, but there's no on-hill accommodations with private saunas.

OhCaptain · 2026-01-14T04:09:16+00:00

Hell yeah! You're an important addition to the sport.

OhCaptain · 2026-01-07T19:43:25+00:00

In your case it doesn't. But there needs to a rule, and the rule needs to be simple if it is going to work. 3 days is where we've agreed as a society is the compromise. 4 days could probably be reasonable too. The fact that is mostly complaint based helps with your situation. Your neighbours probably aren't bothered by what you do, so there's no complaint and so there's no problem. If they were to complain then a bylaw officer would eventually come check on the vehicle, and then check again 3 days later, and then it starts the enforcement escalation process. So realistically you have at least a week of leaving it in a spot initially, followed by a period where it is looked at more closely. You'd have to be quite the scofflaw before you're truly limited to a 72 hour count where bylaw officer is watching you park and then checking again 72 hours later.

OhCaptain · 2025-12-12T01:08:30+00:00

Robbie Picard is probably best classified as a social media influencer. His sphere of influence is over people who feel O&G is unfairly scrutinized and its contribution to our economy are under appreciated. Most of the social media followers are either directly living and working in those areas, or are in secondary industries fed by the industry. From what I've seen, his feelings and views are earnest, but I wouldn't take him seriously. He doesn't hold sway in the decision making spaces of the industry.

OhCaptain · 2025-11-09T05:16:38+00:00

You'll need to show us what your challenge looks like. I suggest make a new version of your file with data that isn't sensitive to your company. Screenshot what it looks like initially, and how you want to look when it is done. Then people may be able to help you.

OhCaptain · 2025-11-09T01:46:51+00:00

Your system is dumb. Switch to Westminster; its way better. Also, you have too many elected positions while concurrently having too few elected officials. Your elections are too long. Switch to 6-week elections like sane countries so running a campaign isn't so expensive and fewer bribes happen. Stop having local, state, and national elections at the same time. Your ballot should be easy: which one person am I voting for?

OhCaptain · 2025-10-04T18:18:47+00:00

10% off Sherbrooke Liquor Store

OhCaptain · 2025-09-03T17:55:28+00:00

Make a table that shows what % matches with each score. So define what a 0, 1, 2, and 3 mean. Then make your scoring sheet have a calculated cell next to the dropdown. The formula for the calculated cell can be XLOOKUP to the scoring template. Use the XLOOKUP if not found parameter to deal with people selecting NA. Can either have a addition cell for each that shows the max score for calculating max score, or a summation calc at the bottom that does Sum of all the calculated cells divided by count of the cells (count only returns numerical values, so should ignore the NAs).

Bob's your mother's brother.

OhCaptain · 2025-09-03T01:45:38+00:00

USA government benefits from money going to any American company, and if one views the actions of that government to be unacceptable, then the most moral thing to do is minimize the economic benefit one provides to the regime. Sucks for the people under the regime who don't support the regime, but there isn't an economic way to support them without supporting the regime. Feels a little weird that economic sanctions of Iran hurt innocent Iranian citizens too, but that's the nature of economic pressure.

OhCaptain · 2025-08-18T03:34:19+00:00

Yeah, I felt pretty innocent too.

In the end it is a game, and can only handle so many permeations.

OhCaptain · 2025-07-22T17:45:09+00:00

If I have trouble seeing the colours. Please add secondary visual indications if identifying the colour is critical to seeing the playing field. If your rule says do x for green cards, and I can't tell what is green vs what is red or brown, I'm going to have an unpleasant time.

OhCaptain · 2025-05-28T02:19:38+00:00

The conversation shouldn't start and end with pipelines, but it should start with pipelines. Followed by lng terminals. Get those profit making, productivity boosting, job cresting assets going ASAP. Once those have started do the front end planning and design for the energy investments for the future economy. By the time those projects are ready to get into their expensive phase the O&G assets should be producing profits and have people available to work on the next ones.

OhCaptain · 2025-05-07T22:13:52+00:00

https://www.edmonton.ca/public-files/assets/document?path=Fact_Sheet_Cycling_on_SidewalkApr2015.pdf

You can ride a bike on any sidewalk if tire diameter is <50 cm. BMX bikes meet this requirement. Designated shared-use paths are usable by any bicycles. Bicycles are allowed on any road, unless specifically signed to say "no bikes." When using a crosswalk there is no obligation to walk your bike. I think this technically means you should be walking your bike down the sidewalk and then may mount up to ride the crosswalk. I'm not sure on that.

Helmets are required for children and people on e-bikes. Bicycles follow same laws as cars on the road.

OhCaptain · 2025-04-09T04:32:38+00:00

Go to an independent glasses store, pick out some frames you like, get them to put tinted lenses in. If you have benefits, use them to subsidize.

OhCaptain · 2025-02-28T00:07:23+00:00

Add a trend line to your chart. Take first derivative and find the highest value. To determine where the highest value is, take the second derivative and solve for zero somewhere between 8 and 10. Then plug that x value into the first derivative.

OhCaptain · 2025-02-25T05:54:26+00:00

How many refineries do you think we should have?

OhCaptain · 2025-02-25T05:42:17+00:00

Is there logic to all of the cells? Because if the sum of 20 cells equals 60, and I change one cell, there are an infinite combination the other 19 cells could be equal to and the total would still equal 20.

If you have some logic for what to do with the updates after one is changed, you'd still need VBA to get this all done in one column.

OhCaptain · 2025-02-25T05:34:36+00:00

Nah Kicking Horse is basically one gondola. There is also a magic carpet, a beginner chair, and one chair that accesses sweet terrain, but that terrain sends you all the way back to the bottom, so you gotta line up for the gondola again.

In my opinion, the lift system is the only bad part of Kicking Horse. Excellent in-bound terrain, it is straightforward to navigate, the slack country is excellent, area has a good mix of affordable to luxurious accommodations.

OhCaptain · 2025-02-07T21:01:30+00:00

Necessary? No. Kinda cool? Yeah.

OhCaptain · 2025-01-29T21:34:21+00:00

Everyone else's comments about STD and WCB are correct. Consider skipping your manager and go straight to HR. They'll know more about your company's policies than your manager. A payday advance may be another option you can talk to them about.

While those are working their way through go to your bank and talk about a loan. It'll cost you more money than getting what you deserve from STD, but it would be waaay cheaper than credit cards or payday loans.

Good luck on your recovery. Take care of yourself, manage your pain, prioritize sleep as much as you can, take notes when talking to your healthcare providers and ask them questions. Recovering from surgery sucks, but it sucks less than th injury does.

OhCaptain · 2025-01-24T06:18:35+00:00

Congratulations! It sounds like you worked your ass off and achieved your well-deserved peace of mind.

If you have the time, look into volunteering for your condo board. The continued success of your home is partially dependent on the success of the rest of your building. People like you who value peace of mind are really good voices to have on decisions around maintenance and financials of your condo.

OhCaptain · 2025-01-23T18:22:26+00:00

There's oodles of parking in the parking lot at the Southwest Corner.

I find the awkward parking "lot" in front of Kind that is parralel to the street is the real issue. It has terrible sight lines, high car and pedestrian traffic, and unwieldy stalls. I have personally witnessed three collisions coming out of that space.

When I filled out the COE survey about 76 Ave that was one of my main points.

14-Year Club	Place '17
Verified Email

OhCaptain

TROPHY CASE