Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Duplicate Entries
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. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate entries | Excel Worksheet Functions | |||
Duplicate entries | Excel Discussion (Misc queries) | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
Duplicate Entries | Excel Discussion (Misc queries) | |||
Duplicate entries | New Users to Excel |