Can't you just sort by colB and then col A

--
Don Guillett
SalesAid Software

"Rita Palazzi" wrote in message
...
Windows XP Professional
Office 2000

I have a spreadsheet where daily data is entered. It is set up similar to
following example:


Date Port Shpts Pcs

4-Nov EWR 25,693 30,615 4-Nov IND 40,593 143,778 4-Nov OAK 25,047 43,928
4-Nov MEM 209,126 290,865 4-Nov ANC 93,392 193,251 4-Nov MIA 10,153 11,621
11-Nov EWR 31,729 37,687 11-Nov IND 37,413 135,287 11-Nov OAK 27,148
45,139 11-Nov MEM 215,890 290,591 11-Nov ANC 92,635 178,298 11-Nov MIA
11,233 13,744 18-Nov EWR 31,979 37,329 18-Nov IND 41,807 153,256 18-Nov
OAK 29,081 50,603 18-Nov MEM 217,948 300,548 18-Nov ANC 95,017 190,090
18-Nov MIA 10,583 12,428



On a difference worksheet, I want to compile trend information for each
port so that a table is set up as below:


Date Port Shpts Pcs
4-Nov ANC 93,392 193,251 11-Nov ANC 92,635 178,298 18-Nov ANC 95,017
190,090

Date Port Shpts Pcs
4-Nov EWR 25,693 30,615 11-Nov EWR 31,729 37,687 18-Nov EWR 31,979 37,329



Any ideas on how to best achieve the needed output? I familiar with
VLOOKUP, but unsure how to use it to look for Date AND Port...


Thanks in advance for any help you can give...

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express