please help assign a unique id to id coloumn if the 3 coloumns match

[wrighty998]

please help i need a formula that will assign a id number if the 3 coloumns match i have 700 lines of data each week to sort


INPUT
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]id
[/TD]
[TD]customer
[/TD]
[TD]area
[/TD]
[TD]address
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]red lane
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]peter
[/TD]
[TD]2
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
</tbody>[/TABLE]



OUTPUT
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]id
[/TD]
[TD]customer
[/TD]
[TD]area
[/TD]
[TD]address
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]red lane
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]red lane
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]peter
[/TD]
[TD]2
[/TD]
[TD]blue lane
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]bob
[/TD]
[TD]1
[/TD]
[TD]blue lane
[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

With yout table pasted into place this in A2:

=IFERROR(INDEX($A$1:A1,MATCH(1,INDEX(($B$1:B1=B2)*($C$1:C1=C2)*($D$1:D1=D2),0),0)),MAX($A$1:A1)+1)

 

[wrighty998]

With yout table pasted into place this in A2:

=IFERROR(INDEX($A$1:A1,MATCH(1,INDEX(($B$1:B1=B2)*($C$1:C1=C2)*($D$1:D1=D2),0),0)),MAX($A$1:A1)+1)

amazing mate thats brill