If then
Array formula (commit with CTRL+SHIFT+ENTER):
=IF(MIN(IF(Raw!$D$2:$D$2368=F2,
--(Raw!$R$2:$R$2368""),""))=1,
"","Non-")&"Compliant"
OR
=IF(SUM(--(A1:A21=D4))=
SUM((A1:A21=D4)*(B1:B21"")),
"","Non-")&"Compliant"
PAL wrote:
Sorry should have asked better. What I am trying to do is....
Look at all the records for each individual (F2),and ask if there is a date
in the column? If there is a date in all the records (ie 10/10) for the
individual (F2), then I want to put in "compliant", if only (ie 9/10) have
dates), then "non-compliant"
"Gary Brown" wrote:
Are you trying to fill a SINGLE cell with 'Compliant' or 'Non-Complient' OR
do you want to test each row for Compliance?
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
"PAL" wrote:
I have a multi column (10), multi row(1000s) table. I am trying the
following formula, with if two conditions are true.
=IF(AND(Raw!$D$2:$D$2368=F2,Raw!$R$2:$R$2368""), "Compliant",
"Non-Compliant").
It doesn't seem to work. Ideas.
Thanks.
|