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.
Bookmarks