1. T

    Power Query: Sort Table Columns Using a List

    Hi all, This should be easy but I'm having some trouble with the syntax. I'm trying to sort multiple columns in ascending order in my table. It's easy enough to manually click each column and sort it in descending order, but then my M-code is hard-coded to these column header names. If the...
  2. D

    M code Date.StartOfMonth where should is go?

    Hi, I have a lsit of a list of dates produced by uisng ; Table.AddColumn(#"Changed Type", "Custom", each List.Transform( { Number.From( [#"Sart Date "])..Number.From([End Date] )}, (_)=> Date.From(_) ) ) the output of which is : but I need the dates is the lists to be the start of the...
  3. M

    UserForm with Multiple Lists in a Single ListBox Dynamically

    Hi, I have spent hours and finally got the multiple lists to work dynamically in the ListBox. But for the oddest reason when i click on an "option" the box moves way over almost out of the form. It still works perfectly but it is visually unappealing. See the attached screenshot before i...
  4. Z

    VBA: Rename all Tables based on a list

    Hello, I have multiple tables in a sheet (48 to be exact, they relate to a survey question) with the table name currently set as Question1, Question2, and so on. I need to duplicate the sheet as each table of answers needs to relate only to the answers provided in a certain grouping (say, by...
  5. N

    How to create a dynamic list based on value in one cell when the list to be created is based on another cell?

    I will try to be as clear as possible. This is my destination where I would like for a drop down in the column "Pick a batch" for each row. Plant SKU Concat Pick a batch abc 12345 abc12345 def 98765 def98765 ghi 33333 ghi33333 abc 12345 abc12345 Base data is in the below...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. 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?
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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

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