# Pick From List

Jul 17, 2007

I am managing a group of sales reps and when they sell a product they receive commissions I am trying to develop something in excel that in cell B5 there will be a drop down that they can choose one of three products (call them A,B,C) then in C5 another drop down will be there w/ two options (new, refurb), then the result will be in D5 depending on the selections. The parameters would be:

Product A new = \$10
B new = \$20
C new = \$30
A refurb = \$5
b refurb = \$15
C refurb = \$25

So if the rep dropped down in cell B5 Product B then dropped down in cell C5 Refurb, the result would appear in D5 and would equal \$15.

## Multi Selection Pick List

Aug 19, 2009

My organization whats to provide other a excell spreadsheet ( see sample attached) with pick list for certain cells. We have successfull completed adding the pick list. HOWEVER, at times we would like the end user to be able to pick multiple choices form the the pick list

In the example - in column c the user can pick from the drop down list
A
B
V
or
W

However we want the end user to be able to select any combination, single choice, multiple choice ect

In this example with the above pick list created

How can the end use pick A and W or A, V and W etc

## How To Pick Lowest 15 Values In A List

Mar 4, 2012

Have column A which is list of names and column E which shows how much each name owes. I want to compile a list of names and amounts owed for the 15 biggest debts (ie. 15 lowest numbers as they are negative values).

## Randomly Pick 1 Set Of Initials From List

Apr 22, 2012

cell a1 is blank
cell a2= "sb"
cell a3= "db"
cell a4 is blank
cell a5= "rm"
cell a6= "kw"

I want to randomly pick 1 set of initials from the 4 listed in the 6 cells and put the result in cell a7.

## Dropdown Menu To Pick Records Out Of List?

Dec 16, 2013

Is it possible on Excel to make a drop down menu which picks records out of a list?

I've a big spreadsheet. Thousands of records. About 100 responsible are listed responsible for them. I've highlighted stuff for them to fix, I'll be emailing it out to them, and they'll need to isolate the dozens of records they are each responsible for.

They are, erm, technologically challenged. I want to keep it simple, put one menu on the screen and say

'Pick your name from the list.'

George W picks himself, and then it lists his records but not anybody else's.

Can Excel do that? (Rather, probably, but where do I start?)

## List Box Of Ranges, Pick One To Activate That Cell

Mar 30, 2007

How can I add multiple cells (ranges) to a listbox, and when the user clicks one, it will activate that cell in excell. I thought about have the list box for the text, and a corresponding array that holds the actual range or address, but I cant get it working.

Long version:
I have a search feature that, when you type a name, it searches through a column and finds the name. Now if there are multiple matches to your string, I want it to add the full name to a listbox, and have the user pick one from the list to activate.

So basically, if I search for the name "john" but theres multiple people with that name ("john doe", "john smith", & "john mazz"), it would add the three to a list box, I would pick one from the list, and it would activate that cell.

I have everything done except that last part. I have it adding multiple matches to the list box, but I cant figure out an easy way to activate the correct cell when double clicking the item in the list. I could have it search again for the selected full name, but there is likely to be a case where one person is entered twice.

## Command Button To Randomly Pick From List Of Names

Aug 17, 2014

I am trying to create a quiz for myself for studying a foreign language. and I am trying to create a command button, so that when clicked, it will randomly pick from a list of names (located in another sheet) and place the name in a desired cell.

## Pick From List Or Combo Box And Return Definition In Cell To The Right..

Jan 18, 2009

In my attachment, I have a worksheet where I need to pick a rating from a combo box or list (Expert, Leading, Applying, Learning, Under Performing). I will be picking this rating 10 different times on this worksheet and the selections will not be the same in all cases so the definition I need won't always be the same.

I would like to return the definition (definitions are detailed on another worksheet, Data Elements) to the cell to the right.

I've tried IF statements but when I make one selection from the combo box, all the combo boxes select the same thing. I've also tried vlookup but can't figure it out and can't find an explanation in layman's terms.

## Macro -open The Look In List” And Stop So I Can Pick A File To Open

Oct 18, 2008

I want to create a macro that will “open the look in list” and stop so I can pick a file to open. I’ve tried to use “record a macro” and “ctrl-o”, but the record a macro won’t stop until I pick a file or cancel the file list. I also tried to use “o” in the short cut key box

## Using "if" And "validation" Together - Pick From One List, Second List Shows Up

Aug 27, 2009

I would like to have a validation table that, when used, provides a second validation table based on the selection made in the first one. My company provides a wide array of services that I would like to divide into categories - the first drop-down would list these categories ("Cleaning", "Repair", etc.), and then have the next column's drop-down only show those services under the "Cleaning", "Repair", etc. categories.

I know how to make validation tables (I have already created the different tables, with each service under its proper category), but I don't know to get Excel to make one list "pop up" after making a selection from another one.

## Pick Up Some Value's From A Table

Oct 6, 2008

I have the next situation:.......

Qmin - is the first smallest value than Q (in this case Qmin=[B5]=0.63)
Qmax - is the first highest value than Q (in this case Qmax=[B6]=0.77)
Hmin - the value attached to Qmin (in this case Hmin=[A5]=0.004)
Hmax - the value attached to Qmax (in this case Hmax=[A6]=0.005)

question: how can i make Qmin,Qmax,Hmin,Hmax to pick up themselfs if I have a given Q=[B12] value????

## Pick Five Numbers

Mar 19, 2009

I have a worksheet that has all the numbers that I picked for the pick 5 lottery, listed from B24:N71. These are 5 different numbers. What I want to do is highlight the cells that equal the 5 numbers that were drawn, which I have located at S5,T5,U5,V5,W5

## Using A Message Box To Pick Someone

Jun 24, 2006

Basically I want a button that once pressed generate a message box that says a persons name. There are 3 names, so the message box should show name 1 1st and then when pressed again show name 2 and you guessed it then name 3!

## Pick Value From By Count Criteria?

Apr 3, 2014

At the moment I have a problem as per example attached, that I need to select values from row and populate respective column based on the following.

1. A top row contains non-negative values

2. Rows below it contain blanks, negative values and positive value.

3. Last column to be populated with a value from the top row if the value in the rows below top row contains the last negative value before the first positive value. There could be blanks between the last negative and the first positive, but I want the last negative to be used as a criteria for selection of corresponding value from top row. I hope my question is clear with the attached example. The column to be populated is FY.

## Trying To Pick Result From A Table

Apr 7, 2014

In short in the attached which is just 5 results (the full workbook has a couple of data tables and if/or's etc., I've stripped all of the workings out for ease) from one of the sims in the workbook, it shows how far each of the 8 teams listed will get.

Basically in the top table (results which I have highlighted green), I am just trying to return the values in column J (highlighted yellow) which I have just inputted in the attached. Basically I then intend to use them as a results cell for a data table (for each team). As you can see from looking at the 5 sets of results in the case of St.Louis Blues it would return, STANLEY, DIVISIONAL, SEMI, WIN, WIN.

I wasn't sure quite how to do this. I thought I could possibly do this with an index and a match (but wasn't quite sure how to express the function).

Results_Test.xlsx

## How To Pick 50 Numbers Randomly

Dec 10, 2013

In sheet1 columnA I have some data from that i want to copy randomly 50 rows to sheet2.

## Formula To Pick Last Value In A Column

Mar 23, 2009

Is there a formula or function that allows me to always select the lowest (not min) actual lowest in a column? For example, I have a formula in A1 and I need it part of it to always reference the bottom of a certain range (i.e. A5.A200).

So one day the lowest would be A7 but a week later it could be A8. I don't want to have to keep changing the formula in A1 to find the lowest value. I will be adding data on a regular basis.

## Pick Nearest Data?

May 18, 2009

If I have a date that is 12 February 2008 I need to pick up data next to 31 January 2008 as that is nearest, however if my date is >15th February 2008 I want to pick up the data in the column next to 29 February 2008......

## Color-pick Eye Dropper

Feb 2, 2010

I am trying to create a front-page, control-panel style user form that among other things would enable the user to recolor certain aspects of the entire workbook based upon an eye-dropper tool that would pick any color from anywhere on screen (inside or outside of excel).
Ideally, I would like it to be a simple button, click on color, and then have a square next to the selection panel that would display this color. So an add-in would be the most viable solution, however, any form of coding that works is good enough for me.

I am currently at the stage of being able to enter a hex value into the form manually, display the color box using that hex-color in the form next to the selection panel, and upon completion of the form, edit which colors I need within the entire workbook.

And I have an external application that will select the hex value of any pixel's color and paste it in the clipboard, so if could figure a way to run the small application upon the button-click, take the value from the clipboard, and then close the application, that would work.

## Pick The Minimum Numbers

Oct 21, 2008

I need a function like a sumif, but rather than adding together numbers, I want it to pick the minimum. For example, if I had a list of prices for various products, I want the formula to go and find the lowest price for a particular product.

## SQL In VBA - Pick Record With Certain String In It

Dec 4, 2012

I'm trying to use VBA to pick records with a certain string in them using the following:

Code:
"SELECT * FROM tblIncidents WHERE tblIncidents.[Detail] LIKE %" & txtSearch.Value & "%"

But it's not working. It says it has a missing operator...

## Pick Up Certain Information Into New Sheet?

May 27, 2013

I have a table of data as below and would like a formula that will pick the number and name only (as in the need bit) - can this be done, they are on 2 seperate sheets.

DATA
Need
Number
Name

[Code]....

## Rand Pick From 4 Pools

Mar 6, 2009

I have been using the RAND and Vlookup functions for the following without success.

I have 4 numeric Pools or Groups;
1. A1:A18 (1-18)
2. B1:B18 (19-36)
3. C1:C17 (37-53)
4. D1:D17 (54-70)

I also have E1:E20 (20 existing Numbers from 1-70)

I want Excel to select at random a total of 20 numbers
and place them in F1:F20.

I will specify a quantity from each of the 4 groups.
Eg.
In cell A20 I enter 4 to obtain 4 numbers from grp 1,
In cell B20 I enter 6 to obtain 6 numbers from grp 2,
In cell C20 I enter 8 to obtain 8 numbers from grp 3,
In cell D20 I enter 2 to obtain 4 numbers from grp 4,

However there must not be any duplicates between
E1:E20 and F1:F20!

## Allow User To Pick Folder

Jun 5, 2006

My VBA code in Excel 2000 copies a worksheet and Saves it. The default path of the file location is held in a cell. The user defines this path through a userform. The userform simply has a text box and the user types in the path. This value is then transferred to the mentioned cell. What I want is for the user to be able to pick a directory from the user form rather than having to type it.

## Pick Name At Random Name From Table

Dec 13, 2007

I have copied and pasted the formula off the ozgrid page using a 3 column table laid out as I believe it should be however I just get the # name? error message what I am not doing right. Please help. I just want to be able to generate a random name from a table of names, eventually I need to amend the formula to encompass a larger table but I can't get the example to work!

This is the page I have got the info from
[url]

I have uploaded the example I am using.

## Pick Random Name From Column

Dec 24, 2007

I've got a list of names in a column in excel, what's the easiest formula to pick a random name from that list? (guess I can use f9 to randomize)

## Pick From Range At Random

Dec 30, 2007

We get several sets of season tickets to various events to be distributed amongst several managers based on the mgr's headcount. So mgr1 may get 20 dates while mgr2 gets 5. All this info is calculated on Sheet1, but the only info that is important for this exercise is the mgr's names and how many dates they get. Available Dates will always be the same as Total Headcount.

Short of writing names on sheets of paper and drawing names from a hat, I would like to automate this process w/ a push of a button.

Sheet1 - this is where the managers are listed and their Headcount is calculated.

B C
10| Mgr1 Mgr2
12| 20 5

Sheet2 - this is where my ticket information is listed and will change based on different events.

A. B. C. D.
1| Date Row Seat Mgr
2| 1/1/08 H. 1-4. Mgr1 (20 times)
3| 1/1/08. I. 1-4. Mgr2 (5 times)

Ideally I would like to place a button on Sheet1 or 2 that would execute a code that looks at the range of Mgr's names and based on their hdct, inserts their name THAT many times in column D of Sheet2 like the above example.

This information should not change once it's assigned or unless the button is pushed again. The number of Mgr's names in the row on Sheet1 will change, but is never be more than 15, so the code must skip over cells that are blank if referencing, for ex. B11:P11.

## Pick The Number Farthest Down In A Column

Mar 17, 2009

The attachment shows a ledger that I am trying to build. My goal is to automatically add the Ledger balance(G) at the end of each day to the Investment cash balance(J) column. Some days there are multiple Ledger transactions, other days there are none. If there were no Ledger transactions on that day I would like to use the last recorded Investment cash balance. (ex. on weekends there will be no transactions)

Note: I want exactly one balance, the ending daily balance, per day on the investment side of the worksheet.

I have struggled with this all afternoon. My goal is to make this as simplistic as possible for two reasons. 1) I am not a master programmer by any means. 2) I want this file to open on any computer the has a MSExcel on it without have to install any addins.

For these reasons I am thinking it would be best to stay away from macros, which I am minimally proficient at creating.

Let me know if you have any good tricks to solve my problem. If macros are the ONLY or absolutely the BEST way to do this, then I guess you can twist my arm an we can go down that avenue.

## Drop Down Menu That Allows To Pick Any Team

Apr 11, 2009

I’m trying to do now is I have a drop down menu that allows me to pick any team that we can face in the season. Once that is chosen what I want to show is the individual stats against that team. Now right now I’m just trying to work out the formula to see if it works.

The formula itself is half working. For some reason some of the selections aren’t showing up like there suppose to do.

## Pick Up Line Items By The Value In One Column

Feb 12, 2014

As per attached file, there are altogether 4 sub-files and 1 master file.

I'll need the code to automatically pick up the top 9 revenue(highlighted in Green) and top 9 EBIT(highlighted in Yellow) by values in Column N from 4 sub-files and paste to the master file.

Attached File : Example file1.xlsxâ€Ž