View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Scurrah[_2_] Andrew Scurrah[_2_] is offline
external usenet poster
 
Posts: 2
Default Using Offset and Match

I wonder if some one can help me...

I have below a spreadsheet that tracks certain data
items...

Pt Site Visit 1 Visit 2 Visit 3
A001 115 12-Jan-2004
B001 152 19-Feb-2004 28-Mar-2004
A001 115 19-Feb-2004 22-Mar-2004
C001 115 21-Mar-2004 31-May-2004
B001 115 11-Apr-2004
C001 115 19-Jun-2004

What I would like to do is combine the rows with
identical "Pt" and "Site" values into ONE row in a second
sheet...as follows...

Pt Site Visit 1 Visit 2 Visit 3
A001 115 12-Jan-2004 19-Feb-2004 22-Mar-2004
B001 152 19-Feb-2004 28-Mar-2004 11-Apr-2004
C001 115 21-Mar-2004 31-May-2004 19-Jun-2004

I've tried to use OFFSET and MATCH, but I think my
arguments are incorrect...they can't find the data in the
first sheet correctly...


Can anyone help me ???

Thank you in advance...In desparate need to make this
work...

Sincerely,

Andrew Scurrah