| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 columns with duplicate names and total numbers
I have 2 columns, one with duplicate names and another with different totals
numbers. How can I get the total numbers for the one name. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 columns with duplicate names and total numbers
Hi
You could use a pivot table. Really easy and superb!! Here is an intro: http://peltiertech.com/Excel/Pivots/pivottables.htm Hope this helps. Andy. "Ana" wrote in message ... I have 2 columns, one with duplicate names and another with different totals numbers. How can I get the total numbers for the one name. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 columns with duplicate names and total numbers
Andy, I heard about Pivot Tables but never tried them, it worked wonderful,
you are great, Thank you. "Andy" wrote: Hi You could use a pivot table. Really easy and superb!! Here is an intro: http://peltiertech.com/Excel/Pivots/pivottables.htm Hope this helps. Andy. "Ana" wrote in message ... I have 2 columns, one with duplicate names and another with different totals numbers. How can I get the total numbers for the one name. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2 columns with duplicate names and total numbers
Thanks for the feedback! I guessed you'd like it!!
Andy. "Ana" wrote in message ... Andy, I heard about Pivot Tables but never tried them, it worked wonderful, you are great, Thank you. "Andy" wrote: Hi You could use a pivot table. Really easy and superb!! Here is an intro: http://peltiertech.com/Excel/Pivots/pivottables.htm Hope this helps. Andy. "Ana" wrote in message ... I have 2 columns, one with duplicate names and another with different totals numbers. How can I get the total numbers for the one name. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) | |||
| Using names to represent values | New Users to Excel | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| how to change a number to name | Excel Worksheet Functions | |||
Hybrid Mode
