Posted to microsoft.public.excel.programming

Angus

external usenet poster

Posts: 81

VBA Advanced Filter - latest lines for multi criteria

Hi,

i have data like following, which is the salesman responsible for each state
until a specific time:

David - CA - 2008/1/12
Peter - NY - 2008/5/25
Susan - CA - 2009/3/25
David - NY - 2008/4/20

How do I search "CA" and it will show latest records for each salesman has
been working in CA, ie,

David - CA - 2008/1/12
Susan - CA - 2009/3/25

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Advanced filter criteria	Andy Faulkner	Excel Discussion (Misc queries)	2	February 4th 10 09:09 AM
Criteria for Advanced Filter HELP	knowshowrosegrows	New Users to Excel	5	February 21st 09 12:32 PM
Advanced filter criteria for <	Dianne Butterworth	Excel Programming	1	August 22nd 07 02:30 AM
Advanced filter criteria	Phil C	Excel Discussion (Misc queries)	4	April 10th 07 07:48 AM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du	TC	Excel Worksheet Functions	1	May 12th 05 02:06 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us