How to show a change in a value when choosing from a drop down list

Hey everyone

I have a spreadsheet that provides the user with many options in forms of multiple drop down menu. When a selection is made from the menu, values relating to that choice are displayed.

So in other words...

User chooses options A, A, A from 3 separate drop down menus where A = 5 and B = 1

What I would like to do is after this is done, when the user chooses say A, B, A, the spreadsheet would flag the B value as having decreased from 5 to 1. So in an ideal world I would have a cell next to the one with B in it saying - 4. Then if the user wishes to have B even with the drop of 4, then they could choose it

So i suppose it is like what if analysis, but with the many hundreds of permutations that my spreadsheet would require.

My knowledge of excel is good and I have a certain level of coding experience but none in macros or vba!

Thanks for your help

EDIT: I thought of a suitable example to make myself clearer. Consider a video game character page. When you increase your level it shows how some values went up and how some went down from what they were originally. My goal is to make something equivalent to that

You have a couple different options... If you're looking for a single lump sum value for all 3 returned values, and each individual of the 3 cells have consistent values, you could pair up some multiplication with a countif..

=5*Countif(A1:A3,"A")+Countif(A1:A3,"B")

I'd need to see an example workbook of what you're trying to do to see how complex it really is, and to see what you're trying to get out of it.

Hi thanks for the reply

Here is an example of what I am trying to do

http://dl.dropbox.com/u/45884936/example.xlsx

Hopefully I have made it clearer :P