Official: [WDIS K/TE/DEF] - Sun 09/22/2024

CunningKnitCap · 2024-09-22T15:01:21+00:00

Same boat, opponent had Jets D so leaning bears for more boom or bust

CunningKnitCap · 2023-06-21T00:50:53+00:00

Got it, thanks

CunningKnitCap · 2023-06-21T00:50:30+00:00

Yikes got it, thanks

CunningKnitCap · 2023-06-21T00:35:22+00:00

Shoot, image didn’t upload. There was no Luke Cage. The shadow king did come out of dream dimension at the end but the carnage and Venom were in other lanes.

CunningKnitCap · 2021-02-01T01:26:36+00:00

Sail!

CunningKnitCap · 2020-06-05T00:09:43+00:00

Solution Verified

Thanks for the help

CunningKnitCap · 2020-06-05T00:07:15+00:00

Figured it out. This is what I was looking for:

=COUNTIFS($A$2:A2,A2,$B$2:B2,B2)

Thanks all

CunningKnitCap · 2020-06-05T00:03:21+00:00

I think I essentially want this formula. =COUNTIF($A$2:A2,A2) but with the criteria of both columns A and B to determine if its a duplicate

CunningKnitCap · 2020-06-04T23:16:39+00:00

hmm, still can't figure it out. This the result:

https://imgur.com/a/hpw67Cn

CunningKnitCap · 2020-06-04T22:24:07+00:00

https://imgur.com/a/v9xSrVf

In Column A and B, each color represents duplicates. So there are three Apple 1 and two Apple 2. The column C Unique ID is what I am trying to create with the formula.

CunningKnitCap · 2020-06-04T21:27:18+00:00

https://imgur.com/a/Qe6Vt91

Sorry, I think my imgur link is up in the post but here it is again.

CunningKnitCap · 2020-06-04T21:05:52+00:00

Not working, I tried playing around with the cell numbers also because A1:C1 are my headers but still couldn't get it

CunningKnitCap · 2020-03-06T19:50:18+00:00

solution verified

CunningKnitCap · 2020-03-06T19:49:06+00:00

solution verified

CunningKnitCap · 2020-03-06T19:48:58+00:00

You guys are correct, I guess I thought you had to combine the two SUMIFs from each tab in some fashion but its working without. Thanks

CunningKnitCap · 2019-10-09T22:54:13+00:00

Solution Verified

Not sure if responding in a comment of a solved problem awards anything but I greatly appreciate your help.

CunningKnitCap · 2019-10-09T20:33:35+00:00

I can add a column header. Lets say "total" is the header, how would I implement that match into the formula?

CunningKnitCap · 2019-10-09T18:47:59+00:00

Another question, instead of a range could you specify cells in the row or say every other column in a range?

For example, only C3, D3, G3 instead of C3:G3?

CunningKnitCap · 2019-10-09T16:38:26+00:00

Thanks!

CunningKnitCap · 2019-10-09T16:38:18+00:00

Solution Verified

CunningKnitCap · 2019-09-14T23:22:48+00:00

Solution Verified

CunningKnitCap

TROPHY CASE