Thread
:
grouping same rows in report
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
grouping same rows in report
I think the easiest way is to use the built in functions that excel offers.
First, sort your range so that the names are grouped nicely.
Then select that range (A1:V899) and use
Data|Subtotals
You'll be able to specify the name field as the key and even add subtotals
(count or sum or average or...)
If you add data, then remove the subtotals (data|subtotals dialog)
resort (if you need to)
and reapply the data|subtotals
wrote:
I have an Excel report (Header row A1..., data from A2 to V899)
In column A, there are duplicate names each with it's own data.
What I would like to do is first group all these same rows together.
looks like this:
EMPLOYEES.Name
Alejandro-Yarema,Warren
Alexiuk,Leonard Louis
Anctil,Craig William
Anderson,Laura E.
Anderson,Laura E.
Andrews,Janice Rose
Andrews,Janice Rose
Andrews,Jeremy
Antoniak,Michael
Antoniszyn,John
Appleford,John E.
Appleford,John E.
Appleford,John E.
I need to be able to first, get an accurate count of all the rows
(only counting all same names as 1 row) then be able to display rows
grouped together.
Is there an easy way to do this?
thx
Mel
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson