Results 1 to 6 of 6

Formula for multi-column table to determine levels of certification

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    27

    Question Formula for multi-column table to determine levels of certification

    I'm working on a spreadsheet that professionals will use to track their progress in reaching fidelity to practices. There are three levels: no fidelity, approaching fidelity, and fidelity. Within one section, there are three separate characteristics that the professional must exhibit in their practices in order to achieve fidelity. They may do really well in one, but not great in another. I have a table that shows the various stages with each characteristic and how that translates to overall fidelity for that section. I need to know how to use the table to translate their progress on a summary worksheet.

    The example I'm attaching has two worksheets, the summary and the detailed one. There are already formulas embedded to keep cells blank until filled and to calculate individual fidelity status. I just don't know how to use the table to write a formula that takes into consideration 27 different combinations that can result in three different progress levels.

    Thanks for your help!

    L
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-26-2017, 11:48 PM
  2. Convert a mutli colum Multi roy table to a 3 column table
    By stratis63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2015, 11:30 AM
  3. [SOLVED] Creating Single Column List from multi-row/column table and removing blanks
    By ChemistB in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-10-2014, 02:23 PM
  4. Turning 2 row table into a multi-column table
    By kle in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2013, 05:20 PM
  5. Converting a 2-row table into a multi-column table
    By kle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2013, 08:49 PM
  6. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  7. How do I determine Table Column Index Number?
    By sauerj in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2010, 09:25 AM

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