Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 29th 06, 05:37 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default How do I group alpha numeric data in excel?

sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain approx.
15 columns and 30,000 rows of data. The data I am particularly interested in
contains product codes. At the end of every alpha numeric code is a package
type descriptor. I need to have the ablility to select only the data
contianing the bulk descriptor. The codes look like: 98GN45-88, 95C989-8855,
4578Q8-49. Our bulk descriptor is the 88. I have tried numerous ways to have
the lists select only the bulk data with no success. I am think about
creating a custom filter using all the bulk codes, of which there are
probably 50. I'm not even sure that is possible or will work. Is there a
simple solution?

  #2   Report Post  
Old September 29th 06, 06:13 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,688
Default How do I group alpha numeric data in excel?

AutoFilter should work.

Select Custom
Contains 88

Biff

"SlickOilSales" wrote in message
...
sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain
approx.
15 columns and 30,000 rows of data. The data I am particularly interested
in
contains product codes. At the end of every alpha numeric code is a
package
type descriptor. I need to have the ablility to select only the data
contianing the bulk descriptor. The codes look like: 98GN45-88,
95C989-8855,
4578Q8-49. Our bulk descriptor is the 88. I have tried numerous ways to
have
the lists select only the bulk data with no success. I am think about
creating a custom filter using all the bulk codes, of which there are
probably 50. I'm not even sure that is possible or will work. Is there a
simple solution?



  #3   Report Post  
Old September 29th 06, 08:42 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 618
Default How do I group alpha numeric data in excel?

But that would include cells with 88 in the middle of the number, including
in the part prior to the hyphen. Where does the 88 have to occur to satisfy
the OP's criterion? Does -8855 count? If not, and only -88 at the end
counts, then you may want to choose "ends with -88". If your bulk 88 can
occur anywhere within the part after the hyphen, the the easiest option
might be Data/ Text to Columns, using the hyphen as a delimiter, & then use
Biff's "contains 88" filter criterion on the second column.
--
David Biddulph

"Biff" wrote in message
...
AutoFilter should work.

Select Custom
Contains 88

Biff


"SlickOilSales" wrote in message
...
sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain
approx.
15 columns and 30,000 rows of data. The data I am particularly interested
in
contains product codes. At the end of every alpha numeric code is a
package
type descriptor. I need to have the ablility to select only the data
contianing the bulk descriptor. The codes look like: 98GN45-88,
95C989-8855,
4578Q8-49. Our bulk descriptor is the 88. I have tried numerous ways to
have
the lists select only the bulk data with no success. I am think about
creating a custom filter using all the bulk codes, of which there are
probably 50. I'm not even sure that is possible or will work. Is there a
simple solution?





  #4   Report Post  
Old October 2nd 06, 04:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default How do I group alpha numeric data in excel?

Yes, I used the contains search. (88) I also used the does not contain.
(88*5) And it worked pretty well. I then looked for the select few that had
88 in the code itself and deleted them. Thanks for the help.

"Biff" wrote:

AutoFilter should work.

Select Custom
Contains 88

Biff

"SlickOilSales" wrote in message
...
sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain
approx.
15 columns and 30,000 rows of data. The data I am particularly interested
in
contains product codes. At the end of every alpha numeric code is a
package
type descriptor. I need to have the ablility to select only the data
contianing the bulk descriptor. The codes look like: 98GN45-88,
95C989-8855,
4578Q8-49. Our bulk descriptor is the 88. I have tried numerous ways to
have
the lists select only the bulk data with no success. I am think about
creating a custom filter using all the bulk codes, of which there are
probably 50. I'm not even sure that is possible or will work. Is there a
simple solution?




  #5   Report Post  
Old October 3rd 06, 02:32 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,688
Default How do I group alpha numeric data in excel?

You're welcome. Thanks for the feedback!

Biff

"SlickOilSales" wrote in message
news
Yes, I used the contains search. (88) I also used the does not contain.
(88*5) And it worked pretty well. I then looked for the select few that
had
88 in the code itself and deleted them. Thanks for the help.

"Biff" wrote:

AutoFilter should work.

Select Custom
Contains 88

Biff

"SlickOilSales" wrote in
message
...
sI have been tasked with taking customer data and reviewing the minimum
threshold for all of our bulk oil products. The spreadsheet contain
approx.
15 columns and 30,000 rows of data. The data I am particularly
interested
in
contains product codes. At the end of every alpha numeric code is a
package
type descriptor. I need to have the ablility to select only the data
contianing the bulk descriptor. The codes look like: 98GN45-88,
95C989-8855,
4578Q8-49. Our bulk descriptor is the 88. I have tried numerous ways to
have
the lists select only the bulk data with no success. I am think about
creating a custom filter using all the bulk codes, of which there are
probably 50. I'm not even sure that is possible or will work. Is there
a
simple solution?








Reply
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
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Alpha & Numeric Counts in Excel Programmer wanna be Excel Discussion (Misc queries) 3 April 5th 05 11:12 AM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 04:17 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017