WOW Thanks Max. I'll give it a try and let you know.

"Max" wrote:

Your criteria is quite complex. Here's one formulas way to model it up, using
a couple of cols for better clarity in the processes involved ..

Source data as posted in A2:C6,
with real dates presumed chronologic in C2 down

In D2: =COUNTIF($B$2:B2,B2)

In E2, normal ENTER:
=IF($D21,INDEX(C$2:C$6,MATCH(1,INDEX((B$2:B$6=$B2 )*(D$2:D$6=$D2-1),),0)),"")

In F2, normal ENTER:
=IF($D21,INDEX(A$2:A$6,MATCH(1,INDEX((B$2:B$6=$B2 )*(D$2:D$6=$D2-1),),0)),"")

Then in G2:
=IF(E2="","",IF(AND(C2-E2<180,(A2-F2)/F225%),"x",""))
Copy D2:G2 down to G6. Col G will flag those cases which satisfy the complex
criteria with "x".

Col D marks the instances of the addresses in col B. Cols E/F then extracts
the cost/date of the (n-1)th instance from cols A and C. Col G finally
computes the required comparisons/criteria of dates < 6 mths* apart & cost
delta 25%, and flags such cases.
*taking 1 mth = 30 days

Adapt to suit the extents of your actuals.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Bad_Shot" wrote:
I use Excel 2003.
I pulled good info off this forum and off other sites referenced within.

I can do what Im trying to do with filters, formulas and macros, etc.
But to I can do it faster with a calculator.

Heres my data:

A B C
1 Sale Price Address Sale Date
2 $25000 216 Oak Ave 12/7/2007
3 $35500 14 Wyman St 1/12/2008
4 $29000 216 Oak Ave 7/1/2008
5 $49000 14 Wyman St 9/30/2008
6 $45000 216 Oak Ave 10/2/2008

I need to find all sales that were less then 6 months apart, and the sales
price was 25% greater then the previous price. In this case row 6 would be
true. Note the rows can be from 250 to 1500 per month.