Help with formul-easy for you guys I think.

[jtees4]

Help. I need to know the formula to figure this out. I need the
formula for the cells with the question marks. Example: The total
Dances column would be 2 for Bill, 0 for Ann, 2 for Harry, 0 for
Walter. Then I need the other to columns filled in as well. I hope
this makes some sense. This was completely made up but I can adapt it
to a real problem I am having at work.
Thanks for any help.


Ann Eat 1 Total total total
Bill Dance 1 Total Dances Eats Fun
Bill Dance 1 Bill 2 ? ? ?
Harry Dance 1 Ann 1 ? ? ?
Harry Dance 1 Harry 4 ? ? ?
Harry Eat 1 Walter 2 ? ? ?
Harry Eat 1
Walter Fun 1 TOTAL 9
Walter Fun 1






Please check out my music....
http://www.soundclick.com/bands/default.cfm?bandID=789610

 

[Dave Peterson]

This looks like a perfect opportunity to learn about pivottables.

You can a row of headers (if you don't have them).
Then select the range (A1:Bxx), you don't need that last column if it's always
1.

Then (in xl2003 menus):
Data|Pivottable
follow the wizard until you get to a dialog with Layout on it.
Click that Layout button
Drag the header for Name into the row field.
Drag the header for Activity into the column field.
Then drag the header for Activity (a second time!) into the Data field).

Then finish up the wizard.


If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[jtees4]

This looks like a perfect opportunity to learn about pivottables.

You can a row of headers (if you don't have them).
Then select the range (A1:Bxx), you don't need that last column if it's always
1.

Then (in xl2003 menus):
Data|Pivottable
follow the wizard until you get to a dialog with Layout on it.
Click that Layout button
Drag the header for Name into the row field.
Drag the header for Activity into the column field.
Then drag the header for Activity (a second time!) into the Data field).

Then finish up the wizard.


If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

Thanks. It may be a little over my head but I will giver it a try as
soon as I have a little time. Thank you.

Please check out my music....
http://www.soundclick.com/bands/default.cfm?bandID=789610