Home |
Search |
Today's Posts |
#1
|
|||
|
|||
an Excel question
HI, I have a sheet like this:
Tom A 5 Tom A 5 Tom B 5 Jim A 5 Jim B 5 Can you show me how to make it to : Tom A 10 Tom B 5 Jim A 5 Jim B 5 Thank you |
#2
|
|||
|
|||
Yes.
Use a Pivot table. Your highlight the columns you want to analyze and pull-down Data Pivot Table and use the wizard -- Gary''s Student "Tom" wrote: HI, I have a sheet like this: Tom A 5 Tom A 5 Tom B 5 Jim A 5 Jim B 5 Can you show me how to make it to : Tom A 10 Tom B 5 Jim A 5 Jim B 5 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
Excel Question....Help !!!! | Excel Discussion (Misc queries) | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |