+ Reply to Thread
Results 1 to 6 of 6

post code on col1 & list of suburbs in col2 - what is the formula

  1. #1
    varun
    Guest

    post code on col1 & list of suburbs in col2 - what is the formula



  2. #2
    Peo Sjoblom
    Guest

    VLOOKUP



  3. #3
    varun
    Guest

    RE: VLOOKUP



    "Peo Sjoblom" wrote:

    Hi Peo
    sorry,it did not
    'll review the question - may be u can give me a formula
    1. row1 -10 contain same post code number
    2. row 1-10 contains names of the various post code
    3.can you please help me with a formula where single post code combines all
    the suburbs in a cell separated by a formula
    4. please note that number of suburbs (text) in a single post code varies
    need ur help
    thanks

    varun

    >
    >


  4. #4
    varun
    Guest

    RE: VLOOKUP



    "Peo Sjoblom" wrote:

    >
    > Sorry Peo should read separated by a comma


  5. #5
    Peo Sjoblom
    Guest

    Re: VLOOKUP

    Sorry, I don't understand your question, same postcode in all rows?

    can you give an example like


    postcode sub
    postcode sub
    postcode sub
    postcode sub
    postcode sub

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "varun" <varun@discussions.microsoft.com> wrote in message
    news:6DA93524-30B0-4E32-9313-291CCE8B4FCD@microsoft.com...
    >
    >
    > "Peo Sjoblom" wrote:
    >
    > Hi Peo
    > sorry,it did not
    > 'll review the question - may be u can give me a formula
    > 1. row1 -10 contain same post code number
    > 2. row 1-10 contains names of the various post code
    > 3.can you please help me with a formula where single post code combines
    > all
    > the suburbs in a cell separated by a formula
    > 4. please note that number of suburbs (text) in a single post code varies
    > need ur help
    > thanks
    >
    > varun
    >
    >>
    >>



  6. #6
    David McRitchie
    Guest

    Re: post code on col1 & list of suburbs in col2 - what is the formula

    what is the original data locations, example. You have to describe
    exactly what you have, and what you want. However you will probably
    find what you need to answer your question in
    http://www.mvps.org/dmcritchie/excel/join.htm
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "varun" <varun@discussions.microsoft.com> wrote in message news:85F53BF1-98CD-4A8E-8FA8-E8725C93C012@microsoft.com...
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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