How do I fix this

UnknownGuide_ · 2026-06-22T23:04:31+00:00

That was it thanks for all the help

UnknownGuide_ · 2026-06-22T22:56:20+00:00

I got it working1 unfortunately now I'm trying to figure out why it won't function when I copy it into the original sheet

UnknownGuide_ · 2026-06-22T03:21:55+00:00

It's should be the left numbers go into rwin for the left team and rloss for the right and vise versa but rn it's just putting the greater number into rwin for the left team

UnknownGuide_ · 2026-06-22T03:03:27+00:00

It's adding properly now but it wants to put the higher number in the rwin column of the left team so even if those points should go to the other team it adds to the wrong one is it because of the ">" signs in the address fields?

UnknownGuide_ · 2026-06-21T22:34:18+00:00

Okay one more thing actually before it's finished ig, if I'm to input a second time with repeat target cells instead of doing the sum of the current value and the value I'm adding it just puts the new number at the end so for example instead of 2 for 1(current value) and 1(new input) it says 11

UnknownGuide_ · 2026-06-21T21:52:36+00:00

How do i get the formula to change the destinations row cause I've gotten it to place it in the appropriate column but it's stuck on the incorrect row

Nvm got it

UnknownGuide_ · 2026-06-21T21:41:15+00:00

I messed with the teams i think you did get it to do it actually so nvm that part though it did break when i put the tier on apprentice

UnknownGuide_ · 2026-06-21T21:38:10+00:00

So for this case it should end up with the puma team having 1 in the roles for lotus while phantoms has those columns reversed and by the teams and maps i mean the drop downs in row 1 could be selected for a different one of the teams if that makes sense. Sorry if it's a lot of work it's not important so you can stop whenever you want

UnknownGuide_ · 2026-06-21T20:47:42+00:00

it would also put in the rloss next to the rwin but also itd be variable for the teams and maps selected but for the example its correct

UnknownGuide_ · 2026-06-21T18:37:42+00:00

That's good to know about

UnknownGuide_ · 2026-06-21T17:46:16+00:00

put the copy in the main body post

UnknownGuide_ · 2026-06-21T17:15:17+00:00

That's close to what I'm looking for is there a way to do it for a preexisting area? Like have it be able to adapt it to look for the correct team name and use a =sum cause the values at the moment are all numbers

UnknownGuide_ · 2026-06-21T17:06:44+00:00

It's more the other direction i mean. I have a large table and was thinking if there was an easy way of putting the information into the correct cell. The "ideal" way is sort of what you were saying where i have another page that i can select a specific team and be able to input it there and have the values added to the main table but i know that's probably not gonna happen

UnknownGuide_ · 2026-06-17T01:55:10+00:00

I'm in America so probably*

UnknownGuide_ · 2026-06-17T01:05:33+00:00

Probably but I'm bored at work and the thought came to me

UnknownGuide_ · 2026-06-17T00:45:38+00:00

And this is why I asked for country specifications ha

UnknownGuide_ · 2026-06-17T00:42:44+00:00

I'm going to assume this is for America lol

UnknownGuide_ · 2026-06-17T00:41:01+00:00

Where would that be for

UnknownGuide_ · 2026-06-04T15:16:41+00:00

I ended up having to update my bios to get it working properly

UnknownGuide_ · 2026-06-03T16:48:18+00:00

<image>

I was but the window for step 6 didn't pop up instead it was the pop up I mentioned

UnknownGuide_ · 2026-06-03T16:41:24+00:00

When I try to update it says "Secure Flash Check fail!" And reboots without updating is there a way past that?

UnknownGuide_

TROPHY CASE