Forum Discussion

T-Meyers's avatar
T-Meyers
Copper Contributor
Oct 15, 2020

Difficult Formula Help Please

Hi all,

 

I am in need of some help with the sheet attached. All of my questions are on the 2 tabs on my sheet. I am still learning the basics of excel so any help would be greatly appreciated.

 

I tried to explain the things I am trying to do in the sheet as much as possible, so if anything doesn't make sense, I am more then willing to answer any questions about them.

  • Hi T-Meyers,

    Take a look at this. I think there's more work to be done but it's a start.

    In sheet "reorder insert" column K and L are essentially the same. Or I missed something in your explanations.

    I took the liberty to add a conditional formatting in sheet "Break down" so you can quickly spot your numbers in the grid.

    I added a few examples for testing, take a look and let me know if you need any fine tuning.

     

  • Bennadeau's avatar
    Bennadeau
    Iron Contributor

    Hi T-Meyers,

    Take a look at this. I think there's more work to be done but it's a start.

    In sheet "reorder insert" column K and L are essentially the same. Or I missed something in your explanations.

    I took the liberty to add a conditional formatting in sheet "Break down" so you can quickly spot your numbers in the grid.

    I added a few examples for testing, take a look and let me know if you need any fine tuning.

     

  • 1016jersey's avatar
    1016jersey
    Copper Contributor

    Take a look at this. I think there's more work to be done but it's a start. Search online: Combine "1016 jersey" with known details (sport, team, player) to find potential leads. Contact relevant organizations: Consider contacting sports teams, museums, or historical societies for possible information or displays. 

    1016jersey.com is a website that sells soccer jerseys. We sell new releases from Inter Miami, Paris Saint-Germain, Chelsea, and other clubs. We also have a section on classic jerseys, including those of Lionel Messi, Cristiano Ronaldo, and Zinedine Zidane. 

Resources