comparing dates: surya

[surya and siva]

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

 

[surya and siva]

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 FALSE
1 27 21 Oct 25, 2007 Oct 25, 2007 Oct 25, 2007
1 27 5 Oct 18, 2007 FALSE

the picture of the table which was mentioned in the below/previos mail is
not in a good format. so please consider the above one.








:

 

[Shane Devenshire]

Hi,

Try something like this:

=IF(AND(A2=1,B2=27,D2=E2),E2,"")

Assuming your first row of data is row 2 and copy down as neeeded.

 

[surya and siva]

hi Shane Devenshire,
here the criteria is different, i will let you know clearly..the column A is
SITE NO, column B is PATIENT NO, column c is VISIT NO..so..D column date of a
SITE NO (column A), of a particular PATIENT NO (column B) at a perticular
VISIT NO (Column C) with the date of (column D) matches with any of the date
of (column E) oof a same SITE NO (column A),PATIENT( NO column B) then the
matching date should reflect in column E, if not display it as "check".


site patient visit date
date Result
A B C D
E F
1 27 17 Oct 25, 2007 Oct 4, 2007 Oct 4, 2007
1 27 1 Oct 4, 2007 Oct 11, 2007 check
1 27 21 Oct 25, 2007 Oct 25, 2007 Oct 25, 2007 1 27 5 Oct 18,
2007 check

 

[surya and siva]

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.

 

[Max]

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
---