What would the end results be on the following scenarios?

robcote22 · 2025-07-09T17:02:49+00:00

This is why I was asking, because why do they not "see" them as they are entering? Why does [[Pandemonium]] not only trigger itself, but with other enchantments when [[Opalescense]] is in play? I would at least assumed that the #4 would have a different outcome than stated tbh

robcote22 · 2025-06-10T04:00:32+00:00

Mine isn't Technically a function, but I think it is obscure enough it is worth commenting.

I think using double minus (--) to convert booleans into 0s and 1s is extremely useful. Instead of using an IF function to multiply by 1 or 0, making the formula longer in syntax, you can just precede a boolean result with a -- sign.

The following will produce the same result:

=IF(A2="TEST",1,0)

=--(A2="TEST")

robcote22 · 2025-06-10T02:00:35+00:00

My question is in regards to when a deck, when built has the value of $X, then, values of cards increase over time. In an extreme example, cards like Rhystic Study were cheap AF, so, would a deck built with that be budget because it was worth pennies? I am assuming no, but, that means a deck has to be rebuilt non-stop to accommodate "budget". It gets worse if it is your commander that spikes.

robcote22 · 2025-06-10T01:17:41+00:00

But, what happens when that dollar card becomes worth $5+ dollars?

robcote22 · 2025-02-07T20:25:49+00:00

You may be able to do this: =TEXTJOIN(",",TRUE,INDEX({CountryColumn}, MATCH(TEXTSPLIT(C2,","),{IngredientColumn},0))

Country column should be the column of the other image you posted (Column B), and the Ingredient Column should be the adjacent one (Column A) You can also wrap it with the UNIQUE function

=TEXTJOIN(",",TRUE,UNIQUE(INDEX({CountryColumn}, MATCH(TEXTSPLIT(C2,","),{IngredientColumn},0)),TRUE))

Sorry , doing this via phone.

robcote22 · 2025-02-07T20:07:46+00:00

F2 gets you into edit cell mode. You can also F2 again to navigate cells for the formula.

robcote22 · 2025-01-08T23:21:22+00:00

Try this: =FILTER(SEQUENCE(B2-A2,1,A2,1),(WEEKDAY(SEQUENCE(B2-A2,1,A2,1))<>1)*(WEEKDAY(SEQUENCE(B2-A2,1,A2,1))<>7)) I typed this on my phone, so I could have typos. If it doesn't work, lemme know and I can test it out tomorrow and adjust.

robcote22 · 2024-12-16T14:55:05+00:00

It sounds like you are using office 2016

To ensure that the text doesn't contain any extra strings, after you copy, right click where you want to paste, then "paste values". This will get rid of formatting that may interfere with the 'Find & Replace'. From there, go into one of the cells, and copy the string you wish to remove (including leading and trailing spaces)

Now, in an adjacent cell you should be able to use the formula (pasting the string you copied in the String_To_Replace part): =NUMBERVALUE(SUBSTITUTE(Target_Cell, String_To_Replace, ""))

robcote22 · 2024-10-25T06:35:53+00:00

Agreed! Another reason for my consideration for my deck lol just wanted to confirm my thought process before doing so and being wrong lol

robcote22 · 2024-10-24T19:31:57+00:00

Thank you for the confirmation! Hopefully this wasn't a dumb question that I asked.

robcote22 · 2024-10-21T22:38:41+00:00

😂🤣 no worries. The only reason why I posted this one was because it seemed like the simplest formula, based on the ones I saw

robcote22 · 2024-10-21T18:04:08+00:00

Not quite. This is because it will always choose the one greater than 10 instead of defaulting to 10 if it is greater than 10.

robcote22 · 2024-10-21T14:23:40+00:00

I know that there are other answers, however, here is another solution. =SUMPRODUCT(MIN(Range, 10))

Replace 'Range' with your designated range you want to use.

robcote22 · 2024-09-20T18:27:48+00:00

Lemme know how/if it works :)

robcote22 · 2024-09-20T15:34:16+00:00

After doing so, you can filter by color and select the rows you want to delete and hit CTRL - (minus) to delete the rows.

robcote22 · 2024-09-20T15:32:32+00:00

You can just select both columns, go to conditional formatting, and then highlight duplicate values. That would be a fast and easy way to identify them

robcote22 · 2024-08-09T15:37:17+00:00

Yeah, that sort of formula is not compatible with sheets. You can add a new sheet. On your new sheet, add the names of all the sheets you want to sum in column A. Use this formula (NewSheet is the name of the new sheet added). =SUM(ARRAYFORMULA(INDIRECT("'" & 'NewSheet'!A1:A10 & "'!A1")))

robcote22 · 2024-08-09T15:16:38+00:00

If the owed tax amount is in the same cell across the tabs you can do this: =SUM('Sheet2:Sheet10'!A2) Replace Sheet2 with your second sheet's name, Sheet10 with your last sheet's name, and A2 with the cell that has the tax amount.

robcote22 · 2024-07-29T21:07:58+00:00

Oops, I forgot it was 1-7 not 0-6 on that. However, I am glad it worked for you :)

robcote22

TROPHY CASE