Results 1 to 4 of 4

Biggest in list and matching

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2011
    Location
    Mobile, AL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile Biggest in list and matching

    I actually have two questions I would appreciate any help I can get with. I am working on a excel spreadsheet for my volunteer organization. The purpose is to be a survey of different personal traits in different categories that then are used to suggest possible jobs within the organization that the individual may be specially gifted in doing.
    Here are my problems:
    1. I have been able to figure out how to display the top 3 values, from scores related to traits. However, if two traits get the same score, I only get the name of one displayed. How can I get it to display both.

    2. How do I get the spreadsheet to match and then display a set of jobs that match the top traits. I have a top three trait list that I want match up against a trait list for each job then have the spreadsheet display the job name and description in order of best match.

    I have included a sample spreadsheet with my problems as a example.

    I appreciate any help anyone can give me with this. Thanks so much.
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1