Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
grouping same rows in report
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Rows | Excel Worksheet Functions | |||
grouping rows... | New Users to Excel | |||
grouping rows | Excel Programming | |||
Grouping Rows | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Programming |