+ Reply to Thread
Results 1 to 2 of 2

Single cell with multiple data points - searching and filtering

  1. #1
    Registered User
    Join Date
    12-05-2018
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    MS 2016
    Posts
    1

    Single cell with multiple data points - searching and filtering

    Hello all, I am a first time user of the forums here, so please let me know if I am doing anything wrong.

    I am stuck trying to figure out the best way to organize student(s) information. In my situation, I want to be able to easily search by 3 different data points (student name, major, and graduation year) and any combination of those three. There can be up to 15 different data points (5 students x 3 data points each) for each cell. What do you believe is the easiest way to setup this data so that I can easily search/sort/and filter (or vlookup maybe?) it for future use? I have attached a screenshot as an example of what the entire spreadsheet will look like, while omitting certain information to avoid identification, of course.

    Master Example Format.png

    As you will see in the photo, column F is where my primary concern is. I separated "Student Name", "MBA", and "2015" (for example, with 3 different qualifiers ("," "-" and ";") thinking the easiest way would be to do a "Text to Columns" to split them into different columns when needed and just hide the columns they would fall into until that point. The problem is, for example, "MBA" would fall into potentially 2+ columns because I have multiple students in 1 cell. That would make counting the number of MBA students who began startups not impossible, but annoying.

    Anyway, if you need anymore information please let me know. Your assistance is greatly appreciated!!!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,013

    Re: Single cell with multiple data points - searching and filtering

    A sample workbook would really help us understand the requirement better. Also people are more likely to jump on if they don't have to recreate the data you already have.

    Looking at the data, it is in a poor format for analysis. You would probably need VBA to unscramble it into a "normalized" format that can be used by formulas and pivot tables. I am not sure if you'll have any takers on that, but chances are better with a sample workbook.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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