I have a an excel file set out with the following Field headings:
CAR Num. used REVENUE. 1 £60 2 £70 1 £60 4 £50 1 £60
Without using macros and only a formula how could i how much each car has earnt in revenue. I could achieve this fairly easily using a bit of VB for a macro, but has anyone got an idea how to achieve it much simply through the use of some sort of excel formula/function.