Selecting Multiple Items From A List In One Cell.
Feb 10, 2010
Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do -
In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"
View 4 Replies
ADVERTISEMENT
Dec 26, 2013
I am wanting to create a list where I can select multiple items within that list and then print only those selected items. I have created something similar thru data validation, but I can't get it to print.
In addition, I would like to be able to subdivide the list into multiple categories, then select items from these multiple categories and print them.
View 3 Replies
View Related
Apr 1, 2014
I've made a drop down list and when I select multiple cells and choose from the drop down list, it only fills one. Here's pictures:
So in that first picture, I've selected multiple cells. But when I drop down the menu and click my selection, this happens:
Why is it that all the cells I've selected does not fill with the option that I chose from the drop down. I highly doubt that I have to manually click all the ones I want to fill with what I choose from the drop down list.
View 1 Replies
View Related
Jan 17, 2006
I want to do a function similar to a vlookup. I want to input a key
into a cell and have the relevant names listed. The problem I have is
the vlookup only shows one of the multiple names. Is there a way to
list all of the names?
Input Key: ____
KeyName
1414BRODRENE DAHL A/S
1880MAN FERROSTAAL AG
2356HEITON BUCKLEY LIMITED
2356HEITON BUCKLEY LIMITED1
2356HEITON BUCKLEY LIMITED2
2356HEITON BUCKLEY LIMITED3
3867STAVANGER RORHANDEL A/S
4367CLEANAWAY LTD
4618ALUKONIGSTAHL GMBH
4618ALUKONIGSTAHL GMBH1
4979MARMON/KEYSTONE ANBUMA N.V.
Ideal Output
Input Key 2356
HEITON BUCKLEY LIMITED //all brought up by a formula
HEITON BUCKLEY LIMITED1
HEITON BUCKLEY LIMITED2
HEITON BUCKLEY LIMITED3
View 13 Replies
View Related
Apr 2, 2013
In column A i have list with the names like this.
ROSEHILL 1
ROSEHILL 1
ROSEHILL 2
ROSEHILL 2
ROSEHILL 2
ROSEHILL 2
ROSEHILL 3
ROSEHILL 3
ROSEHILL 3
When i use the Vlookup to return the value in column M it does not work as you would expect, i have done some searches and found a few different formulas but can't get any to work, the data i am searching is listed on one sheet and the criteria and the formula is on another.
I tried this formula as an array but no joy.
=IFERROR(INDEX(Data!$A$2:$M$900, SMALL(IF($GO$4=Data!$A$2:$A$900,
ROW(Data!$A$2:$A$900)-ROW(Data!$A$2)+1), ROW(1:1))),"" )
View 4 Replies
View Related
Feb 4, 2014
I have created a DAta Validation List and it only select one item. I want it to select as many items that is on the list but i can't get it to work for my main worksheet I am working on. I can't figure out why I can't get it to work for the work sheet "This Don't" but it works for the worksheet "This Works" why and how I can change it so both Reason (Column F and H can) select mutliple items on there. Data Sheet.xlsx
View 2 Replies
View Related
Jan 8, 2008
I have two worksheets: A and B.
Worksheet A:Contains 2 columns: Issue# (Col. A) and Program (Col. B).
Issue# contains a list of multiple issues. There are several instances in which the issue# is repeated.
Any particular Issue# field may have several issues in it, delimited by a comma.
Program is a program associated with the issue and this column also contains duplicates.
Worksheet B:Contains 1 column: Issue# (Col. A)
This is a unique list of issues#'s.
All Im looking to do is parse all Issue#'s from Worksheet B and have some way of knowing if that issue# is anywhere in Worksheet A. Most importantly, I need the "indicator" to be displayed on Worksheet A. This way I can see what program(s) is/are associated with the matching issues.
A couple other notes:All Issue#'s in Worksheet B are referenced at least once in the Worksheet A Issue# list
There are several issues in Worksheet A which are not referenced in the issue list on worksheet B (of which I dont care about)
I really hope that makes sense, but if not...
Here's the best example I could come up with: ....
View 9 Replies
View Related
Sep 5, 2007
I was wondering if there was a way to create a pop-up list to appear when a user selects a certain cell that would provide the user with a list of (in this particular case) inventory items. The user would select which items they require for the task at hand and the total $$cost of the items would appear in the cell once is is deselected.
View 4 Replies
View Related
Jun 7, 2014
I watched a video on youtbe. And the women had three or four items in drop down box. She was using vba. When i emailed her to ask her how she did this, she kept telling me to go to her website and i was supose to figure it out on my own. I am trying to do a start up construction company. the link to her site is as follows Select Multiple Items from Excel Data Validation List - YouTube the idea of what i want to do, is how she clicks on a word and it follows in the coloumn to the right going down. This is what i need to know how to do. It is probably pretty elementary to many of you. But i build, i know how to read prints, to cut footprints for new homes etc. But when it comes to excel i am so green.
View 2 Replies
View Related
Jun 19, 2013
I'm trying to use a List Box to select multiple items on my Pivot Table but I can't seem to get it to work. Its the Report Filter part of the pivot table.
When the list Box is set to fmMultiSelectSingle it work and selects the indivdual items, but I need it set as fmMultiSelectMulti for if i'm also needed to select multiple items. (which doesn't seem to work!)
View 2 Replies
View Related
Sep 5, 2013
I have attached a sheet with a sample of how my spreadsheet will look. This might involve a number of steps. I have actuals, forecast, and prior year information (for rolling months) for a number of line items. To the right, I calculate a variance (in total and %). What I want to do is create a list to the right (not sure how to format it) that populates the 10 items from the left with the most variance (units, not %). I would like it to populate the line item from the right as well as the number of units for the variance (columns F and H). Lastly, and I'm not sure if this possible, I might want to just select the items that are greyed out. That is, I would want the line items with the most variance but just from the greyed out lines. If this is not possible without a macro, I don't want to do it.
View 2 Replies
View Related
Feb 16, 2012
I'm making a risk chart which i want to select data automaticly.
It currently is possible to select a characteristic. After selecting the characteristic i want the chart to update, having only the risks with that characteristic in it. But it also has to select on impact level and chance%.
Is there any way to let Excel auto select the Risk discription and copy it into the chart?
below are 2 pictures, 1 an example database of risks and an example of how the chart should, more or less, look like when i select the financial characteristic.
View 9 Replies
View Related
Mar 26, 2012
Using Excel 2003
We have a spreadsheet set up showing a list of sales invoices, each invoice has the customer name and a customer reference assigned to it i.e B1, B2 etc
We want to set up another sheet that takes the sales invoice information but only picks up that which relates to a specific customer, i.e want a list of the invoices relating to B1
This will be done with a view to creating statements for each individual customer reference number which will just take info from these sheets B1,B2 etc
View 1 Replies
View Related
Apr 24, 2014
When inserting "1" in the cell under soup, i was thinking it will bring up a list of its ingredients and how much of that ingredient. The values are listed in the same spread sheet below.
The amount of the ingredient is in D50 (80grams) and the item type next to it in E50(onion)
Is it possible to put in "1" soup then it displays all the items in both those cells range example(D50-E50 to D60-E60)?
Is it possible to put the value "2" in soup and it shows double the measurements? example (160grams) (onion)
View 4 Replies
View Related
Dec 27, 2013
So I am creating a board game in excel. I currently have a draw card feature to draw random cards. I also have section above where you can fill in the answer to the question and another 2 sections that flip to correct or incorrect. Those formulas work as =IF(AND(Sheet1!J6="When resubmitting the claim to another insurance should you be voiding an adjustment to the S code if one is posted?",Sheet1!I2="Yes"),"That is Correct!"," "). I have another for if Sheet1!i2="no" then it flips to that is incorrect. I want an OR formula that will be like if multiple cells have any text in them it will display them but only one cell at a time. So essentially a way for multiple questions to be able to be drawn and you can answer those questions and be told if they are correct or not.
View 14 Replies
View Related
Feb 10, 2014
I'm after a bit of programming which selects the same cell on the next sheet that I have already selected.
So, If I'm on Sheet1 and I have G5 selected, when I change Sheets to Sheet3 for example, I want it to select G5 on Sheet3.
View 9 Replies
View Related
Aug 22, 2014
I have a global list in B column and I want to create a text about the list. If I put "1" in A column, I want my text to be on B11 for the selected items. So excel should do a loop for the selected range and combine the selected items in a new line and give me as an output.
You may see the picture Untitled 1.jpg
View 2 Replies
View Related
Jul 12, 2012
I have a worksheet with an inventory of items in cells in column A. I need to count the number of items listed in the cells in column B. I have data in about 1500 rows. The items in the list in each cell are separated with a space. Please see small sample below. I would normally do Text-To-Columns, but some of the cells contain up to 30 items.
Excel 2007
A
B
1
Grouping
Number
2
[code]....
View 3 Replies
View Related
Mar 27, 2014
I need to count the total number of times 4 different values appear in a column. This formula works for one value:
=COUNTIFS(Source!$C:$C,$B5,Source!$J:$J,$L$3,Source!$L:$L,$H$1)
Where H1 contains the word Assigned. I need to also find and add to count for matches in I1,J1 and K1 which contain New, Pending and Work in Progress respectively.
View 6 Replies
View Related
Feb 21, 2009
I want to be able to select a cell, for example A10, this would then run a macro that would copy and paste several cells of information along that row and paste it on another worksheet. However, if i then choose a15, a3, a79 in turn (using the control key), it would run the macro using those rows in turn.
i'm looking forward to hearing if and particuliar how this could be achieved.
View 13 Replies
View Related
Nov 9, 2011
I have a list box, that I have set MultiSelect to "1 - frMultiSelectMulti"
What I would like to be able to do is select multiple items and have those items appear in a single cell on my spreadsheet.
Maybe something like: WA, CA, OR Forms.ListBox.1 is the name of my object. Or do I need to use a different object type?
View 1 Replies
View Related
Jul 17, 2009
I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}
however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.
View 9 Replies
View Related
Jan 24, 2014
I have columns (1-7) containing values of time these columns are labelled G,R,A,S,D,B,T by 850 rows (which are locations/jobs)
The next set of columns (1-7 determins what week the work takes place) so you will get a G in a cell or GR etc.
I would like a formula to work out the sum of the time columns by the code in the corresponding cell - I am stuck!
Seantc example.xlsx
View 7 Replies
View Related
Mar 21, 2014
I'd like to generate a total sum based on the quantity from each item. So columns H3 - N3 should generate a total in P3 (skipped O) by the quantity entered in each cell. In addition I'd like the value of D3 to change the pricing in the formula. D3 has a drop down with 3 products, so selecting ANY of those products should cancel out the previous formula and replace it with another.
This is the sum without a value in D3
=SUM(H3*10.00)+(I3*8.00)+(J3*6.00)+(K3*18.00)+(L3*10.00)+(M3*8.00)+(N3*8.00)
IF D3 has a package selected from the drop down, I'd like this sum to generate instead.
=SUM(H3*8.00)+(I3*6.00)+(J3*4.00)+(K3*15.00)+(L3*8.00)+(M3*6.00)+(N3*6.00)
[code]....
View 3 Replies
View Related
Sep 27, 2013
I'm running a pretty huge database with Part Numbers across several Suppliers which fluctuate constantly.
For example: a HEXAGONAL BOLT may have a Part Number ABC123, but depending on the size of the bolt it could be a ABC123-001 ABC123-V28 ABC123-40mm (etc)
There's a lot of data (some of it sensitive) so I don't want the users to see everything - I'm creating a front-end sheet and am looking for a way for a user to type in the Part Number "ABC123" into cell A1, then the Pivot below to auto-update (with Part Number on the 'Report Filter') to show all variations of ABC123, including ABC123-1 ABC123-2 etc - i.e. not an exact match; everything that contains the characters in cell A1.
The relevant information has been ported in and password protected on a sepearate sheet within the workbook, so it's literally a code to make the cell value affect the filter.
View 1 Replies
View Related
Jan 2, 2014
I want to sum up data for two periods (4&5) from a pivot table using GETPIVOTDATA formula. I've only been successful when I manually type the period values 4 and 5 as is shown below:
=IFERROR((SUM(GETPIVOTDATA("Amount",'Transaction Pivot'!$J$3,"Period",{4,5},"Project",$A7,"Category","T&M"))),0)
However, I cannot get the formula to work when I substitute cell references for the period values 4 and 5. Therefore, the following formula does not work:
=IFERROR((SUM(GETPIVOTDATA("Amount",'Transaction Pivot'!$J$3,"Period",{E5,E6},"Project",$A7,"Category","T&M"))),0) where E5 has 4 in the cell and E6 has 5.
View 3 Replies
View Related
Jun 15, 2007
I'm trying to use data validation to restrict the user to only selecting values in a list which I create. Right now, the list is a named range. I'd like to get rid of the range and just use a named list. I create a name using the following as my list.
Insert > Name > Create
Name: Fruit
Refers to:
banana,apple,orange
When I try to use the name Fruit in my data validation, I get the message "The List Source must be a delimited list, or a reference to single row or column." I thought my name "fruit" was a delimited list.
View 4 Replies
View Related
Jun 5, 2009
i want to do is, have a list that picks from a color and then beside it, it will show the possible fruit that is that color for example
Red
apple
cherry
strawberry
OR
Green
watermelon
grapes
The number of fruit will differ by the color so i know i need a counter there, but i am not sure how to list the fruit after i've picked the color
View 6 Replies
View Related
Apr 11, 2014
It is a product list of office stationary with codes, descriptions and quantities. Using this spreadsheet we input into the quantity how many we want of the item, all well and simple you could call the list a stationary order form.
What I would like to be able to do with this Giant list is to have a function that would extract items off the list into a cleaner consolidated form. As in, if I wanted to order some of item A, C and F, I would like for the second table to just Show ACF without every letter in between or blank cells.
I know a simple method would be to have an IF formula to return the information to a new sheet that I could simply remove blank cell rows (unordered items) and ready for print each time. But I would love to know if there is a better way this could be achieved.
I have basic/intermediate knowledge of excel and can setup the data if need be in order for the function to work, but I can't seem to find the correct function for this project.
View 8 Replies
View Related
Sep 13, 2013
It's a quarterly schedule for utility meter readers, divided up into days across the top, and routes/areas down the side.
There's a space with each route for the employee ID to go, depending on who's doing it.
Down the bottom of the sheet, there's a few empty lines for all the available employees who haven't been allocated to a route.
On the second sheet labelled EMP LIST, is all the employee IDs. It's also got the areas they work- it's for something I want to implement later.
I can put all the employees into a single column list, then use basic DV to give a dropdown menu by each route, to assign an employee to it. This is pretty straight forward. I've also been playing with this in combination with a countif, so that employees already assigned do not appear in the list.
This is about as far as I've managed to get with it.
I need to get the employees who aren't assigned to anything to appear in a list below the routes. I'm fairly sure this is just another countif, but I'm not 100% on the exact formulas.
I also need the list in the dropdown menu to reset for each day of the quarter, i.e. if I assign an employee to a route on the 30th day of the quarter, their ID will disappear from the list for any other route for that day, but will still be there for the other days of the quarter.
So far the only way I've managed to do this is by duplicating the employee list for every day of the quarter, which is going to get very cluttered, and also makes staffing changes difficult. I'm hoping there's an easier way to do this using one data set.
I've added an example of the sheet. It's one week and it's only got about 1/3 of the routes we would actually have on any given day.
scheduledemo.xlsx
View 1 Replies
View Related
