Hi there,
I have two sets of data that I need to show if there has been an increase or decrease in over a 2 year period so at present have something that looks like this:
<TBODY>
</TBODY>
I need to show, for example, that SY66 2 has gone from 3rd in year one to 1st in year two.
Can anyone help at all please?
Its the top 10 postcodes which isn't alot, but I have to do this for about 60 bases so if I can find a formula or something that works my job will be much easier (especially as this will be a monthly occurence).
Thanks very much in advance.
I have two sets of data that I need to show if there has been an increase or decrease in over a 2 year period so at present have something that looks like this:
Year 1 | Year 2 | ||
Postcode | Number | Postcode | Number |
SY23 7 | 2875 | SY66 2 | 2890 |
ST65 8 | 2700 | SY23 7 | 2611 |
SY66 2 | 2602 | ST9 6 | 2400 |
<TBODY>
</TBODY>
I need to show, for example, that SY66 2 has gone from 3rd in year one to 1st in year two.
Can anyone help at all please?
Its the top 10 postcodes which isn't alot, but I have to do this for about 60 bases so if I can find a formula or something that works my job will be much easier (especially as this will be a monthly occurence).
Thanks very much in advance.