lists

I've been toying around with Lists as my boss tasked me to update our data input from Excel. Lists is cleaner-looking and more corporate. I can get behind that. Thing is, in my Excel file, I used macros extensively, but one key element was to check in other sheets when data was entered, and if...

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

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

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

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

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

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

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

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

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

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

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

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

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

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? https://www.nhl.com/standings/2019/league

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

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

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: https://teuxdeux.com/ or Trello ie, have...

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

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