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
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
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?
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
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here you go Stock_sample_20150609_1220.xlsx
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!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks