Help with formul-easy for you guys I think.

  • Thread starter Thread starter jtees4
  • Start date Start date
J

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
 
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
 
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
Click to expand...

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
 
Back
Top