1. C

    Combine lists with similar headers

    I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...
  2. M

    Consolidate multiple tables dynamically

    Context at the bottom. I am hoping you are able to assist me with an issue I am struggling to resolve. I have data collected in multiple separate SharePoint lists (identical structure) which can change dynamically which is causing me issues in consolidating all the data in to one table within...
  3. M

    Taking a list that fills multiple columns and turn it into a list with only 2 columns

    I currently have a list of clients where in some cases, the clients have multiple client numbers which are in different columns. I need to move those with multiple client numbers to have the client number on it's own row. My dataset currently looks like this: CLIENT CODE 1 CODE 2 CODE 3 CODE...
  4. D

    Reset Button for Drop Down Lists

    I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation. We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button? Thank you
  5. A

    connect exiting workbook to a SharePoint Lists

    Hi All, I've been googling a way to connect an existing workbook to a sharePoint list I have a maro enbled workbook and I'd li to connect to 5 different SharePoint lists on different sheets in the workbook.S
  6. Darth_Williams

    Filters & Drop Down Lists

    Good afternoon all, I have created a spreadsheet that uses drop down lists to control the data that is entered. A problem that I have encountered though is that I can not now apply filters to my headers. Does anyone know of a work around for this or is it a by product of using drop down lists...
  7. M

    Name manager - adding data manually as reference

    Hello, Normally we create named ranges by referring to excel lists - we select the data range that is located in certain cells in worksheets. I tried to create named ranges by manually adding data to "refer to" part. But it didn't work - all the data that I added appeared in one cell, so not...
  8. S

    Dynamic unique lists

    Hi all I am trying to create a series of dynamic lists with data from a table searching on 1 criteria to return a second set of data Example data set Make Item 200mm ICP module 300mm DEP module 200mm DSiv module 200mm DEP module 300mm Synapse module 200mm DEP...
  9. DRSteele website; How to get tables into PQ

    Can someone please help me? I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique?
  10. Y

    Create concatenated list of unique IDs from multiple ranges

    I have several lists named as ranges and want to create a single list of all the unique combinations of items on those lists with a formula ideally: For example, if I had three lists with the following values: List 1: A, B List 2: 1, 2 List 3: X, Y The formula would create this list: A1X B1X...
  11. Z

    Issue drop down menu indirect from offset table

    Hi, I cant seem to resolve this: I have made some tables i wish to use in two drop down list with the one list dependent of the choice of the other(indirect formula) The lists is made by using the offset and antalla fomula to avoid emtpy cells in lists. My problem is that when i want to make...
  12. H

    Automatically populate lists from master list/ Create Teux Deux or Trello Style lists

    I have one long list of tasks in an excel sheet with columns for task, date due, project & priority etc. I have macro buttons to sort by each column and generally it works well and is simple but I would like to be able to view it in a similar way to this: or Trello ie, have...
  13. D

    VLOOKUP not finding data that is present

    Trying to use one worksheet as data and do calculations on another, thus need to pull specific data from the data sheet to my calculations sheet. Using the formula: =VLOOKUP(C4&"",'List of Lists by name'!D:D,3,FALSE) This returns the #NA error, despite my confirming the data is located in row...
  14. M

    Result based on criteria fro 2 lists

    Please can someone advise me the best way to go around this scenario. To help ease calculations for a mileage report I want to put together. I am thinking I will have 2 lists that generate a result (you maybe able to advise a better way?) – a list of clients (going from) and a list of clients...
  15. D

    Help finding unique names between two 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
  16. M

    VBA - Lists with dynamic content for dropdowns

    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...
  17. G

    Embedding Pivot 'Custom Lists' into a worksheet

    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...
  18. S

    Display values only of the first X Occurences of a condition in a small range .

    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...
  19. M

    Extract informations if distance (lat,long) between two lists of places is lower than 50km

    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...
  20. IluvPivots

    Label Last Saturday

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back