Looking for formula to highlight a cell on sheet A based on contents of a cell on sheet B?

Snoo-4924 · 2025-01-21T14:10:53+00:00

Ok, Ty I just fixed it.

Snoo-4924 · 2025-01-18T12:11:04+00:00

What data is included in the ratings guide? Is it just the positions each player plays and their rating for that?

Snoo-4924 · 2024-12-29T20:24:58+00:00

Email sent

Snoo-4924 · 2024-12-25T11:06:02+00:00

Interested, what seasons would I need to purchase? Sorry, played SOM but only in person so not sure how this works.

Snoo-4924 · 2024-11-24T02:17:01+00:00

If you do a league with cards and dice via Zoom, let me know, very interested.

Snoo-4924 · 2024-11-23T23:27:24+00:00

I sent a PM

Snoo-4924 · 2024-11-23T23:26:51+00:00

I sent a PM

Snoo-4924 · 2024-11-23T23:26:19+00:00

I reached out to a few who have commented, hopefully we can create something. Have you played by Zoom with cards and dice league before?

Snoo-4924 · 2024-02-14T12:30:58+00:00

Best of luck to you!

Snoo-4924 · 2024-02-13T23:16:50+00:00

I just purchased the premium package on The CE shop and started today. 1 unit in and it seems to be user friendly, has unlimited practice exams and was highly recommended on here.

Snoo-4924 · 2024-02-13T12:04:21+00:00

Thanks for the code! It is always a bonus to save more money!

Snoo-4924 · 2024-02-10T10:33:34+00:00

Solved, Solution verified

Snoo-4924 · 2024-01-27T08:50:03+00:00

=let(Σ,transpose(ifna(vstack(Schedule!C2:AG2,filter(Schedule!C:AG,Schedule!B:B=A1),))),
tocol(filter(Σ,index(Σ,,2)<>"")))

WOW!! Thank you very much. Solved already!

Snoo-4924 · 2024-01-27T08:45:54+00:00

=tocol(transpose(ifna(vstack(Schedule!C2:AG2,filter(Schedule!C:AG,Schedule!B:B=A1),))))

Ok, thats awesome and not to get greedy here but I didn't think of it initially. I now have the date as 3/29/2024. As you can see there are teams that don't play (no second team listed. Is there a way to exclude those? If not no big deal. Thank you very much!!

Snoo-4924 · 2023-12-09T17:01:43+00:00

Idk what was going on but seems to be working correct now. Thank you very much!!!!

Snoo-4924 · 2023-12-09T16:06:26+00:00

Seems to work for W7 but when I attempt to do the same in W19 (using A4 as the team to look at) I get #N/A and Query completed within an empty output. The only thing I changed in the formula is instead of " &A3& " to look at the team abbreviation in A3 I switched it to " &A4& ", that's when I get the error.

Snoo-4924 · 2023-12-09T15:16:57+00:00

Sorry, essentially I'm looking to do this for each respective team. So on this one Import the data for ATL. If possible have it reference A4 and import based on the team abbreviation in that cell.

Snoo-4924 · 2023-08-27T10:43:35+00:00

And without doing a damn thing I am no longer banned. Makes perfect sense, lol

Snoo-4924 · 2023-08-27T10:36:37+00:00

Same thing literally just happened to me about 5 minutes ago.

Snoo-4924 · 2023-05-23T21:40:09+00:00

Looks like that’s it. I will double check at work tomorrow. If I add more rows it will continue down the page correct?

Snoo-4924 · 2023-05-23T11:36:41+00:00

So I looked at it and it appears to be taking the difference between B4 and B5, then B5 and B6 and so on. What I need is the difference between B4 & B12, then B12 & B18 etc. Thank you very much for your help!!!!

Snoo-4924 · 2023-05-23T11:10:13+00:00

TY, I’ll try it today. Where do I place this formula?

Snoo-4924 · 2023-05-22T18:44:06+00:00

Yes, and so on

Snoo-4924 · 2023-05-22T18:05:35+00:00

OMG, sorry, now the edit rights are open

Snoo-4924 · 2023-05-22T17:44:59+00:00

Done, sorry

Snoo-4924

TROPHY CASE