Create unique ID + if Blank leave Blank

[mtr1213]

Hello - I'm creating a log file to track issues from employees; I'm creating a unique ID for each issue and using this formula:

Column B2 i have =IF(ISBLANK(A2)," ",(MAX(1000)+1)) so the ID will be "Blank" until the name is added; the formula that start on B3 is (IF(ISBLANK(B17)," ")),IF(ISNA(MATCH(A18,$A$17:A17,0)),MAX($B$17:B17)+1,VLOOKUP(A18,$A$17:B100,2,FALSE)), which is causing the #Value! error...what am i doing wrong??

Employee Name	Issue ID
	#VALUE!
	#VALUE!

<colgroup><col width="215" style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <tbody> </tbody>

 

[123rickfear]

could you not do this?

=IFERROR(IF(ISBLANK(B2),"",B2+1),"")

 

[mtr1213]

nope that didn't work...I used what you suggested =IFERROR(IF(ISBLANK(A2)," ",1000+1)," ") and Issue ID is Blank; yes that is what I want it to do but when I add an employee Name I get the other Issue ID in the order accordingly.


This is before I add a name; so if I don't want the other IDs to appear until the next name I want the cell blank.

Employee Name	Issue ID
	1
	2

<colgroup><col width="215" style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <tbody> </tbody>

 

[mtr1213]

when the employee names get added the issue ids should be created automatically and if the same employee gets entered i want the same id so this part is working i just don't want the next ID to show up until the name is added...

Employee Name	Issue ID
Mickey Mouse	1001
Donald Duck	1002
Mickey Mouse	1001
Daffy Duck	1003
Bugs Bunny	1004
Mickey Mouse	1001
	1005
	1006
	1007

<colgroup><col width="215" style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <tbody> </tbody>

 

[Matty]

If I follow, is this what you want?

B2, copied down:

=IF(A2="","",IF(ROWS(B$2:B2)=1,1001,IF(COUNTIF(A$2:A2,A2)>1,INDEX(B$1:B1,MATCH(A2,A$1:A1,0)),MAX(B$1:B1)+1)))

Matty

 

[123rickfear]

a