LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu JBird11002 Excel Discussion (Misc queries) 4 August 15th 08 06:31 PM
How do I change the column heading in Excel to display "A" "B" "C Thai New Users to Excel 1 November 30th 07 08:06 PM
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" Dennis Excel Discussion (Misc queries) 0 July 17th 06 02:38 PM
List "OPEN" orders based on a status column beechum1 Excel Worksheet Functions 2 February 13th 06 12:12 PM
"Cumulative" column based on a pivot table sum column? Robert Day Excel Worksheet Functions 2 December 15th 05 09:20 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"