+ Reply to Thread
Results 1 to 6 of 6

Categorizing big amount of data

  1. #1
    Registered User
    Join Date
    06-08-2015
    Location
    Breda, Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Question Categorizing big amount of data

    hey, I have a problem with categorizing a large number of data. I have to categorize 48,000 item and the way I do now, it takes way too long. I type the category manually every time. Does someone have a faster way to to do this, maybe with a code for example?Stock_sample_20150609_1220.xlsx
    Last edited by Xandaa; 06-09-2015 at 06:22 AM. Reason: Completly stuck in progress

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,476

    Re: Categorizing big amount of data

    How do you apply the categories now? Is there a column that you use to determine the category? If so, you could set up a table that lists the unique values in that column and what category applies to each, and then you can use a VLOOKUP formula.

    I don't understand why your post count is zero - clearly, you have made at least one post!!

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-08-2015
    Location
    Breda, Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Re: Categorizing big amount of data

    VLOOKUP-formula would help if i got all category names written down. This i haven't because of the large amount of items.

    by the way what do you mean with post count zero?

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,617

    Re: Categorizing big amount of data

    Hi there... and welcome to the Excel Forum.

    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn



  5. #5
    Registered User
    Join Date
    06-08-2015
    Location
    Breda, Netherlands
    MS-Off Ver
    2013
    Posts
    3

    Re: Categorizing big amount of data


  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,617

    Re: Categorizing big amount of data

    That's quite a list.. There are very few duplicates (309 out of 40,000 or so). I was hoping that there would be some way of extacting categories from the list. However, i don't see any pattern to the entries in column A that coud help. I suspect you have a MASSIVE job on your hands here., unless you can come up with some rules to enable us to pull categories out of the data in column A!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need Help Categorizing Data
    By Vioxtar in forum Excel General
    Replies: 3
    Last Post: 09-25-2014, 05:48 AM
  2. help on categorizing sales data
    By piyushvarade in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-18-2014, 08:30 AM
  3. Categorizing a data set
    By EMWAU in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2014, 08:39 PM
  4. [SOLVED] Help with categorizing my data
    By MaddyT in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 11-23-2013, 07:25 PM
  5. Categorizing and sorting data
    By DA CPA in forum Excel General
    Replies: 7
    Last Post: 07-03-2009, 03:59 PM

Tags for this Thread

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