Anyone get any good pulls this week? Maybe a couple duplicates you want to offload?
Post a list of what you’re looking for, people will reply with what they’d like in exchange.
Anyone get any good pulls this week? Maybe a couple duplicates you want to offload?
Post a list of what you’re looking for, people will reply with what they’d like in exchange.
Hello :)
I’m looking to complete more deck missions and themed collections. Here is what I’m missing:
A1 022 Exeggutor ♢♢♢ GA A1 035 Charizard ♢♢♢ GA A1 040 Arcanine ♢♢♢ GA A1 046 Moltres ♢♢♢ GA A1 095 Raichu ♢♢♢ GA A1 128 Mewtwo ♢♢♢ GA A2 007 Yanmega ex ♢♢♢♢ STS A2 010 Turtwig ♢ STS A2 017 Combee ♢ STS A2 024 Magmortar ♢♢♢ STS A2 029 Infernape ex ♢♢♢♢ STS A2 035 Piplup ♢ STS A2 070 Duskull ♢ STS A2a 047 Garchomp ex ♢♢♢♢ TL A2a 057 Probopass ex ♢♢♢♢ TL A2a 084 Garchomp ex ☆☆ TL A2a 093 Garchomp ex ☆☆ TL A2b 010 Charizard ex ♢♢♢♢ SR A2b 022 Pikachu ex ♢♢♢♢ SRThis is beautifully formatted lol.
spreadsheets 😎
https://www.reddit.com/r/pokemon/comments/1fu76x4/a_spreadsheet_for_tcg_pocket_that_calculates_the/
I copy pasted those rows onto a separate sheet after I kept looking for them. I then asked AI for a formula to list everything that I am missing.
=QUERY({ {'Genetic Apex'!B:B, 'Genetic Apex'!C:C, 'Genetic Apex'!E:E, 'Genetic Apex'!J:J, 'Genetic Apex'!K:K, ARRAYFORMULA(IF(ROW('Genetic Apex'!B:B)=1,"Source",IF(ROW('Genetic Apex'!B:B)>1,"Genetic Apex",)))}; {'Mythical Island'!B:B, 'Mythical Island'!C:C, 'Mythical Island'!E:E, 'Mythical Island'!J:J, 'Mythical Island'!K:K, ARRAYFORMULA(IF(ROW('Mythical Island'!B:B)=1,"Source",IF(ROW('Mythical Island'!B:B)>1,"Mythical Island",)))}; {'Space-Time Smackdown'!B:B, 'Space-Time Smackdown'!C:C, 'Space-Time Smackdown'!E:E, 'Space-Time Smackdown'!J:J, 'Space-Time Smackdown'!K:K, ARRAYFORMULA(IF(ROW('Space-Time Smackdown'!B:B)=1,"Source",IF(ROW('Space-Time Smackdown'!B:B)>1,"Space-Time Smackdown",)))}; {'Triumphant Light'!B:B, 'Triumphant Light'!C:C, 'Triumphant Light'!E:E, 'Triumphant Light'!J:J, 'Triumphant Light'!K:K, ARRAYFORMULA(IF(ROW('Triumphant Light'!B:B)=1,"Source",IF(ROW('Triumphant Light'!B:B)>1,"Triumphant Light",)))}; {'Shining Revelry'!B:B, 'Shining Revelry'!C:C, 'Shining Revelry'!E:E, 'Shining Revelry'!J:J, 'Shining Revelry'!K:K, ARRAYFORMULA(IF(ROW('Shining Revelry'!B:B)=1,"Source",IF(ROW('Shining Revelry'!B:B)>1,"Shining Revelry",)))} }, "select Col1, Col2, Col3, Col4, Col6 where Col4 < 2 and Col1 is not null and (Col3 matches '.*[♢☆✷♛].*') order by Col3 asc", 0)Laziness or insanity, up to others to decide
Saving this comment for later. That’s bound to be useful as the set lists expand.
Do you happen to have a spare A1 084 Articuno ex?
I’d have to shred some cards to be able to trade you but I have a spare Yanmega ex and Articuno would complete GA for me.
Unfortunately no, I have 0 of those. Congrats on almost being done 🥳