Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using functions to correlate data
Hi there.
I want to use a function to reduce the workload in a spreadsheet by having it automatically correlate data for me. The layout is this. The first coumn has dates. The second column has the particular events happening on those dates. I then have a second spreadsheet. What I want is to be able to enter any particular date on that spreadsheet, and have the formula automatically enter the event into a blank box. I'd then also like to have it look up all of the people in attendance on that date, and enter them into a set of rows beneath the date and event. I realize this all sounds a little complicated, but I'm trying to set up three months' worth of event programming, and it would simplify everything no end! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using functions to correlate data
Hi,
Where are all the people in attendance? Sheet1: A B 1/1/2009 Kickoff 1/2/2009 Farewell for JT 1/5/2009 Seminar .... And where do you want the people so show up on the sheet where you enter the date? Sheet2: A B 1/2/2009 Farewell for JT -- Thanks, Shane Devenshire "Benjamin Searle" wrote: Hi there. I want to use a function to reduce the workload in a spreadsheet by having it automatically correlate data for me. The layout is this. The first coumn has dates. The second column has the particular events happening on those dates. I then have a second spreadsheet. What I want is to be able to enter any particular date on that spreadsheet, and have the formula automatically enter the event into a blank box. I'd then also like to have it look up all of the people in attendance on that date, and enter them into a set of rows beneath the date and event. I realize this all sounds a little complicated, but I'm trying to set up three months' worth of event programming, and it would simplify everything no end! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to correlate rows/columns | Excel Worksheet Functions | |||
Pivot table could allow to correlate text labels. | Excel Discussion (Misc queries) | |||
Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21 | Excel Worksheet Functions | |||
Lines on chart don't correlate to values being charted | Charts and Charting in Excel | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |