+ Reply to Thread
Results 1 to 2 of 2

Promote/Demote Values

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Augusta, GA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Promote/Demote Values

    I'd like to see if this is possible without macros/vba, but I'm not even sure I would know where to start.

    I've got a spreadsheet with a roster of names in col A and a priority number value in col b. I want to not only ensure a unique value in B, but automatically lower all of the other values in B if I enter a lower number. I'm using this to create a list to identify priority.
    for example, my current table looks like this:

    Smith 5
    Jones 2
    Williams 4
    Doe 3
    Johnson 1

    What I want, is if I add a new entry and give him priority 1, that is drops Johnson to 2, Jones to 3, Doe to 4, etc. I'd like to do this automatically when the lower priority number is entered, not on open or on a button click or anything.

    My first thought was to use drop-down lists for the priority and somehow (either formula or programatically) determine the non-unique value and change the rest of the fields. Any idea how this could work, either formulas or VBA?

    Thanks!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Promote/Demote Values

    Hi SuperJew,

    welcome to the forum.

    I believe this can be achieved only through VBA.. because you wish to change the value in their place only.
    Also I am not clear about this part " determine the non-unique value and change the rest of the fields.".. please explain. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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