Unique value of PO Created using formula.

Could any one suggest me a formula using attach excel file.

I want three conditions.

1) Date
2) Completed date
3) Unique PO Numbers.


Thanks & Regards
Dnyashwar Gorad

Hi I want same PO Number which was completed on different date and status of the PO for the second sheet.

Use this macro to identify all unique value, copy it to sheet 2 and fetch other two column in VLOOKUP

Sub UniqueList()
Dim lastrow As Long

lastrow = Cells(Rows.Count, "A").End(xlUp).Row

ActiveSheet.Range("A2:A" & lastrow).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=ActiveSheet.Range("H2"), _
Unique:=True

End Sub