Organize your new FIFA Legits | Scribe

    Organize your new FIFA Legits

    • Upland Guide |
    • 0 step |
    • 3 minutes
    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/](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](https://www.ablend.me/football/shop_listings)
    Click "Player Legits"
    Type in your user name
    Click "Download List"
    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
    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
    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](https://docs.google.com/spreadsheets/d/1CaM8ma_9NdjarFFe8SEKiDMNcP97DjboLteQLgzSRls/edit?usp=sharing)

    Want to make guides like this in seconds? Yes, it's really that fast.

    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe