RE: Formula that brings in daily input from a range of cells.
- From: Sean Timmons <SeanTimmons@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Aug 2009 12:02:03 -0700
Presuming the numbers 1 - 31 are in row 1, starting in A.
=INDEX(Data!C1:AG2,2,MATCH(DAY(TODAY()),C1:AG1))
C1:AG2 is your range.. you can change to, say, C1:AG50 to capture 50 rows.
,2, says look in the 2nd row for this stat.
DAY(TODAY()) assumes you want to pull current day's stats. you can do
DAY(TODAY())-1 to get yesterday's.. or you can just enter the date in, say,
cell A1 of your summary sheet, then it's just
MATCH(A1,C1:AG1)
"jmort1" wrote:
Can someone help me with creating a summary worksheet that extracts the data.
from a secondary daily input worksheet? On the daily input worksheet, there
is a column for every day of the month, 1 thru 31. Eack day we input the
number of rooms our hotel sells. Ex.) Column C is day 1, a row under it is a
manual input cell for rooms sold that day (50). So from left to right each
day has an input of the rooms sold. What I'm trying to do is create a
"summary" worksheet that will automatically pull the newest days data. I
thought of If statements, but I'd have a string a mile long and I'm not
knowledgable enough in excel to even begin this. Should state that there are
about a dozen stats I wish to do the same thing with, all of the info is on
the data worksheet, but I need this summary information to cycle forward to
the next days amounts.
- Follow-Ups:
- References:
- Prev by Date: Re: Font Sizing
- Next by Date: Re: Formula that brings in daily input from a range of cells.
- Previous by thread: Formula that brings in daily input from a range of cells.
- Next by thread: Re: Formula that brings in daily input from a range of cells.
- Index(es):
Relevant Pages
|
