JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Sort Cells and sums cell values based on Identical Values
<P>This may be a Noob question, but i am not too familiar with sorting data.</P
<P> </P>
<P>I have and excel worksheet with 12 columns of data i want to sort the data based on the first column, and then based on the data in the second column, I want to sum the 3rd through 12th columns, but only on the ones with the same 2nd column values.
<P> </P>
<P>I can send the sheet if this is confusing.</P>
Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Maybe not a sheet bur a layout of your data will be useful.
<TABLE style="WIDTH: 677pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=906 border=0 x:str><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=10 width=75><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 56pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=75 height=21>RUN # HEAT-LOT PRIME PRM FTG C/O CO FTG MRJ MRJ FTG SCRAP SCP FTG GRIND GND FTG A590 12345-78 4 180 3 16 4 180 2 90 1 45 A590 12345-97 2 90 B478 54321-78 15 450 1 5 1 2 A619 55577-12 67 1000 B478 54321-78 45 50
Simply sort your data using Run no and then heat lot
Yes, but how do i get VB to do this for me? I need it automated as this sheet will be hidden.
UPDATE: I was able to do this using the VLOOKUP function
Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke
<P>This may be a Noob question, but i am not too familiar with sorting data.</P
