LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 66
Default Consolidating Data

I have a 12,000 row spreadsheet that contain sales tax received by various
businesses. One particular business may have 2 records or 20 records. Also,
there are two types of sales tax which are all in the same field

COMPANY NAME TAX TYPE AMOUNT
X 1 3.00
X 2 4.00
X 2 1.00
Y 1 5.00
Y 2 4.00
How can I summarize this data where I can see what the totals are for each
business for each tax type (preferably where the sum each tax type is in a
separate field)
--
Gator
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging/Consolidating data? PeterC Excel Discussion (Misc queries) 2 June 26th 07 09:52 AM
Consolidating a Row of data from many worksheets xlsuser42 Excel Worksheet Functions 0 August 22nd 06 02:28 PM
need help in consolidating multiple data dromayn Excel Discussion (Misc queries) 0 December 6th 05 10:43 PM
Consolidating data?? Louise Excel Worksheet Functions 2 November 8th 05 01:40 PM
Pivottable - consolidating data - winwinweb Excel Worksheet Functions 1 February 15th 05 01:18 AM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"