LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
duplicate entries HR Director Excel Worksheet Functions 5 January 1st 09 06:19 AM
Duplicate entries Secret Squirrel Excel Discussion (Misc queries) 2 October 31st 06 11:03 AM
Duplicate Entries Phxlatinoboi® Excel Discussion (Misc queries) 2 August 24th 06 01:17 AM
Duplicate Entries ConfusedNHouston Excel Discussion (Misc queries) 1 November 1st 05 12:50 PM
Duplicate entries Keggarboy New Users to Excel 3 April 30th 05 08:26 AM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"