Show a number when data added

Hi All
I have a spreadsheet where the first 2 columns are headed ID Number and Title, (Mr,Mrs,Miss)
Column B has a drop down validation list Mr,Mrs,Miss named Title
So when data is entered in Col B4 ie Mr, or Mrs, or Miss I want to reveal an ID number starting at Col A4 which is 926 and then so on down to Col B1004 and ID Number in Col A1004 which will be 1926
Any Ideas? I have tried hard with this

Many thanks
Bern

Originally Posted by bern

Hi All
I have a spreadsheet where the first 2 columns are headed ID Number and Title, (Mr,Mrs,Miss)
Column B has a drop down validation list Mr,Mrs,Miss named Title
So when data is entered in Col B4 ie Mr, or Mrs, or Miss I want to reveal an ID number starting at Col A4 which is 926 and then so on down to Col B1004 and ID Number in Col A1004 which will be 1926
Any Ideas? I have tried hard with this

Many thanks
Bern

Do you want to give this a try? You can put a conditional format to hide the unwanted 0's.

This would go in cell A2

=IF(ISBLANK(B2),IF(A1>0,A1+1,0),A1+1)

Hi
Many thanks for that, but the only way I can get that to work if I reduce the arguments ie =IF(ISBLANK(B2),IF(A1>0,),A1+1)
Then it produces errors in Col A which I have formated to ignore and then with conditional formatting to blank out the 0 and the FALSE which it gives in alternative cells in the column.
It works but I don't like ignoring errors.

Many thanks
Bern