Another venture ..

Assuming your source data is in cols A to E, from row2 down
In F2, normal ENTER:
=IF(COUNT(A2:B2,D2)<3,"",IF(ISNUMBER(MATCH(1,INDEX ((A$2:A$100=A2)*(B$2:B$100=B2)*(E$2:E$100=D2),),0) ),D2,"check"))
Copy F2 down. Adapt the ranges to suit the actual extents of your source data.

For your sample data posted, you'd get this result in F2:F5, viz.:

25-Oct-07
4-Oct-07
25-Oct-07
check

(Believe you had a typo for line 3 in indicating your sample results)

Success? Wave it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"surya and siva" wrote:
site patient visit date1 date2 result
1 27 17 25-Oct-07 4-Oct-07 25-Oct-07
1 27 1 4-Oct-07 11-Oct-07 4-Oct-07
1 27 21 25-Oct-07 25-Oct-07 check
1 27 5 18-Oct-07 check

please keep in mind that the SITE no and Patient no varies...site contains
many patients.
so the formula should compare the date of a date 1 column with any date of
a date2 column with in the same site of a same patent.

"surya and siva" wrote:

hi friend,
here i just want a comparision, if the criteria matches i want the same date
to be reflected. here is the senario.
A B C D
E F(result)
1 27 17 Oct 25, 2007 Oct 4, 2007 Oct 4, 2007
1 27 1 Oct 4, 2007 Oct 11, 2007
1 27 21 Oct 25, 2007 Oct 25, 2007 Oct 25, 2007
1 27 5 Oct 18, 2007
so IF A=1, and B=27 then E date should match with D date, if matches i want
that date should be reflected in F coumn.
like this there are n number of Categories are dere in A collum Eg:
1,2,3,4,5,....so on and each Category contains sub-category...so please give
a formula which can be applicable to all. Please help me out as soon as
possible.
thanking you.
surya