want to forumla for my query Excel Question

[iGuest 3]

want to forumla for my queryExcel Question

Hi,I have data in two column and I want paste Highest date in 3rd column all same check ids if you have any formula so Please suggest me and revert me on my mail id with example A B CCheck ID Date Highest Date7864 12-Apr-86 7864 13-Apr-86 7864 14-Apr-86 7864 15-Apr-86 8654 16-Apr-86 8654 17-Apr-86 8654 18-Apr-86 8654 19-Apr-86 8654 20-Apr-86 95476 21-Apr-86 95476 22-Apr-86 95476 23-Apr-86 95476 24-Apr-86 95476 25-Apr-86 95476 26-Apr-86 254645 27-Apr-86 254645 28-Apr-86 254645 29-Apr-86 254645 30-Apr-86 Please revert me as soon as possible.Thanx & RegardsAnkit Rawat

-question by Ankit Rawat