+ Reply to Thread
Results 1 to 2 of 2

Making groups of levels

  1. #1
    Registered User
    Join Date
    04-22-2012
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    1

    Making groups of levels

    Hi, everybody
    i have one excel file containing lot of different digits (example 5,7,10,11,15,16,19,20,23) in one row(a2 to a301). Each number in different cells. Now i want to add another row to same sheet for making group (low level, medium level, high level). The low level is 7 & less than 7, medium level is 7 to 15, high level is 16 & above. For these calculation i want to give three letters for low, medium, high respectively 1,2,3. Can anyone please help me.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Making groups of levels

    You seem to be mixing up the term row and column, and your data seems to be in L2:L301. You can use this formula in T2 (if that's where you want it):

    =IF(L2<=7,"L",IF(L2<=15,"M","H"))

    and copy it down. If you want the numbers 1, 2, 3, then just use these instead of the letters L, M, H respectively.

    Hope this helps.

    Pete

+ Reply to Thread

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