Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel 2000: Sort/Group By/Min/Mina?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel 2000: Sort/Group By/Min/Mina?

Old 07-29-04, 04:28 PM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Aug 2002
Location: Triangle, NC, USA
Posts: 8,810
Received 0 Likes on 0 Posts
Excel 2000: Sort/Group By/Min/Mina?

I've got an Excel file that has a sheet with ~25000 line items.
One item is repeated, it is, shall we say 'Order number'. Each order number can have multiple lines, for each item that was ordered. Each line has an 'Ordered On Date/Time' field for each item.

My problem: I only want the *first*, ie, *earliest* Ordered On Date/Time for each 'Order Number.' [They are sorted in order of Order Number, and then by Ordered On date/Time.]

I've tried using Subtotals, which I'm not real good at, no help; I tried using a Duplicate Remover, which did remove the duplicates, but I still have to manually scan the list for the earliest 'ordered On.'
I've tried Mina but that didn't work.

Any suggestions would be greatly appreciated.
Old 07-30-04, 10:07 AM
  #2  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Aug 2002
Location: Triangle, NC, USA
Posts: 8,810
Received 0 Likes on 0 Posts
Well, if anyone was interested, I figured out a workaround.
Since everything was sorted by Order number, then by 'Ordered On D/T' what I did was create an additional column next to Order number, and went =SUM(B2-B1) where B is the Order number column. So anywhere that the Order number is the same will be 0, except for the first appearance of it. Then I just auto-filtered by that column and deleted every row that had a 0 in it.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.