Help! Trying to consolidate...

  • Thread starter Thread starter Szuja
  • Start date Start date
S

Szuja

Okay, I have a spreadsheet with 52000 rows and 4 columns. In the first
column, the same value is often listed. Example...

No. Qty
302 18 0.87 15.66
302 5 0.87 4.35
302 10 0.87 8.7
303 11 0.7962 8.7582
303 20 0.7962 15.924
303 22 0.7962 17.5164
303 29 0.7962 23.0898
303 86 0.7962 68.4732


What I want to do is combine the No. and Qty columns, so that I only
have one cell "303" but totalling the quanities listed. Can someone
help? Have I made any sense? :) Thanks in advance -
 
Some problems...

There is too much data for a PivotTable, and when I try to use
Subtotals it gives me some bizarre message about "can't shift nonblank
cells. Delete cells to right and down from data..."

I'm paring it down to two columns. Occasionally the subtotals appear,
but they fail to SUM the column I want it to. Sometimes a few totals
do show up properly, but only on about half the sheet. In short, it's
wierd.

Any ideas?
 
Are you able to zip and mail out the workbook? Be sure there is no sensitive
data in it if so. I'll happily take a quick look at it for you and see if I can
help that way. You would need to take the nospam bit out of my email address
 
Back
Top