+ Reply to Thread
Results 1 to 6 of 6

Select from list then populate nearby cell? Possible?

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    9

    Select from list then populate nearby cell? Possible?

    I am trying to create a rating scale and in it I have a list of criteria. There are 5 items to choose from and I have a drop-down list to select an "X" for criteria that are met. I want the items to be able to be selected and then a score be designated to a nearby box. ALSO, I want the score to only count for one of those items... for instance...

    Cell B64 is Successful TA. Cell C64 would be marked with the X from the drop down. Cell E64 would then convert from a blank to a 3.

    Then say I go down to B65 (Demonstrated Leadership). Cell B65 would be marked with an X from drop down. Cell E65 would remain blank if E64 had 3 in it.

    This would go on for E64 to E68 so that if any of them are given points, the others turn blank automatically.

    Not sure if this is possible, but I know a LOT can be done on Excel. Thanks ahead of time!

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Select from list then populate nearby cell? Possible?

    Post a workbook and explain in context.

  3. #3
    Registered User
    Join Date
    03-26-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Select from list then populate nearby cell? Possible?

    Here is an example workbook.

    The items on the left are the criteria. I would like to be able to select the box next to it (shown with an X) and have the points received cell populate automatically with a 2. BUT, I only want ONE of those criterion to count towards the final score... SO, if more than one cell from Column C is marked, I only want ONE of the cells in column E showing 2 points.

    Does that help?Bonus Points.xlsx

  4. #4
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Select from list then populate nearby cell? Possible?

    I would not use drop-downs in that case, but custom validation.

    In column D, use a data validation with the custom formula

    =D11="X"

    in F2 use a custom data validation with the formula

    =AND(OR(F11=0,F11=2),SUM($F$11:$F$15)<=2)

    Copy both cells down.

  5. #5
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Select from list then populate nearby cell? Possible?

    I am not sure, I am following you correctly. try this in E11, then copy down.

    =IF((COUNTIF(D$11:D11,"x")=1)*(D11="x"),2,"")

    Will give 2, where is first 'X'
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  6. #6
    Registered User
    Join Date
    03-26-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Select from list then populate nearby cell? Possible?

    Sorry, I have been away from the Forum. I am trying your suggestions, but have been unsuccessful. Could you post the workbook again with the suggestions made?

+ Reply to Thread

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