ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   calculate vehicle number plates sequence (https://www.excelbanter.com/excel-worksheet-functions/266816-calculate-vehicle-number-plates-sequence.html)

scroll1

calculate vehicle number plates sequence
 
Hi,
Here is an interesting problem I wanted to try and solve with excel.
I have a series of number plates ( OAS 093 through to PWD 743 ).
These are the number plates that appeared on vehicles during 1972. I don't need to be too accurate, but I would like to know te series of number plates that would have been released in July ( half way through the sequence ). I am making a huge assumption that number plates were given out evening each month ( I'm not worried about the assumption ).
Firstly, is this an excel possible problem and secondly I'm getting lost trying to write a formular to calculate this.

result, possibly to look like:

1972

Jan OAS093
OAS094
etc...

Feb OA????


any help would be greatly appreciated,
thanks ...


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com