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

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

<tbody>
</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,"")