lists

I have two lists. List one is n2:n74 and list two is in o2:o79. I need to find the names in list two that are not in list one. Thanks! DS

Good morning folks. I usually manage to find solutions by scouring forums but this time I've drawn a confusing blank. I've found stuff which partly solves the problem but I can't assemble a complete answer. So here goes. I have a) fixed data ws1.Range("A1:A3"). b) dynamic data in...

Hello everyone, long time lurker and big fan of the site. It's helped me many times. I'm hoping you can help with a question Basically: 1) I've created a slicer for a pivot table 2) I created a "Custom List" through Options-Advanced to rearrange the order of the items inside the slicer to what...

Hi... Could anyone help me with a solution to this. i am wondering if there is a function that will help me find... say 1st/2nd etc occurences of a condition in a list ? e.g. I want to pick out the first 3 numbers (say) that are over zero. so if my list is 0.00, 23.45, 45.67, 0.00, 0.00...

Hello, I have two lists of places (in two Excel sheets) : cities and swimming pools. I have the lat and long of all the places (for the cities it's the center). I want to extract a list of all the pools nearby every cities. So I would have a final list like this : - Name of the city / CityLat...

Column A lists dates. How do I get Column B to label the last Saturday of the month?

Hello, I'm trying to use if statement with 3 options with data validation. I got it to work with 2 but cant seem to figure how it will work with 3 or even if it's possible. the code I have is =SE(B5="yes";list1;list2) based on the word "yes" but I'd like to add another option to that IF. I'd...

Hi, Is there a way to set up Name Manager to change the Name of the sets in Name Manager automatically so it will allow the drop down lists to continue to work? Thanks Angus

Hi, I am using Indirect Drop Down lists for my project. =indirect(e30) etc. I have a rage of name ranges in the name manager. I am using this sort of formula to adjust the lists as things are added or removed: =Sheet1!$C$2:INDEX(Sheet1!$C$2:$C$1000,SUMPRODUCT(--(Sheet1!$C$2:$C$1000<>""))) My...

I'm not sure where to start with this one in VBA to be honest, If possible I would like to avoid an formula array list and VBA copy/paste which is how I would normaly do it but I'm finding my workbook is getting a bit slow! If I have range A2:A8 Cell A2 entry AA Cell A3 entry BB Cell A4 entry...

Hi there, I have two lists on one spreadsheet with the invoice number being common to both lists. The list on the left is from a supplier and the one on the right is my list. The list is about 2,000 lines and what the supplier wants to find out is if I have received their invoice and is it paid...

I have an array that takes two lists of dates that are in the same column and re-organizes them in chronological order and ignores blank cells that are a result of a gap in the two lists. For some reason it is completely ignoring one data point and giveing me a blank intead on row 101. I have...

Need VBA help For below data set in sheet "Data" Rollup Country(Column A) Country(Column B) Brand(Column C) Bangladesh Bangladesh Coke Bangladesh Bangladesh Pepsi Other...

Hi, I have searchable drop down lists in F5:F500 referring to a dynamic range in a second sheet. If F5-F500 are clear from input and I expand the drop down list, all options are shown from the dynamic range. If picking McDonald's in F5, all drop down lists F6-F500 displays McDonald's as the...

Hi everyone, I am working for a project for my company and would need some help on an issue I have. Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields. I am working with...

This thread lists 4 ways to post "small screen shots of your sheet(s)": https://www.mrexcel.com/forum/about-board/508133-attachments.html Are they only good for screen shots of cell ranges or can they be used for any screen object? I would like to post a screen show of the Name Manager...

Hi So, I'm not too sure how to go about this. I have 2 tables: one lists loans (amount, term, type (reducing debt orlevel) – the second list is for types of life cover amount, term,type, cost) The maximum loans is six and I 'm looking to also limit the policies to six aswell. I have...

I hope I can explain this well enough. I have a table that is columns A-P and with duplicate and unique values. The Data I want to match is in column I and column P. One is a name and the other is a date that has been extracted to month and year. I have one drop down list that has names and...

How would I go about making the VBA split the data into 2 lists (Multi & Single) based on an X placed in a column? I have VBA to do the lists how I needed them, now a new criteria requires me to split the lists. See the OUTPUT tab to see what the VBA produces now, vs what I need as the new...

Hi,I am in need of someone to solve a problem with dependent drop down lists using activeX combo boxes. Below are links to 2 files that are set up with data validation lists. Starting in cell B24 is the main list of fabric types and in cell D24 is the dependent list of fabric colors. In the...