| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a row based on date
worksheet 1 contains rows of data including a column of dates - I want to
link the row with the latest date into a row in worksheet 2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a row based on date
Say Sheet1 has dates in column A. The latest date is the max value (cause
dates are just numbers). We find the max in column A and use OFFSET() to get the rest of the row: =OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1 !$A:$A)-1,COLUMN()-1) and copy across -- Gary''s Student - gsnu200803 "na" wrote: worksheet 1 contains rows of data including a column of dates - I want to link the row with the latest date into a row in worksheet 2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a row based on date
That worked - thank you very much!!
"Gary''s Student" wrote: Say Sheet1 has dates in column A. The latest date is the max value (cause dates are just numbers). We find the max in column A and use OFFSET() to get the rest of the row: =OFFSET(Sheet1!$A$1,MATCH(MAX(Sheet1!$A:$A),Sheet1 !$A:$A)-1,COLUMN()-1) and copy across -- Gary''s Student - gsnu200803 "na" wrote: worksheet 1 contains rows of data including a column of dates - I want to link the row with the latest date into a row in worksheet 2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying rows from 2 sheets to a new worksheet based on date criter | Excel Discussion (Misc queries) | |||
| Sumproduct based which also weights data based on date | Excel Worksheet Functions | |||
| Copying data based on a condition | Excel Worksheet Functions | |||
| copying feilds based on a value | Excel Discussion (Misc queries) | |||
| copying cells based on criteria | Excel Worksheet Functions | |||
Linear Mode
