+ Reply to Thread
Results 1 to 2 of 2

Insert multple values into single cell to sort by any value in that cell

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Insert multple values into single cell to sort by any value in that cell

    Hi,

    I am trying to figure out how to insert multiple values into a single cell so that I can later go back and sort by any of those values.

    Basically, I have a spreadsheet with headers Company Name, Region, and Type of Work. Because most companies perform work in multiple regions and perform multiple types of work I need to be able to insert multiple values for each. I also need to be able to sort by the values in order to find a company that does work in the North or South region for example.

    Hopefully this is a more clear example.
    Company Name----------- Region------------Type of Work
    ABC Construction----------North, South, East---Construction, Concrete
    123 Concrete--------------South, East---------Concrete
    Home Builders--------------East----------------Construction

    Say ABC Construction does work in the North, South, and East regions. If I need to sort for a company that does work in the North or South I need ABC Construction to show. The same applies with the Type of Work.

    Is it possible to insert multiple regions into one cell in a single row? And then be able to sort by any of those regions?

    Hope this makes sense.. Please help!

    Thanks.
    Last edited by ClintH; 07-11-2012 at 12:05 PM.

  2. #2
    Registered User
    Join Date
    08-30-2010
    Location
    Here :)
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Insert multple values into single cell to sort by any value in that cell

    U can't sort by partial value in a cell; they would have to be in different columns. Unless there is a VBA code that somebody can provide that will do that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1