Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |