it2d

Hi, all, I'm working on a spreadsheet to help me with my MTG decks. This is what the spreadsheet looks like right now:

https://imgur.com/a/isfmY8h

I'm trying to find a way to automatically count the number of times that the name of each card appears in the spreadsheet, and I need it to update if the card name gets added or deleted. I also want to be able to sort the column of the card names based on how often they show up at the end.

I can do what I want with COUNTIF, but I don't know how to do that without having to copy each card name into the arguments for COUNTIF. Is there a way to have Excel do that dynamically so I don't have to update it every time I add a card or do this with

I play a lot of Magic: The Gathering. I have a spreadsheet that tracks when I play each of my decks and the outcome of the game. The spreadsheet has a section for each deck, and then a column of dates for when I played those decks.

I'm trying to find a way to take those columns of dates and generate a list of, for example, the top-ten most recent decks I played. I don't know how to get Excel to do that, because it would need to look at all of the date columns and find the top-ten most recent dates and the deck they correspond to. I don't even know how to begin to do that.

Any thoughts or suggestions?

Thanks.

I just scanned about 1700 bulk rares. Total value on Manabox is $1.2k.

I'm looking for any recommendations on how to turn these rares into cards I'm chasing or will play with. Looking to trade or get store credit, basically. Any recommendations for where I'll get the best value?

Thanks!

I ha e an A1 Mini and AMS Lite. I also have a bunch of nearly used up spoons of PLA. I want to print a model and I dot care what color it is or if it changes colors randomly midprint.

is there a way to have the AMS just switch to the next spool when one runs out, regardless of color difference?

thanks.

Playing a game on Spelltable. Everyone's fairly chill. Over two turns, a player develops a board that involves his commanders ([[Malcolm, Keen-Eyed Navigator]] and [[Francisco, Fowl Marauder]]) as well as [[Changeling Outcast]]. He attacks, gets a bunch of treasures, then casts [[Time Sieve]] and announces that he wins through extra turns.

I point out that chaining extra turns isn't allowed in bracket 3, and the table responds that that changed in October (I don't think it did), and that it's cool cause he wins on the spot if we all concede, which we should. I point out that the issue is that he's now got an on-board infinite turn combo. And it seems like that's the purpose of the deck

I have a spreadsheet that looks like this:

https://i.imgur.com/nJeLYrJ.png

I'd like to filter out the columns to the right of the date column based on the date. So, for example, I'd like to be able to say "in January 2024, there were three entries in the first column, four in the second, etc."

Is that possible? If so, I'd appreciate any guidance.

Thank you.

Hi, everyone, I have Fusion 360 installed on my computer. My son designed something in Tinkercad. I'd like to edit the model in Fusion 360, so I go through the "send to" process in Tinkercad. Fusion 360 opens on my computer, but there's no model.

Any idea on what I'm doing wrong?

Thanks.

I got a Bambu Labs A1 Mini a few weeks ago, and it had been working flawlessly until I moved it to a different location. Now, the first layer absolutely will not stick. I've washed the build plate, I've run the calibration, and I've ensured that it's doing the auto bed leveling before each print.

Any suggestions on my next steps?

Thank you.

I recently bought a new Microsoft Surface to replace my old one. I've noticed that, on my home network, the internet connection will sometimes get extremely slow. Like, unusably slow. This doesn't happen on our other devices on the home network or, as far as I can tell, on other networks with this new computer. Usually, restarting the computer fixes the problem, but I'd say I have to do this about once a day to have functional internet.

Any idea about what might be causing this?

Thank you.

Nothing yet on my Spider-man SLs yet.

Usually my SLs have shipped right away, so I'm a little frustrated.

Anyone have any suggestions for how to store lumber outdoors? Im out of space in the garage. We live in an area with hot humid summers and cold snowy winters.

Looking to not spend a ton.

Thanks.

Ive read the webpage and watched tons of YouTube reviews. It is totally unclear to me that the wifi booster is and whether I want it. Its something other than the display? What does it do, exactly?

Im sorry if this us a dumb question. Ive recently made a few sales over $50, which requires i ship the packages with tracking. But the cost of shipping for those packages is way higher than for standard non-machinable envelopes. Is there a way to have the shipping cost be higher for orders over $50?

The TCGPlayer app got updated. Now the "import to seller portal" feature doesn't work. It says there are connection issues. My internet connection is fine.

Anyone else have this problem or find a solution?

Thanks.