It is a project for my company - I suppose I had exaggerated my Excel knowledge.

So far I have managed to do the first bit. i.e. I have used an IF formula to work out how many times the first shop is beaten on price.

I'm struggling to find a way to find out by how much cheaper it is when it is cheaper.

Will upload as soon as I get home.