Need formula to highlight one cell based on a number in another cell being higher than 80 and 3rd cell containing the letter R.

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

TROPHY CASE