u/it2d

▲ 3 r/excel

Finding most recent dates in carious columns of date information

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.

reddit.com
u/it2d — 1 day ago

What to do with bulk rares

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!

reddit.com
u/it2d — 25 days ago