+ Reply to Thread
Results 1 to 7 of 7

Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    California, United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Talking Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    I'm having trouble trying to phrase this question, so I'll show an example first.

    babla 02BL3ZZ
    babla 02BM3ZZ
    babla 02T83ZZ
    bccath 02U73JZ
    bccath 02U74JZ
    bccath 4A020N6


    I want to search the entire spreadsheet for instances where just the first 3 characters in column B, show up in different categories in Column A. I would greatly appreciate any help on this. Thanks!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    Do you mean entire spreadsheet?

    Then try using FIND (Ctrl+F) for searching the value. Not sure whether this is what you are looking for.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    Maybe when you use an filter.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Registered User
    Join Date
    10-22-2012
    Location
    California, United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    @ Sixthsense, thank you for responding to my post. I'll try to clarify. I have two columns. Column A is "category". Column B is the "product" number. I'm trying to get Excel to identify and isolate instances where the first 3 numbers of a "product" show up in more than one "category". So say my categories are Red, Blue and Yellow. I'm trying to find when the same 3 characters from a 7 digit number fall into different categories. I need Excel to "zero in" on just the first 3 numbers and come back with the results IF those 3 numbers are in, say for example BOTH the Red and Blue categories.

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    Maybe you mean something like this?

    See the attached file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-22-2012
    Location
    California, United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    @ Oeldere, thank you as well for replying to my question. This isn't quite what I'm looking for, and I apologize for being unable to explain properly. I have a list of 5,000 or so product numbers. They are seven digits long. These product numbers have categories assigned to them. I am not trying to identify duplicate numbers within a category. Instead, I am trying to find ONLY when the first 3 digits of a number are in different categories. So if a number is 02B63ZZ. I want to find out if there are any numbers that start with "02B" in more than one category.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Identify Part of Serial Number and Check to See if it Exists in Two or More Categories

    With helpcells and sorting of pivot table i come to this result.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1