Home Menu

Menu


ExcelBanter » Excel Newsgroups » New Users to Excel > Minimizing Rows of with similar data
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
  
Posts: 15
Default Minimizing Rows of with similar data
I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
  
Posts: 913
Default Minimizing Rows of with similar data
On Wed, 9 Dec 2009 08:13:03 -0800, urlocaljeweler
wrote:

I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.


Select columns B and C, then on the Data tab, in the Data Tools group,
click Remove Duplicates.

Hope this helps / Lars-Åke
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
  
Posts: 96
Default Minimizing Rows of with similar data
Assuming the tu10 and tu12 are in a separate column then use DATA-DATA
TOOLS-REMOVE DUPLICATES tool.

Delete col a

"urlocaljeweler" wrote:

I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
  
Posts: 22,906
Default Minimizing Rows of with similar data
Select columns A:C

DataFilter and SortAdvanced.

List Range A:C

Criteria Range B:B

Filter in place and checkmark "unique records"

If you don't have a title row, you will see two "TU10"'s


Gord Dibben MS Excel MVP


On Wed, 9 Dec 2009 08:13:03 -0800, urlocaljeweler
wrote:

I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
Formula for formatting rows and columns minimizing the outcome. urlocaljeweler Excel Discussion (Misc queries) 1 December 9th 09 05:24 PM
combine rows with similar data, but different fields in excel Herbert Seidenberg Excel Discussion (Misc queries) 0 February 25th 09 08:26 PM
remove rows in one sheet from similar rows in another G[_2_] Excel Worksheet Functions 0 November 12th 07 03:57 PM
Combining rows with similar data robertlewis Excel Discussion (Misc queries) 4 January 27th 07 06:19 PM
How do I compare similar rows of data in same worksheet JT Excel Worksheet Functions 2 February 20th 05 06:11 PM


All times are GMT +1. The time now is 08:07 AM.

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

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement