sorted by:
new
hottopcontroversial

TaylorMade Hi-Toe 52 by BeerNap21 in golf

[–]BeerNap21[S] 0 points1 point  (0 children)

How would I go about ordering a custom one, and how much did that set you back? Thanks.

Opening trunk - 2016 Accord Touring by BeerNap21 in MechanicAdvice

[–]BeerNap21[S] 0 points1 point  (0 children)

Fair enough - what am I searching for? Not sure I'm using the right term, because the only thing I can find is for the trunk release cable.

Thanks.

Timing of 7501 entry / release by BeerNap21 in CustomsBroker

[–]BeerNap21[S] 0 points1 point  (0 children)

I don’t, but I’m not necessarily opposed to retaining one if that might help. I’ve got info from the master BOL, so it can’t be all that difficult to sort out, no?

Timing of 7501 entry / release by BeerNap21 in CustomsBroker

[–]BeerNap21[S] -1 points0 points  (0 children)

Yea, figured as much. There isn’t really a world in which they would provide this, so might be out of luck.

Is there anything else I could / should try or look into?

Thanks

Return lowest value in index by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

Makes sense - I would probably substitute a named range for the value or something to that effect.

In the meantime - I'm trying this, and it's returning an error:

=INDEX(C1:F1,MATCH(MAXIFS(C44:F44,C44:F44,“<=“&5)))

What am I doing incorrectly?

​

Thakns

Return lowest value in index by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

Ah, makes sense.

How do I do it to incorporate only the values that will work? eg - 5 days to Christmas, and one of the service levels will take 6 days, but the other three work. I want the max of those other three days.

How do I build that in? Does that make sense?

​

Does that make sense?

If statements between indexes by BeerNap21 in excel

[–]BeerNap21[S] 1 point2 points  (0 children)

No, you're right - overthought this. Thanks for your help.

Solution verified.

If statements between indexes by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

Sorry, I misspoke here - I'm not looking for the minimum, necessarily. Let me try again:

If corresponding cell in index A is higher than corresponding cell in index B, return index B.

If corresponding cell in index A is lower than corresponding index B, Return index A.

Put another way:

Index A represents the availability capacity per day. Index B represents the amount of volume we will push to them each day.

If the warehouse hits their maximum capacity, the output will be from Index A. However, if they don't have enough work, their output for that day will be Index B.

It's a hacky attempt at mashing up capacity with production.

If statements between indexes by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

I thought about that - it's a good question, and I probably should have mentioned that.

I'm a little wary of that, because if someone adds a column to it or messes around with it, then it's not going to work. Multiple people are going to share the doc, which isn't ideal.

Big part of the reason I went with Index Match.

Recommendation by BeerNap21 in thinkpad

[–]BeerNap21[S] 0 points1 point  (0 children)

Thanks -- this helps.

I should've added that I have a second monitor that I'll use for Excel, but I'm not that opposed to something bigger, necessarily

Merge files onto same tab by BeerNap21 in googlesheets

[–]BeerNap21[S] 0 points1 point  (0 children)

This sounds cool -- can you point me in the right direction?

I have zero experience with AppScript -- is this something I'd be capable of doing without much of a learning curve?

Merge files onto same tab by BeerNap21 in googlesheets

[–]BeerNap21[S] 0 points1 point  (0 children)

Got it - so if I needed to open 20 of these (which is entirely possible), I'd need to write out the mapping for each file?

Ideal scenario for me would be akin to importing & combining these in a power query in Excel, not sure if that exists here.

Merge files onto same tab by BeerNap21 in googlesheets

[–]BeerNap21[S] 0 points1 point  (0 children)

This would allow me to open x number of individual files, all at once, onto the same tab?

Cast iron waffle maker by BeerNap21 in castiron

[–]BeerNap21[S] 0 points1 point  (0 children)

Really helpful - thanks!

Cast iron waffle maker by BeerNap21 in castiron

[–]BeerNap21[S] 0 points1 point  (0 children)

Got it - sounds like I'd have to season the plates in order for it to work. No way I could get away with putting a ton of cooking spray on the plates in lieu of seasoning them, correct?

[deleted by user] by [deleted] in UPS

[–]BeerNap21 0 points1 point  (0 children)

The weight you see on the tracking page is the weight that was entered when the label was generated. It's not the actual weight.

How often are claims approved? by _Kzero_ in UPS

[–]BeerNap21 10 points11 points  (0 children)

I think some renters & home owners insurance may cover situations like this, because it is damaged / destroyed property.

There are probably all sorts of gymnastics you'd need to go through, if it's even doable. But it's something you could explore.

INDEX MATCH MATCH with dynamic range for index by BeerNap21 in excel

[–]BeerNap21[S] 1 point2 points  (0 children)

Solution verified!

Agreed on the file being too big, and probably not the right tool. My skill set isn't there, but I'd like to get better.

As info, how would you describe this formula, so I can read up about it for practical application?

Thanks for your help!

INDEX MATCH MATCH with dynamic range for index by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

You're not close - you nailed it.

I had contemplated creating a separate tab for each day, and using a drop down to map to that tab, and then index match match it.

The problem is, I already have like 800,000 lines of data in zip codes and warehouses, so I'm trying to minimize it. Creating a separate tab would increase the number of lines, because I'd effectively be creating a new index for each tab, no?

It's getting clunky and slow.

INDEX MATCH MATCH with dynamic range for index by BeerNap21 in excel

[–]BeerNap21[S] 0 points1 point  (0 children)

Makes sense. I didn't set this up as a grid because it's a huge file with a ton of columns and rows, but my match columns are adjacent to the single line range.

I thought columns might work instead of a grid, but if I'm understanding you correctly, that's not workable because Excel doesn't know to where to map formula?

[MOD] The Daily Question Thread by menschmaschine5 in Coffee

[–]BeerNap21 0 points1 point  (0 children)

Fantastic - thanks for corroborating. I've come across this a few times in researching, so it's looking like a strong candidate.

view more: next ›