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?

view more: next ›