+ Reply to Thread
Results 1 to 8 of 8

Name the Cell based on Numbers

  1. 02-24-2018, 02:57 AM #1
    anwitha
    anwitha is offline
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Name the Cell based on Numbers

    Hello,

    I have a list of emp numbers from 1 to 20000 in Column A. and i need to classify the numbers based on Emp no. Please find the below criteria and help me to get this through formula.

    Emp no. 1 to 5000 should be come as "India"

    Emp no. 5001 to 10000 should be come as "USA"

    and

    Emp no. 10001 to 2000 should be come as "Others".
    Last edited by anwitha; 02-24-2018 at 02:58 AM. Reason: change
    Reply With QuoteRegister To Reply
  2. 02-24-2018, 03:04 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: Name the Cell based on Numbers

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and copy down.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-24-2018, 03:19 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Name the Cell based on Numbers

    or try below and copy towards down
    =Lookup(A2,{1,5001,10001},{"India","USA","Others"})
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 02-24-2018, 03:38 AM #4
    anwitha
    anwitha is offline
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Name the Cell based on Numbers

    Both formulas are working. Thanks a lot for ur help, however i need one more with the similar above requirement. Please see the below criteria
    Here emp no.range is 1 to 1200000
    Emp No. from 550000 to 559999 should come as "USA"
    Emp No. from 820000 to 999999 should come as "India"
    and remaining should come as "others" please help.....Thanks in advance...
    Reply With QuoteRegister To Reply
  5. 02-24-2018, 05:14 AM #5
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Name the Cell based on Numbers

    =Lookup(A2,{1,550000,560000,820000,1000000},{"","India","","USA",""})
    Reply With QuoteRegister To Reply
  6. 02-24-2018, 07:00 AM #6
    ariful.rbg
    ariful.rbg is offline
    Registered User
    Join Date
    11-25-2015
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    MS Office 2013
    Posts
    25

    Re: Name the Cell based on Numbers

    Try this one----

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 02-25-2018, 12:54 PM #7
    anwitha
    anwitha is offline
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Name the Cell based on Numbers

    Thanks guys..this is what i was looking for...both formulas are working...
    Reply With QuoteRegister To Reply
  8. 02-25-2018, 12:55 PM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,476

    Re: Name the Cell based on Numbers

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Format cell colors based on another cell values with positive and negative numbers
    By rlowry in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-30-2017, 12:10 PM
  2. return numbers in a cell based upon words count in a cell
    By shtuamouth in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-19-2016, 02:19 PM
  3. [SOLVED] Highlight cell based on total quantity value based on repeated order numbers
    By PWilson0727 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 02:02 PM
  4. Detect numbers in a cell range and then change cells based on what numbers are found
    By scum in forum Excel General
    Replies: 7
    Last Post: 02-27-2014, 10:56 PM
  5. Sum numbers in a cell based on the dropdown from another
    By kwall2011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2013, 12:53 PM
  6. Sum up a row of numbers based on another cell
    By haynest in forum Excel General
    Replies: 11
    Last Post: 11-04-2009, 04:07 PM
  7. [SOLVED] Sum numbers based on the contents of another cell
    By Doreen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-05-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1