Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Corresponding Values
Every time a specific value appears in Column A, I need to group the
corresponding values in Columns B,C, and D. For example, with the following data: Arizona Phoenix 28 12 Nevada Reno 36 17 Arizona Tucson 39 43 Texas Houston 16 29 Montana Helena 34 66 I need to group every occurance of Arizona and the info to its right on a selected couple of rows. I need to disregard everything else. My solution should be: Arizona Phoenix 28 12 Arizona Tucson 39 43 Help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping | Excel Discussion (Misc queries) | |||
Grouping Cell Values Together | Excel Discussion (Misc queries) | |||
Grouping | Excel Worksheet Functions | |||
Grouping | Excel Discussion (Misc queries) | |||
grouping | New Users to Excel |