Identifying lastest/Lst Update in a list

[basel_faulty]

I have created a log where colleagues go in to update their preferences.
What i am looking to do is identify what line is the last update for any/all of the colleagues who have filled in.

As below i am looking to identify as i have in column C the line where these colleagues last updated?

Any ideas?

Cheers
B_F

<tbody>
[TD="class: xl65"][/TD]
[TD="class: xl65"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[TD="class: xl65, width: 64"]C[/TD]

[TD="class: xl65, width: 64"]2[/TD]
[TD="class: xl66, width: 64"]Log[/TD]
[TD="class: xl66, width: 64"]Emp ID[/TD]
[TD="class: xl66, width: 64"]LATEST[/TD]

[TD="class: xl65, width: 64"]3[/TD]
[TD="class: xl66, width: 64, align: right"]1[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]4[/TD]
[TD="class: xl66, width: 64, align: right"]2[/TD]
[TD="class: xl66, width: 64, align: right"]7751326[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]5[/TD]
[TD="class: xl66, width: 64, align: right"]3[/TD]
[TD="class: xl66, width: 64, align: right"]2217317[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]6[/TD]
[TD="class: xl66, width: 64, align: right"]4[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]7[/TD]
[TD="class: xl66, width: 64, align: right"]5[/TD]
[TD="class: xl66, width: 64, align: right"]7751326[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]8[/TD]
[TD="class: xl66, width: 64, align: right"]6[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]9[/TD]
[TD="class: xl66, width: 64, align: right"]7[/TD]
[TD="class: xl66, width: 64, align: right"]7751326[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]10[/TD]
[TD="class: xl66, width: 64, align: right"]8[/TD]
[TD="class: xl66, width: 64, align: right"]2217317[/TD]
[TD="class: xl66, width: 64, align: center"]TRUE[/TD]

[TD="class: xl65, width: 64"]11[/TD]
[TD="class: xl66, width: 64, align: right"]9[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]12[/TD]
[TD="class: xl66, width: 64, align: right"]10[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]13[/TD]
[TD="class: xl66, width: 64, align: right"]11[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]14[/TD]
[TD="class: xl66, width: 64, align: right"]12[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]15[/TD]
[TD="class: xl66, width: 64, align: right"]13[/TD]
[TD="class: xl66, width: 64, align: right"]7751326[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]16[/TD]
[TD="class: xl66, width: 64, align: right"]14[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]17[/TD]
[TD="class: xl66, width: 64, align: right"]15[/TD]
[TD="class: xl66, width: 64, align: right"]7751326[/TD]
[TD="class: xl66, width: 64, align: center"]TRUE[/TD]

[TD="class: xl65, width: 64"]18[/TD]
[TD="class: xl66, width: 64, align: right"]16[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl67, width: 64"][/TD]

[TD="class: xl65, width: 64"]19[/TD]
[TD="class: xl66, width: 64, align: right"]17[/TD]
[TD="class: xl66, width: 64, align: right"]9603444[/TD]
[TD="class: xl66, width: 64, align: center"]TRUE[/TD]

[TD="class: xl68"]Sheet1[/TD]

</tbody>

 

[etaf]

you could use a countif()
in C
put
=IF(COUNTIF(B3:B18,B2)=0, TRUE, "")
and copy down

Not as you copy down the range also changes - that is delibrate

 

[etaf]

Excel Workbook
	A	B	C
1	Log	Emp ID	LATEST
2	1	9603444
3	2	7751326
4	3	2217317
5	4	9603444
6	5	7751326
7	6	9603444
8	7	7751326
9	8	2217317	TRUE
10	9	9603444
11	10	9603444
12	11	9603444
13	12	9603444
14	13	7751326
15	14	9603444
16	15	7751326	TRUE
17	16	9603444
18	17	9603444	TRUE
Sheet1

 

[basel_faulty]

Thanks,

a ****ed sight easier than the convoluted ways i was thinking

B_F

 

[Aladin Akyurek]

Not sure it's faster,probably it is...

In C2 enter and copy down:

=IF(A2=LOOKUP(9.99999999999999E+307,1/($B$2:$B$18=$B2),$A$2:$A$18),TRUE,"")