lists

Hi Would like to create a sheet that automatically pulls info from two separate tables when they are pasted into a file. To clarify, two different tables are pulled from a system, pasted onto two separate sheets in an Excel file. I then have to add the two lists together onto another sheet...

I want to find out how many of my company's customers are in the Fortune 500. I have both lists, but am not sure how to compare them. Also, how would I handle common words like "the" or "of?" I guess I could do an exact match, but then I might miss close matches, for example, we might have a...

Hello, I am looking for some help with lists or for an answer if this is even possible. I would like to create a "home page"(tab 1) with 3 drop down lists. The tricky part is that I would like list 2 to pre-populate based on the selection in list 1, and then list 3 to populate based on the...

i have a payroll tab which lists all member of staff for a department. I want a formula that will look at this whole list and then list the users employment id's when a criteria is met. so in total i want to produce 3 seperates. i want one that lists all the staff who are down as new sales. i...

Hi! I have a column with over 4,000 data validation lists. All the lists are the same. The problem is, I want my lists to show all 35 items, instead of only 8, so I'm hoping to use combo boxes. Is there any easy way to fill in all 4,000 cells with the same combo box? The other kicker is that...

Hi all. I have a list of items that i have converted into a table (because it makes it easier to update list validation drop downs that I have elsewhere). However, I have several other lists which use the items in this list as a source, but if I update the table by adding extra items, I then...

Hi, I have two lists (unequal) and would like to be able to return a simple yes or no next to the commodity description in column F if the commodity is listed in column A. I should note that the array in columns E:F is 124616 rows. I have therefore tried to use a nested Match function within...

Hi guys, I have a form I created for our department that has dependent drop down lists that I have cobbled together that is barely held together with spit and duct tape :) But I am having some issues creating another set of dependent drop down lists. I have three section with dependent lists...

So I have two lists of data that I need to compare. How would I go about comparing these two lists for matches and unique values? Should I use a Vlookup or Index match match? or is conditional formatting the best way to accomplish this task? Thanks!

Hello, i have a problem with drop-down list - my goal is to create two lists like: I choose value in cell a2 and excel shows concrete value in cell b2. This is simple. But how to make excel to make it both way. A2 choose "data" - display in b2 "excel" b2 choose "execel" - display "data"...

So trying to build a spreadsheet for my daughter for a game she got for Christmas. Each card has a value 1-3. I can build the data validation and I have the VLOOKUP correct, but I'm trying to figure out how to make it to where she can only select the number of things that the card value is...

I took over a spreadsheet for someone and I want to clean it up. On sheet1, there are several places where list validation is applied that references lists on sheet2. I am pretty sure some of the lists on sheet2 are NOT being referenced, so I want to get rid of those items for the sake of...

Hi all, I don't do spread sheets often and so am not fluent at all. I have muddled my way to a point that has given me an "almost working to my needs" data base. I have 4 sets of drawer units Column "A" lists up to 1006 electronic components. Column "B" lists 4 x 50 drawer units containing...

Hey folks a lot smarter than I am, I would appreciate some help. I have a large table of employee trained tasks: about 100 employees as rows and 50ish tasks as colums that each employee can be trained in. I would like to set up two different lists: one by task (so everyone trained in task A) and...

Hi I have built a number drop down lists - first is the category drop down followed by the sub-categories based on the first drop down list. I am trying to build a selection list that will be populated based on the result of the first drop-down list. Is this possible to do? Thanks

I have 2 lists of data, each list has 4 columns labelled W,X,Y, M(measurement). Data sets are subsets of each other. Want to match each pair of common W,X,Y data between sets along with the unique M of each set, side by side(e.g. adjacent columns). Never used VLOOKUP but guessing this is where...

Hello all, When Im in the site, there are 2 tabs - wathlists and quotelists. Quotelists is the default. When I put the simple link to watchlists it pops up and then ends up jumping back to the main page: objIE.navigate "https://www... I have also tried clicking the tab but Im still new to...

Hello! How can I set a data validation list such that if the drop down value in the cell is deleted, the cell will automatically show a default value (i.e. "-Select-")? For example, I have a worksheet with multiple drop down lists that I want to show a default value of "-Select-" once the...

Hi all, I need to populate a drop down list in a cell based on the value of another cell. If type in A1 cell "Fruits", in B1 it only lists "Apples, Lemons,..." of vegetables lists. Thanks

I have an Excel (2016) workbook, on sheet 1 there are multiple drop down lists. On 3 of them I would like to choose multiple items. The VBA code I used changes all of the drop down lists to have multiple items but I would like to specify the drop down lists on the sheet that have multiple item...