Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Grouping" based on value in a column
Hey guys, thanks a ton for your help with this. I am by no means an excel
expert, lol, I suck. I have a spreadsheet that looks like this: A B C 1 1: blah1: data 2 1: blah2: data 3 2: apple: data 4 2: banana: data 5 3: orange: data 6 3: cherry: data 7 3: strawberry: data Now, I want to "group", for lack of a better word, rows where the values in column A are the same. The listed is already sorted by column A. What I need is if the values are the same in A, and I dont not need a row, when I DELETE a row, it's "linked" or "grouped" row will be removed. So, if I were to delete row A7 I want row 5 and 6 to also be deleted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Grouping" based on value in a column
A Pivot Table would be perfect for you:
http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan-- -- RyGuy "Fred" wrote: Hey guys, thanks a ton for your help with this. I am by no means an excel expert, lol, I suck. I have a spreadsheet that looks like this: A B C 1 1: blah1: data 2 1: blah2: data 3 2: apple: data 4 2: banana: data 5 3: orange: data 6 3: cherry: data 7 3: strawberry: data Now, I want to "group", for lack of a better word, rows where the values in column A are the same. The listed is already sorted by column A. What I need is if the values are the same in A, and I dont not need a row, when I DELETE a row, it's "linked" or "grouped" row will be removed. So, if I were to delete row A7 I want row 5 and 6 to also be deleted. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Grouping" based on value in a column
Hmm. yeah I saw this post,
http://en.allexperts.com/q/Excel-105...arate-rows.htm, and the second option the guy gives would be perfect, but, I am not sure how to pull it off. Excel is not my thing.. Thanks Ryan. "ryguy7272" wrote: A Pivot Table would be perfect for you: http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan-- -- RyGuy "Fred" wrote: Hey guys, thanks a ton for your help with this. I am by no means an excel expert, lol, I suck. I have a spreadsheet that looks like this: A B C 1 1: blah1: data 2 1: blah2: data 3 2: apple: data 4 2: banana: data 5 3: orange: data 6 3: cherry: data 7 3: strawberry: data Now, I want to "group", for lack of a better word, rows where the values in column A are the same. The listed is already sorted by column A. What I need is if the values are the same in A, and I dont not need a row, when I DELETE a row, it's "linked" or "grouped" row will be removed. So, if I were to delete row A7 I want row 5 and 6 to also be deleted. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Grouping" based on value in a column
Select the range you are working with, then click Data Pivot Table Next
(the range is highlighted) Next Layout (drag the "A" into the space that says "Row" and drag the "B" and "C" into the space that says "Data"). Then hit "OK" and hit "Finish". Also, look into doing this with Access, especially since you say you want to "DELETE a row, it's "linked" or "grouped" row will be removed." Access is great for these kinds of things!! Regards, Ryan-- -- RyGuy "Fred" wrote: Hmm. yeah I saw this post, http://en.allexperts.com/q/Excel-105...arate-rows.htm, and the second option the guy gives would be perfect, but, I am not sure how to pull it off. Excel is not my thing.. Thanks Ryan. "ryguy7272" wrote: A Pivot Table would be perfect for you: http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan-- -- RyGuy "Fred" wrote: Hey guys, thanks a ton for your help with this. I am by no means an excel expert, lol, I suck. I have a spreadsheet that looks like this: A B C 1 1: blah1: data 2 1: blah2: data 3 2: apple: data 4 2: banana: data 5 3: orange: data 6 3: cherry: data 7 3: strawberry: data Now, I want to "group", for lack of a better word, rows where the values in column A are the same. The listed is already sorted by column A. What I need is if the values are the same in A, and I dont not need a row, when I DELETE a row, it's "linked" or "grouped" row will be removed. So, if I were to delete row A7 I want row 5 and 6 to also be deleted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
List "OPEN" orders based on a status column | Excel Worksheet Functions | |||
"Cumulative" column based on a pivot table sum column? | Excel Worksheet Functions |