LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Attempting to sort unique/only count first record in each unique g

(...Could I have been any more cryptic?)

Hi All,

I'm currently trying to find a way to sort through several thousand customer
records (rows) in a sheet, filter in only the initial entries for each unique
customer (by date) and sum each unique initial record in each month/qtr/year
(the purpose is to determine in what month/year their initial purchase was).
I couldn't think of any remotely simple way to do this, any ideas on how to
do this minus VBA?

Thanks,

Jamie
 
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
how do I create a template that gives each record a unique number? Siniss Excel Worksheet Functions 4 May 27th 07 06:15 PM
EXTRACTING UNIQUE RECORD BASED ON CONDITION SSJ New Users to Excel 6 April 19th 07 04:53 AM
How to Sort by Count the Max nos of Unique text values in Pivot Ta ToExcelAtExcel Excel Discussion (Misc queries) 1 November 7th 06 08:45 AM
Using a listbox to show every unique record in a range [email protected] Excel Worksheet Functions 4 July 19th 06 06:04 PM
Display unique record BBTMAMA Excel Discussion (Misc queries) 3 September 11th 05 03:40 PM


All times are GMT +1. The time now is 03:41 AM.

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

About Us

"It's about Microsoft Excel"