EXCEL DATA

[J WILKS]

I have a column in a worksheet that contains different Counties. I want to assign each County a different letter eg A, B, C, D - Some Counties will have the same letter assigned eg Lake = A and Geauga = A. Can anyone help me with this?

Thanks

Jeanie

 

[al_b_cnu]

Hi Jeanie,

not sure what you want herte, can you give more info, possibly an e.g.

HTH

Alan

 

[J WILKS]

For example - column K1:K4555 will have counties listed in them such as Stark, Washington, Ashtabula, Geauga. I need to set these up to match a letter eg. Stark would be an A, Washington would be a C and Geauga may be an A. I hope you understand I need to break down the counties in areas and the area name will be A, B, C etc.

Jeanie

 

[nisht]

why dont you give first letter to all the country by..

=left(a1,1) and then copy this formula to all the cell just by using autofilter handler.

 

[al_b_cnu]

For example - column K1:K4555 will have counties listed in them such as Stark, Washington, Ashtabula, Geauga. I need to set these up to match a letter eg. Stark would be an A, Washington would be a C and Geauga may be an A. I hope you understand I need to break down the counties in areas and the area name will be A, B, C etc.

Jeanie

What is your criteria for assigning the letter to the county? Would a VLOOKUP do it?