Results 1 to 15 of 15

Categorize combinations of numbers-Lowest Median Highest

Threaded View

Sweetypie Categorize combinations of... 03-08-2010, 01:57 PM
darkyam Re: Categorize combinations... 03-08-2010, 02:10 PM
Sweetypie Re: Categorize combinations... 03-08-2010, 03:02 PM
darkyam Re: Categorize combinations... 03-08-2010, 05:00 PM
zbor Re: Categorize combinations... 03-08-2010, 05:12 PM
Sweetypie Re: Categorize combinations... 03-08-2010, 05:21 PM
darkyam Re: Categorize combinations... 03-08-2010, 05:32 PM
Sweetypie Re: Categorize combinations... 03-08-2010, 05:33 PM
Sweetypie Re: Categorize combinations... 03-08-2010, 05:41 PM
darkyam Re: Categorize combinations... 03-08-2010, 05:59 PM
shg Re: Categorize combinations... 03-08-2010, 07:47 PM
Sweetypie Re: Categorize combinations... 03-08-2010, 11:05 PM
zbor Re: Categorize combinations... 03-09-2010, 03:22 AM
DonkeyOte Re: Categorize combinations... 03-09-2010, 04:33 AM
Sweetypie Re: Categorize combinations... 03-09-2010, 10:23 AM
  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    new york, usa
    MS-Off Ver
    Excel 2003
    Posts
    37

    Categorize combinations of numbers-Lowest Median Highest

    I have a list of 3-digit numbers I want to use.
    I want to categorize each number as follows:

    L=Lowest M=Median H=Highest
    E.g.
    The number 123 has the following combinations: 123, 132, 213, 231, 312, 321
    and
    123 = LMH
    132 = LHM
    213 = MLH
    231 = MHL
    312 = HLM
    321 = HML

    A number like 799 would be
    I would like a function in Excel to take any such list of numbers (say in A) and find their LMH etc equivalents in a separate column B.
    Thanks in advance.
    Last edited by Sweetypie; 03-09-2010 at 10:25 AM.

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