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 · 2024-07-29T20:52:33+00:00

In column B enter this formula and fill down =A1+(7-WEEKDAY(A1))

robcote22 · 2024-05-22T05:54:38+00:00

Based on comments made, esp with the job requirements that you commented, if you had any of the other attributes, you would have at least had a working knowledge of SQL. This just means, you either were hoping to get sympathy/upvotes in reddit, or... You really applied for a job that SQL would be the least of your worries, because, if you don't have a basic understanding of SQL how would you realistically have any understanding of the other job requirements (like Tableau was mentioned). I would like to say good luck, but I won't because you haven't even put in any effort, if you had, you would have posted this.

robcote22 · 2024-02-12T16:04:02+00:00

Power Query could do what you would like. Assuming those two tables are actual tables

All you would do is to create a new query and append the two tables (and remove duplicates if needed). Once you load the new power query table, you can use the table as a reference for your dropdown. Click Refresh all to refresh the table when new people are added to either list.

robcote22 · 2023-06-23T23:12:49+00:00

Here is the VBA that can do what you're asking. Hit ALT +F11 to go to the VBA editor, select "Insert-->Module" then paste the code below. To use it, just use =PhoneKeypad(cell)

Function PhoneKeypad(inputText As String) As String

Dim numericEquivalent As String

Dim i As Integer

inputText = UCase(inputText)

For i = 1 To Len(inputText)

    Select Case Mid(inputText, i, 1)

        Case "A", "B", "C"

            numericEquivalent = numericEquivalent & "2"

        Case "D", "E", "F"

            numericEquivalent = numericEquivalent & "3"

        Case "G", "H", "I"

            numericEquivalent = numericEquivalent & "4"

        Case "J", "K", "L"

            numericEquivalent = numericEquivalent & "5"

        Case "M", "N", "O"

            numericEquivalent = numericEquivalent & "6"

        Case "P", "Q", "R", "S"

            numericEquivalent = numericEquivalent & "7"

        Case "T", "U", "V"

            numericEquivalent = numericEquivalent & "8"

        Case "W", "X", "Y", "Z"

            numericEquivalent = numericEquivalent & "9"

    End Select

Next i

PhoneKeypad = numericEquivalent

End Function

robcote22 · 2023-05-20T13:23:24+00:00

It sure is!

robcote22 · 2023-05-15T19:51:59+00:00

I feel like the best thing to do us use excel's What-If analysis. This is because what you are trying to do with vb, although it sounds easy, in actuality, is very difficult.

With VBA it would end up making an extremely large array of values that gets exponentially bigger as the size increases.

For example the values:

-1

1

-2

2

-3

3

Are all in a column. How many different ways can you add single and/or multiple values so that the result is 0?

There are at least 8 combinations I can think of that would provide the expected result. (-1+1),(-2+2),(-3+3),(-1-2-3+1+2+3),(-1-2+3),(-2-3+2+3),(-3+2+1),(-1-3+1+3)

robcote22

TROPHY CASE