LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default help filtering for unique records - urgent :)

I can't find my org post, so reposting..sorry.

I have a worksheet that has multiple columns, with multiple dates..

Acct Nu Assign Dt Date 1 Date 2 Date 3 Date 4 Date 5
1234567 10/10/09 10/13/09 10/16/09 10/19/09 10/22/09 10/25/09
2345678 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09 10/30/09
3456789 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
4567890 10/11/09 10/14/09 10/17/09 10/20/09 10/23/09 10/26/09
5678901 10/12/09 10/15/09 10/18/09 10/21/09 10/24/09 10/27/09
6789012 10/17/09 10/20/09 10/23/09 10/26/09 10/29/09 10/12/09

I need to filter for all acct #s with a follow up date of 10/24/09 (or
whatever date I need). I have tried all versions of advanced filter, but it
does not allow you to search by multiople date across columns. Please help!
--
crazidazi3
 
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
Filtering for Unique Records captculver Excel Discussion (Misc queries) 3 March 31st 08 04:42 PM
Flitering for unique records in Col B based on filtering in Col A masik Excel Discussion (Misc queries) 1 May 19th 07 09:47 PM
filtering unique records ajit Ajit Munj Excel Discussion (Misc queries) 0 May 19th 07 03:28 PM
Filtering for Unique Records with multiple-column criteria crcurrie Excel Discussion (Misc queries) 5 April 10th 07 10:06 AM
filtering for unique records KG Excel Discussion (Misc queries) 7 August 13th 05 06:07 PM


All times are GMT +1. The time now is 09:22 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"