lists

Hi all, I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it. I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture: But then, when I change the value in the first list...

Hi I have a sheet called 2017-2018 I have a cell formula that works: =SUMIF('2017-2018'!I:I,'Income & Expenditure'!B3,'2017-2018'!F:F) What I want to do is have several sheets with yea periods; 2017-2018, 2018-2019 etc In my Income & Expenditure sheet I want a drop down cell say A1, that...

I have two lists of numbers: long lists of about 1000 each in cols Aand B. If I enter a new number into cell D1 and run vba code I should like to output in cells E1 and F1 an entry from each of Cols A and B whose sum equals the new number. If there is more than one possible solution then other...

I am creating a bid estimating sheet. It is derived from a pricing sheet from a supplier. The estimater, will pick the materials (B1,B9,B13,B), " SS304X4, Galv, Cold Rolled, Tube" from a list. The selection will generate another list from gauges or diameter available per product. For each...

I'm using this code to filter a list on ws2 based on lists on ws1. I have 10 lists each with different variables. I want to be able to put a validation list in a cell on ws2 with the names of each list on ws1. This input would then be used to define "Ary" below. Is this just a matter of...

Hi, Any ideas how to get around this problem … I have 2 lists ofnames. One list is First Name and Last Name, the other list is Title First NameLast Name. I want to identify who is on both lists as best I can. Any ideas how to do this in excel? I appreciate there maynot be a 100% accurate...

Greetings all, I would like to get some advice on the following First I Input two values at cells B2(time) and B3(wavelength) The two values would than be matched against two columns to return a third and recorded in cell L2. In the example below, B2=1, B3=3. The values in column I and J would...

I'm trying to build an interface that will allow others to select a specific product that will then give a subset of that specific lot. For instance my first list would be something like: Product Type Inventory Apple Red 2 Pickle Sweet 1 Orange...

Good Afternoon, I have a lot of data and I'm trying to sort it all using drop down lists. I want to be able to use 3 drop down lists and the data narrows as the drop down lists are selected. For example: I would pick the date in the first drop down and the second drop down would narrow the...

Hey all, Hoping I can get some help here. I created a generic calendar with year (c3) and month input (c4). In each row and column there is another drop down for manger (starting with b10) and to the right (in c10) is a list dependent on b10. This goes all the way through the calendar...

Hello, I'm having a difficult time figuring out the best way to approach a problem and I was hoping someone could help. I'm trying to return a value based on two drop down lists. I've created 3 tables that contain the data that I want returned depending on the first drop down by creating the...

Hi All, I'm racking my brains for a good solution to a seemingly simple problem. I have two lists of names, one is last, first, and the other is first last. My problem is that the lists are not consistent. Some of the Last,First have spaces between in the middle, some do not. Some on my...

I have a table that is laid out with date as the Row heading and then several optional columns and then several required columns. I need to dynamically link it to a table that is better laid out for data analysis. Data comes in as: Book1IJKLMNOPQRSTUV1Optional 1Optional 2Optional 3Optional...

I have a list of names that I need to know if those names are in a larger list. The large list has the names in the string, I need to use conditional format to highlight the name in both lists. I am using, =SUMPRODUCT(--ISNUMBER(SEARCH(A1:A25,C1))) Where should I use the wildcard “*”, Thanks,

Hello, I am trying to come up with a formula that will review two lists (A2:A6 and D2:D6), and if any cells in the lists match, then return the value of that match from Column B. There would not be multiple answers to this (Option 1 and Option 2 would not be listed in D2:D6). Example below...

Good morning all, Does anyone know if there is a way to make the data validation lists searchable? I have items in my list that are similar so it would be more efficient if, when I started typing in a search bar, the results would be filtered by my letters. I understand that you can make a...

Hi, I've created 5 drowndown lists, in columns A to E. The possible options of each list is based off of the selection of the list to it's left. I used data validation =INDIRECT(SUBSTITUTE(D2," ","")) to make this work. What I'm trying to achieve is for column F to give me a certain GL that...

I'm having a rather perplexing issue with data validation lists on excel 2010 intermittently disappearing/breaking after a file is saved and reloaded. Every now and again after saving and closing my workbook, one or more variants of my drop-down lists will break. The arrow to select the list is...

H I'm working with Excel 2010 have a lookup table for a report I'm trying to build that looks like this: <tbody> Campaign Channel Cell Sub Cell A #1 A A A #2 B B A #3 C C B #1 A A B #2 B A C #1 A A C #2 A B C #3 C C C #4 D D C #5 E E </tbody> My aim is to make 4 drop...

Is there a way to use a dropdown list to select a second list. I've been searching but can't find anything quite like this, I know that sounds a little weird but here is what I am trying to do: I have Five lists. My first list is a list of supervisors and then 4 seperate lists. Each of...