IF Formulas with 2 variables

[bilbolobi]

Thanks for looking at this post. I am looking for some assistance.
I have a spreadsheet with a number of individual sites (Actualy 9K) each site can have a number of start dates. I need to identify per site any start dates which would be < to 14 Days.
This is for each individual sites.
thanks Antoine

[TABLE="width: 139"]
<tbody>[TR]
[TD]Site
[/TD]
[TD]Start
[/TD]
[/TR]
[TR]
[TD]Site 1
[/TD]
[TD="align: right"]01/03/2013
[/TD]
[/TR]
[TR]
[TD]Site 1
[/TD]
[TD="align: right"]02/04/2013
[/TD]
[/TR]
[TR]
[TD]Site 2
[/TD]
[TD="align: right"]03/03/2013
[/TD]
[/TR]
[TR]
[TD]Site 2
[/TD]
[TD="align: right"]04/12/2013
[/TD]
[/TR]
[TR]
[TD]Site 1
[/TD]
[TD="align: right"]04/03/2013
[/TD]
[/TR]
[TR]
[TD]Site 2
[/TD]
[TD="align: right"]04/07/2013
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

I need to identify per site any start dates which would be < to 14 Days.

14 days from what? The current date? Some other date?
What actually do you want to happen to these records? Are you formatting them or want to return some text or something?
Maybe if you tell us the expected results based on the sample you posted, it will help show what you are after?

 

[bilbolobi]

Hi Joe
The objective is to identify if one site has received 2 work order in less than 14 days. If yes the cell will say > 14 days.
Thanks

edward

 

[Joe4]

Let's say that you data is in columns A and B and your first row of data is in row 2, and you have 9000 rows of data. Then you can place this formula in cell C2 and copy down for all rows:

=IF(SUMPRODUCT(--(A$2:A$9000=A2),--(B$2:B$9000>=(B2-14)),--(B$2:B$9000<=(B2+14)))>1,"2 work orders in less than 14 days","")

 

[bilbolobi]

Let's say that you data is in columns A and B and your first row of data is in row 2, and you have 9000 rows of data. Then you can place this formula in cell C2 and copy down for all rows:

=IF(SUMPRODUCT(--(A$2:A$9000=A2),--(B$2:B$9000>=(B2-14)),--(B$2:B$9000<=(B2+14)))>1,"2 work orders in less than 14 days","")

Hi Joe,

Thanks so much for your help. I was trying to identify an alternative last night and came up with the long way
=IF(A2=A3,B3-B2,"")
=IF(SUMIF($A$2:$A$6,A2,$C$2:$C$6)>14,"WARNING","")

Thanks again