help with subtotal

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
600
Office Version
2010
Platform
Windows
I created the file below using subtotal from Excel 2003. To format file, I clicked on no 2 in the top left hand corner of the work area. Excel seems to displays only column A (staff No) and column C (Amt). How can I display what's in column 2 (Name).

Staff No Name Amt
53 Total 7,399.35
34 Total 5,851.20
408 Total 5,468.00
32 Total 1,799.20
343 Total 4,716.40
45 Total 2,917.20
80 Total 2,212.00
59 Total 2,200.00
61 Total 2,706.00
82 Total 946.00
79 Total 4,680.00
90 Total 1,970.40
66 Total 4,782.80
47 Total 2,953.02
46 Total 6,571.20
88 Total 3,894.80
97 Total 6,760.00
77 Total 2,865.20
Grand Total 70,692.77

Thank you.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
600
Office Version
2010
Platform
Windows
It looks like I just got buried. Could you help me with this. Thank you.

Sean
 

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
600
Office Version
2010
Platform
Windows
Could someone provide a solution to this question please.


Sean
 

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
600
Office Version
2010
Platform
Windows

ADVERTISEMENT

Thank you rallcorn. Clicking "3" shows all duplicate data which is not necessary. No. "2" format shows sub totals but Excel displays only column A (staff No) and column C (Amt). Is it possible to display columns A, B, C without showing all data?

I tried using SUMIF($A$2:$A$29,A2,$C$2:$C$29), but duplicate totals shows up.

Staff No Name Amt
53 a 3,745.35 7399.35
53 a 3,654.00 7399.35
34 b 2,925.60 5851.2
34 b 2,925.60 5851.2
408 c 2,734.00 5468
408 c 2,734.00 5468
32 d 1,799.20 1799.2
343 g 1,799.20 4716.4
343 g 2,917.20 4716.4

Could someone help.

Sean
 

Sean15

Well-known Member
Joined
Jun 25, 2005
Messages
600
Office Version
2010
Platform
Windows
Pivot table works elegantly. Thank you.

Sean
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,368
Messages
5,510,892
Members
408,817
Latest member
jarlej

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top