Results 1 to 15 of 15

Categorize combinations of numbers-Lowest Median Highest

Threaded View

  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