| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offset match | Excel Discussion (Misc queries) | |||
| OFFSET & MATCH | Excel Discussion (Misc queries) | |||
| IF, OFFSET,MATCH Please Help | Excel Discussion (Misc queries) | |||
| Using Match & Offset | Excel Worksheet Functions | |||
| Using MAX with OFFSET and MATCH | Excel Worksheet Functions | |||
![Andrew Scurrah[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
