Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to look up a date and add x, y, z columns to x, y, z row
I am taking information from sheet 1 in Excel to combine in Sheet 2
There are alot more columns the i show here but you get the idea Date of service Repair Maintenance Color Cut 1/1/5 10 1/3/5 30 12/1/5 40 11/1/5 90 i want to search this information and have it add up in sheet 2(november) November Rev Collected Repair Main Color 90 Cut This will reoccur on each new sheet which will be the new month. Please let me know if this is possible. Thanks Sally |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to look up a date and add x, y, z columns to x, y, z row
I'd use a helper column to get the month and year if necessary. Let's say
A2 has the date, in the helper column row 2, I'd enter =month(A2)&"-"&year(A2) and copy down. I'd then use a pivot table to get the information you need. "Sally J" wrote in message ... I am taking information from sheet 1 in Excel to combine in Sheet 2 There are alot more columns the i show here but you get the idea Date of service Repair Maintenance Color Cut 1/1/5 10 1/3/5 30 12/1/5 40 11/1/5 90 i want to search this information and have it add up in sheet 2(november) November Rev Collected Repair Main Color 90 Cut This will reoccur on each new sheet which will be the new month. Please let me know if this is possible. Thanks Sally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|