Unique Id number

[LValencia]

I would like to create an automatic unique Id number in cell A1, the data would come from B1, C1 and D1. B and C are numbers and D is text. The cell data looks like this B1=20, C1=24, D1=GVI. The auto number would look like this 2024GVI. I have tried several ideas but get errors since I have a text field.
I appreciate any help

 

[LValencia]

OK try this...

	A​	B​	C​	D​
1​	20-24-GVI-001	20​	24​	GVI
2​	20-24-GVI-002	20​	24​	GVI
3​	20-24-GVI-003	20​	24​	GVI
4​	20-48-GVI-001	20​	48​	GVI
5​	20-48-GVI-002	20​	48​	GVI
6​	20-48-GVI-003	20​	48​	GVI

<tbody>
</tbody>

=B1&"-"&C1&"-"&D1&"-"&TEXT(COUNTIFS($B$1:B1,B1,$C$1:C1,C1,$D$1:D1,D1),"000")
copied down

Yes

 

[LValencia]

this is exactly what I wanted, You DA MAN!!!