Help with formul-easy for you guys I think.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jtees4 - 13 Apr 2008 18:42 GMT

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

Reply to this Message

Dave Peterson - 13 Apr 2008 20:04 GMT

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

> 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
[quoted text clipped - 16 lines]
> Please check out my music....
> http://www.soundclick.com/bands/default.cfm?bandID=789610

Signature

Dave Peterson

Reply to this Message

jtees4 - 13 Apr 2008 23:53 GMT

>This looks like a perfect opportunity to learn about pivottables.
>
[quoted text clipped - 50 lines]
>> Please check out my music....
>> http://www.soundclick.com/bands/default.cfm?bandID=789610

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

Reply to this Message

Rate this thread: