Number categorisation help please....

**EtienneP** · 06-18-2012, 03:18 AM

I would like to ask someones help with something here, so if you can help it would be great

Attached is a spreadsheet, containing a bunch of cellphone numbers supplied to us, now I need to categorise these numbers according to the numbers in the mobile number. The reason for this is that we can sell premium numbers at a higher price than normal numbers and the people here go crazy for a "good" number.

The first tab contain the "levels" and how the mobile number must be structured in order to fit into a level, the next tab contains some mobile numbers. Now I need to have a category next to each mobile number.

Does this make sense?

Please can someone help me?

Thanks!!
Etienne

**Søren Larsen** · 06-18-2012, 01:52 PM

Well, I think I understand what you want to accomplish, but I don't understand what the letters on the "Category" sheet represent.

**jeffreybrown** · 06-18-2012, 01:53 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**shg** · 06-18-2012, 02:51 PM

Not much metal in them thar hills:

       ---A---- ---B---- ---C---- ---D----
  10    Number  Pattern  Category   Name  
  11   77777302 AAAAABCD    7     Gold    
  12   77054222 AABCDEEE    12    Mercury 
  13   77057444 AABCADDD    12    Mercury 
  14   77069555 AABCDEEE    12    Mercury 
  15   77089222 AABCDEEE    12    Mercury 
  16   77287444 AABCADDD    12    Mercury 
  17   77406333 AABCDEEE    12    Mercury 
  18   77412555 AABCDEEE    12    Mercury 
  19   77453222 AABCDEEE    12    Mercury 
  20   77586999 AABCDEEE    12    Mercury 
  21   77587222 AABCADDD    12    Mercury 
  22   77680444 AABCDEEE    12    Mercury 
  23   77697444 AABCADDD    12    Mercury 
  24   77802333 AABCDEEE    12    Mercury 
  25   77813555 AABCDEEE    12    Mercury 
  26   77827111 AABCADDD    12    Mercury 
  27   77854999 AABCDEEE    12    Mercury 
  28   77916555 AABCDEEE    12    Mercury 
  29   77946222 AABCDEEE    12    Mercury 
  30   77947222 AABCADDD    12    Mercury

Fix your thread title and I'll post the workbook.