Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Parsing in Excel?
I do not know any VB but I have experience with C and Java. I have data sets on a worksheet that are from different days, which are then orgranized into one worksheet per week. Can anyone explain how I could make a form inside a work sheet that would allow me to enter in a pair of dates to display a particualr summation of the data set in a graph depending on the time frame the user requests. EX: Hours worked sheet: 9/22/04 15 9/23/04 4 9/24/04 10 Report Sheet: Data Range: __________ (user enters: 9/22/04 - 9/24/04) Hours worked: 29 Thanks, David -- DavidMunday |
#2
|
|||
|
|||
Quote:
Column A has your dates Column B has the hours worked In C1 You should have a Start Range then C2 would be the End Range. =SUM(INDIRECT(CONCATENATE("B",MATCH(C1,A:A,0))&":" &CONCATENATE("B",MATCH(C2,A:A,0)))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |