View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Fred is offline
external usenet poster
 
Posts: 90
Default "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.