+ Reply to Thread
Results 1 to 3 of 3

Creating a number generator

  1. #1
    Registered User
    Join Date
    01-12-2019
    Location
    Pittsburgh, Pennslyvania
    MS-Off Ver
    Office 365
    Posts
    2

    Exclamation Creating a number generator

    I have a table that converts Raw data values into T-scores. There are 13 different scales going across a row and each scale has their own set of t-values which are organized down each scale column. There is a column of raw values as well. So basically, if I have a raw score of 6 for the "L Scale" I look down the list of raw scores until I get to 6 and go to the t-value that is associated with the "L-Scale." I plugged in all my data into excel; however, I need to know if it is possible for me to create a generator in excel to make this conversion process easier. I want to create a calculator in excel that generates the t-values for me based on the raw values. In other words, i need to create a generator so I can just type in the raw score in the generator for each scale and it calculates what the t-score is so I do not have to use the chart. Is there a way to create this generator in excel based off of my table?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,454

    Re: Creating a number generator

    Hi and welcome.

    Sounds like you need a 2D lookup which can be achieved using INDEX/MATCH/MATCH.

    If you post a sample version of your workbook and show us what your expected output is we can show you how.

    BSB

  3. #3
    Registered User
    Join Date
    01-12-2019
    Location
    Pittsburgh, Pennslyvania
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Creating a number generator

    Thank you so much! I was able to figure it out using your info!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help creating automatic invoice number generator
    By hunting4bison in forum Excel General
    Replies: 6
    Last Post: 06-30-2016, 12:02 PM
  2. Random number generator with x number of duplicates
    By atomichybrid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2016, 05:48 AM
  3. Number Generator
    By Chrisniagara in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 01-10-2010, 02:02 PM
  4. Creating a skewed random number generator?
    By qweasd in forum Excel General
    Replies: 1
    Last Post: 07-20-2009, 11:44 AM
  5. Number Generator
    By kbenstead in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-02-2009, 02:50 PM
  6. creating a work roster generator
    By jjsule2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2008, 05:04 AM
  7. [SOLVED] same number appears in a random number generator
    By Carmel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2006, 07:25 PM

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