hypothetical formula

Hi,

I am not sure if this is possible in excel with a formula, array or macro but I'll ask anyways. I am not looking for an exact answer but I probability guide.

This is all made up information for the sake of an example. So there are items in Column A that sold the quantities in column B for that day. Columns C-J are statistical bits of information containing sales history, current stats and current marketing ratings from our company.

Question- Is there an array/formula/macro that can take C3:J10 and compare it to B3:B10 to determine the most likely reason/s from C3:J10 for the higher Grade in column B? maybe a table to chart would be better?

So are the Q4 rankings more of an impact towards the GRADE or is the industry rating something to pay attention to? Could it be a combination of both 2016 sales history and volume?

Thank you for any advice or direction