Compare and find the two different column repeated cell value

[Duraivel59]

Greetings,

I do have colum A ( Tickets) & B ( Status) both have multiple repeated entried. But I have to get the output where the column A value & the status match as defined . Below is the example.

Before:
Column A Column B
10001 Assigned
10001 In-Progress
10001 Completed
10002 Assigned
10002 In-Progress
10002 In-Progress
10002 In-Progress
10002 Cancelled
10003 In-Progress
10003 In-Progress
10003 In-Progress
10003 In-Progress
10003 In-Progress


I need to get a output :

Column A Column B Column C
10001 Assigned
10001 In-Progress
10001 Completed Completed
10002 Assigned
10002 In-Progress
10002 In-Progress
10002 In-Progress
10002 Cancelled Cancelled
10003 In-Progress
10003 In-Progress
10003 In-Progress
10003 In-Progress
10003 In-Progress In-Progress


OR

High light the Colum B cell value instead on puting in to the Column C.


-----

I can use Macro or other condition fornula's. Please help me , I am fighting with this formula from this morning ( 5 hrs ) .

Thanks in Advance,
DT.

[Ace_XL]

In Column B use this rule for conditional formatting

=COUNTIF($A$1:A1,A1)=COUNTIF(A:A,A1)

format red

[Duraivel59]

Ace_XL ,

You are really fentastic , you just did in a min. It works great . I have sorted both column and then applied you rule on B , then it highlighted the last cell on column B based on the column A.

Cheers,
DT.