Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding only part of a column of data
I have a weekly report that I send out to our team. I gather data for the
current year each month and use vlookup for most of the report. However, I need to report some of the numbers from last year as well. I have the weeks numbered consecutively in column A. On my report I enter the current week number to gather the data from the vlookup. How can I get it to give me a year to date total from the worksheet from last year? Example: I am currently reporting week 8 numbers on my report. I can get my current YTD number, but I need to know how to get my LY numbers for week 1-8. This will need to change as I change the week number on my report. Does this make sense? -- keith jones |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding only part of a column | Excel Worksheet Functions | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Adding a letter to the beginning of each part number of a column | Excel Discussion (Misc queries) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
Adding column data | Excel Worksheet Functions |