| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
coding
How do I get excel to group together certain codes. eg. say some things came under the code 34567 and there was a value to that code like £30. how do I get a summary on the sheet to say how much has been spent under code 34567. The code has a deicated column, with different codes in the same column. -- maisy1 ------------------------------------------------------------------------ maisy1's Profile: http://www.excelforum.com/member.php...o&userid=37157 View this thread: http://www.excelforum.com/showthread...hreadid=568786 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
coding
a Pivot table does that.
HTH. Best wishes Harald "maisy1" skrev i melding ... How do I get excel to group together certain codes. eg. say some things came under the code 34567 and there was a value to that code like £30. how do I get a summary on the sheet to say how much has been spent under code 34567. The code has a deicated column, with different codes in the same column. -- maisy1 ------------------------------------------------------------------------ maisy1's Profile: http://www.excelforum.com/member.php...o&userid=37157 View this thread: http://www.excelforum.com/showthread...hreadid=568786 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add horizonal color coding to values | Charts and Charting in Excel | |||
| How to see the chart coding? | Charts and Charting in Excel | |||
| More than 6 conditional Formats....VBA Coding Advise please | New Users to Excel | |||
| User Form Coding | Excel Discussion (Misc queries) | |||
| Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
Hybrid Mode
