Good Morning Experts
I have a task which is beginning to give me a headache, hopefully you'll be able to advise...
I have some food items - chips, rice, coleslaw, Greek Salad, Caesar Salad...
The food items are categorised as Regular, Large or Salad, Salads are considered large as well.
For each item I have a Selling Price and a Cost Price and Profit, this is what the list looks like:
These items are sold individually and as part of of a combination - one particular combination is '2 Large or 4 Regular' - I need your expert help to work out what all the different permutations could be and layout the information as clear as possible for end users to view - I will be applying conditional formatting to the profit column later.
I have attached a spreadsheet with the list from the above image, currently working with Excel 2007 but can move to Excel 2010 if there is any specific functionality which I should be taking advantage of.
Excel formulas or VBA acceptable