Help with a Formula to turn various words into numbers

July 25th, 2012 - 06:36 pm ET by College_Guru | Report spam
Hello ExcelBanter Experts,

I'm soliciting help for a project. I have a column row with city name
in them, I'd like to write a conditional formula that will convert thos
names into several different numeric values that we can use to evaluat
them. problem is I have a LOT of cities and I need a great big formul
to do. Any thoughts on how I can set this up?? I'm using Excel 2007
Thanks in advance


College_Guru
email Follow the discussionReplies 7 repliesReplies Make a reply

Replies

#1 College_Guru
July 26th, 2012 - 02:13 pm ET | Report spam
Spencer101;1604022 Wrote:
Can you provide an example of some data and an explanation of how yo
assign any given numeric value to a specific city?



Basically we have a column of cities EX.
Seattle
Atlanta
San Francisco
Everett
Portland

What I want to do is have another column display a corresponding numeri
value for that city. These values will correspond to geographi
territories for our systems. Ex. Seattle = 1, Atlanta=3 and so forth


College_Guru

Similar topics