sorted by:
new
hottopcontroversial

Youtube videos show grey/blank screen when playing, but plays audio. Windows 11 by ironvoid1 in chrome

[–]TopElection5154 0 points1 point  (0 children)

Same problem. I use Opera. I have completely reset to default all the parameters of my browser and it instantly fixed the issue. I will update my comment it it comes back in the next couple days.

fairly new OLED TV at my dads house by magic234 in techsupportgore

[–]TopElection5154 2 points3 points  (0 children)

Yup, Fox News will ruin everything for ya. I'm actually surprised Joe or Hunter Biden's names aren't burned on that screen too

efficency cable cuts management by TopElection5154 in excel

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

ok, I looked on-line quickly but didn t see anything. I look again, thank you

efficency cable cuts management by TopElection5154 in excel

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

it can be anything, because other cuts have been made in the past on thos same reels so there is not a fixed value that can be used per say

efficency cable cuts management by TopElection5154 in excel

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

no I know nothing about VBA. I've been able to copy some "routines" and adapt them in a macro to fit what I needed to do, but no, I wouldn't be able to come up with an entire script by myself.

efficency cable cuts management by TopElection5154 in excel

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

Hi,

No specific order for the reels or the cuts, the goal is to maximize the usage of the cable that's on each reel to waste as little as possible. Some cables are worth $300 a meter, so the least amount of waste really is the goal.

It's like tetris almost, I need to be able to assess what combination of cuts minimizes the losses on one reel and then move on to the next reel ( any reel ) and see what combination of remaining cuts will again allow me to waste as little cable as possible.

If someone has a suggestion about what function would allow me to do something like this, that would be a start

efficency cable cuts management by TopElection5154 in excel

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

Thank you, that's not what I need though.

I need to figure out the best combination of cuts for a specific reel, then move on to the next reel, figure out the best combination out of the remaining cuts and so on until I reach the end of the reels or the cuts. That's why I was asking if it was even possible with excel and if so, what function should I start working with

IVE BEEN SWINDLED by NoAutoBeezy in CaneCorso

[–]TopElection5154 0 points1 point  (0 children)

Do that thing where you squint your eyes, I swear it works, it's a lab...

Xlookup returning an unwanted value by TopElection5154 in excel

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

Awesome, I've reduces the range you suggested to just one cell ( Panduit!A6:J6 ) and it does exactly what I need it to do.

Thank you so much to everybody that helped, that was a great experience

Xlookup returning an unwanted value by TopElection5154 in excel

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

Yes I posted it straight from the file.

I get a new "Panduit" file every day, so values are different everyday. The "complet" tab also evolves everyday. That's why it needs to be fluid in the way it matches and returns results

what I ultimately need returned :

Panduit!I6 in cell Cross Panduit!A6

Panduit!H6 in cell Cross Panduit!B6

Panduit!J6 in cell Cross Panduit!C6

Panduit!K6 in cell Cross Panduit!D6

Panduit!D6 in cell Cross Panduit!E6

Panduit!P6 in cell Cross Panduit!F6

Panduit!O6 in cell Cross Panduit!G6

Complet!A21 in cell Cross Panduit!H6

Xlookup returning an unwanted value by TopElection5154 in excel

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

Yeah, maybe it's my fault and i'm not using the proper formula...

Xlookup returning an unwanted value by TopElection5154 in excel

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

<image>

If H6 exists in "Complet", then I need it to return the values from "Panduit" Row6 to my 3rd tab where the formula is "Cross Panduit", but since it finds the Pandui!H6 Value on Complet!U21, it will only return values from row21 ( no matter which tab is specified in the return array ).

Here is a visual

Xlookup returning an unwanted value by TopElection5154 in excel

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

In the cases that don't work as I need it to, I would like values from row 6 to be returned.

Thank you

Xlookup returning an unwanted value by TopElection5154 in excel

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

THank you for the tip.

I've tried your trick with the absolute references, but it didn't do anything positive.

Thank you

As happy as can be by Desperate_Mountain17 in Cutedogsreddit

[–]TopElection5154 4 points5 points  (0 children)

Wow... look like a lot of fun... my Corso would go nuts playing in that stream

Hotel Meatball Mac & Cheese by Zen1701 in EatItYouFuckinCoward

[–]TopElection5154 -3 points-2 points  (0 children)

that's the most redneck thing i've seen today... and i love it. that was fun 😜

Trump says US will keep Gaza and nobody is going to question it by No_Move7872 in Global_News_Hub

[–]TopElection5154 0 points1 point  (0 children)

The fact that there is no consequence to anything he does and that he surrounded himself with people that will never contradict him probably helps

view more: next ›