Re: How can I combine rows that have a common value in a single cell?

I think the best you can do with built-in feature is Data, Subtotals. Leave
the first two fields as they are (FirstName and Sum) and in the "Add
subtotal to" list select everything from Day1 down. You might want to check
the last check box to get totals after each person's data.

--
Jim
"Kelly" <kcobean@xxxxxxxxxxxxxxxx> wrote in message
news:uQdFLpklIHA.696@xxxxxxxxxxxxxxxxxxxxxxx
is it possible to combine rows that have a common value in a single cell.
See attached spreadsheet.
For example (assuming the first and last name are combined in Column A) can
the contents of rows that have an identical value in Column A be combined
into a single row


.

Relevant Pages

  • RE: Find Text the Insert Sum
    ... after you have performed the search simply set the LastRow variable thus: ... Subtotal instead of Sum. ... Subtotals in the range. ... a Cell that is next to a cell the words Sub Total in it. ...
    (microsoft.public.excel.programming)
  • Re: "not count" certain cells in a SUM function
    ... include other SUBTOTALs. ... You have faked the data and totals ... That said I don't really see the problem with using SUM to address ... > Cell CW41 is particularly onerous as I must subtract out 2 cells. ...
    (microsoft.public.excel.misc)
  • Custom Calculation Problem
    ... I layout A,B and C (in this order with ... The result i wanted would have a sum of all B items with common A's as well ... The custom calculation behaves inconsistently: for some items, ... It works however when i turn on subtotals for field B, ...
    (microsoft.public.excel)
  • Using different summary functions in Data>Subtotal
    ... For some columns I want a Sum, ... You can display subtotals in a list with more than one type of ... I set the summary function to Max, and click the fields I want, then change ... Excel just remembers the last summary function when I click OK. ...
    (microsoft.public.excel.misc)
  • Re: combining like data
    ... collect the duplicates together and sum them. ... top-left (part of the subtotals outcome). ... Select the visible cells (Excel 2003 has a button for it: ...
    (microsoft.public.excel.misc)