EXCEL DATA

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: EXCEL DATA

  1. #1
    New Member
    Join Date
    Aug 2003
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default EXCEL DATA

     
    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

  2. #2
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,482
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jeanie,

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

    HTH

    Alan
    HTH

    Alan

    --------------------------------------------------------
    Vlookup not sufficient? Follow the link for latest version of FuzzyVLookup or RuleLookup .
    Alternatively to compare two worksheets try Compare Two Sheets
    --------------------------------------------------------
    There are 10 kinds of people - those who understand binary and those who don't

  3. #3
    New Member
    Join Date
    Aug 2003
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL DATA

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL DATA

    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.
    ni****h desai
    Mindful act is consecration only road to salvation.

  5. #5
    Board Regular
    Join Date
    Jul 2003
    Location
    Manchester (UK)
    Posts
    4,482
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL DATA

      
    Quote Originally Posted by 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
    What is your criteria for assigning the letter to the county? Would a VLOOKUP do it?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com