Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting & sub-totaling data on an excel spreadsheet
I have several columns of data that I need to subtotal based on a change in
one of the columns. Example Column A = ELX-1111, Column B = 45 Column A = ELX-1111, Column B = 15 Column A = ELX-2222, Column B = 10 Column A = ELX-5555, Column B = 50 Every time there is a change in the data in Column A, I need a subtotal in Column B. Hope someone can help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting & sub-totaling data on an excel spreadsheet
Yes, use Excel's Subtotal feature. That's what it was designed for. It's
under DataSubtotal. Regards, Fred. "dmills" wrote in message ... I have several columns of data that I need to subtotal based on a change in one of the columns. Example Column A = ELX-1111, Column B = 45 Column A = ELX-1111, Column B = 15 Column A = ELX-2222, Column B = 10 Column A = ELX-5555, Column B = 50 Every time there is a change in the data in Column A, I need a subtotal in Column B. Hope someone can help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting & sub-totaling data on an excel spreadsheet
I've been looking in all the wrong places? Was sure it was a funtion.
Thank you so much! "Fred Smith" wrote: Yes, use Excel's Subtotal feature. That's what it was designed for. It's under DataSubtotal. Regards, Fred. "dmills" wrote in message ... I have several columns of data that I need to subtotal based on a change in one of the columns. Example Column A = ELX-1111, Column B = 45 Column A = ELX-1111, Column B = 15 Column A = ELX-2222, Column B = 10 Column A = ELX-5555, Column B = 50 Every time there is a change in the data in Column A, I need a subtotal in Column B. Hope someone can help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting & sub-totaling data on an excel spreadsheet
A common error, one we've all made. If you think finding things in XL2003 is
difficult, wait until you get to 2007. Glad to help, Fred. "dmills" wrote in message ... I've been looking in all the wrong places? Was sure it was a funtion. Thank you so much! "Fred Smith" wrote: Yes, use Excel's Subtotal feature. That's what it was designed for. It's under DataSubtotal. Regards, Fred. "dmills" wrote in message ... I have several columns of data that I need to subtotal based on a change in one of the columns. Example Column A = ELX-1111, Column B = 45 Column A = ELX-1111, Column B = 15 Column A = ELX-2222, Column B = 10 Column A = ELX-5555, Column B = 50 Every time there is a change in the data in Column A, I need a subtotal in Column B. Hope someone can help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting and sub totaling columns | Excel Discussion (Misc queries) | |||
Sorting data and Advance filtering to get totals on a spreadsheet | Excel Discussion (Misc queries) | |||
totaling & averaging a spreadsheet | Excel Discussion (Misc queries) | |||
Sorting in Excel spreadsheet | Excel Discussion (Misc queries) | |||
Loosing correct hyperlnk location after sorting spreadsheet data | Excel Discussion (Misc queries) |