Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dates comparision
i want a formula for the following issue.
A B C D E F G H site patient d1 d2 d3 d4 d5 D6 1 27 sep 27,07 sep 29,07 oct 2,07 Oct 4,07 1 27 Oct 4,07 Oct 6,07 Oct 9,07 Oct 18,07 1 27 Oct 11,07 Oct 13,07 Oct 16,07 Oct 25,07 1 27 Oct 18,07 Oct 20,07 Oct 23,07 Oct 18,07 1 28 Oct 4,07 Oct 6,07 Oct 9,07 Oct 18,07 1 28 Oct 11,07 Oct 13,07 Oct 16,07 Oct 25,07 1 28 Oct 18,07 Oct 20,07 Oct 23,07 Oct 18,07 A = site, B= Patient C:H= are dates mentioned as d1, d2, d3, d4, d5, D6 Descreption:the data mentioned above is a piece of data to present the senario. If site no is 1 and Patient no is 27 then i need the date comparison of D6 with the dates of d1 to d5, if the same date of D6 is found in d1 to d5 of aparticular site of a particular patient that date i want to be in column I. eg: column H2 (D6) = Oct 4,07 of (column A) site=1 of a patient =27 is matching with d3, so this result date should come on I2, if it is not matching it sould show as "check". thanking you, surya |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
dates comparision
Hi,
In cell I2 enter the array formula =IF(OR(C2:G2=H2),H2,"check") array - means you press Shift+Ctrl+Enter to enter the formula in the cell Copy it down as far as needed. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "surya and siva" wrote: i want a formula for the following issue. A B C D E F G H site patient d1 d2 d3 d4 d5 D6 1 27 sep 27,07 sep 29,07 oct 2,07 Oct 4,07 1 27 Oct 4,07 Oct 6,07 Oct 9,07 Oct 18,07 1 27 Oct 11,07 Oct 13,07 Oct 16,07 Oct 25,07 1 27 Oct 18,07 Oct 20,07 Oct 23,07 Oct 18,07 1 28 Oct 4,07 Oct 6,07 Oct 9,07 Oct 18,07 1 28 Oct 11,07 Oct 13,07 Oct 16,07 Oct 25,07 1 28 Oct 18,07 Oct 20,07 Oct 23,07 Oct 18,07 A = site, B= Patient C:H= are dates mentioned as d1, d2, d3, d4, d5, D6 Descreption:the data mentioned above is a piece of data to present the senario. If site no is 1 and Patient no is 27 then i need the date comparison of D6 with the dates of d1 to d5, if the same date of D6 is found in d1 to d5 of aparticular site of a particular patient that date i want to be in column I. eg: column H2 (D6) = Oct 4,07 of (column A) site=1 of a patient =27 is matching with d3, so this result date should come on I2, if it is not matching it sould show as "check". thanking you, surya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date range comparision on a criteria | Excel Discussion (Misc queries) | |||
vlookup for more than two comparision | Excel Discussion (Misc queries) | |||
Date comparision | Excel Discussion (Misc queries) | |||
text comparision | Excel Discussion (Misc queries) | |||
Comparision formula | New Users to Excel |