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.   ...
  • Bennadeau's avatar
    Oct 16, 2020

    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.

     

Resources