If you want to learn more about FIFA World Cup Legits, start here https://upland-guide.com/upland-legits-main/fifa-world-cup-qatar-2022/fifa-world-cup-assets/legits/


To download a list of all your Legits, start by going to https://www.ablend.me/football/shop_listings

Open the file in excel, or google sheets.
rename the tab "original"

Add a column to the right of column E (mint)
Name the new column "mint text"
insert this formula into cell F2: =text(E2,"0000")
Autofill the formula to the entire column, or copy and paste the formula

Type "mint text [[enter]] = [[left]]  [[Backspace]]  [[Backspace]] text( [[left]] ,"0000") [[enter]]"

Insert a new column to the right of column A (legitname)
name the column "legit and mint"
insert the following formula into cell B2: =A2&" "&G2
Autofill the formula to the entire column, or copy and paste the formula

Type "legit and mint [[enter]] = [[left]] & " " [[Backspace]]  [[Backspace]]  [[Backspace]]  [[Backspace]] " "&"

Click ctrl + A to select the entire table
Data --> Sort Range --> Advance range sorting options
Select "Data has header rows"
Sort by "Legit and mint"
Click Sort

Repeat steps 6-8 for a second tab called "new"

in the "new" sheet:
Insert a new column to the right of B and name it "new legit"
Insert the following formula into cell C2: =if(exact(B2, VLOOKUP(B2,original!B:B,1,TRUE)),"","new")
Autofill the formula to the entire column, or copy and paste the formula
Filter the column, remove blanks
Click OK.  
This will now show you exclusively the new Legits you added since the last time you created a report.

Use the Upland Guide FIFA Collections template to organize all your Legits in a color coded easy to visualize table
https://docs.google.com/spreadsheets/d/1CaM8ma_9NdjarFFe8SEKiDMNcP97DjboLteQLgzSRls/edit?usp=sharing

docs.google.com

google.com

ablend.me

Learn how to organize your FIFA Legits, and view any new ones that you recently minted.
Learn everything you need to know about FIFA Legits with the Upland Guide - https://upland-guide.com/upland-legits-main/fifa-world-cup-qatar-2022/fifa-world-cup-assets/legits/

Organize your new FIFA Legits