list

I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...

How do I convert each row into a list without adding a new column? What I have so far: = Table.TransformColumns(TESTT, each Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv)([TESTT])) It gives error: Expression.Error: We cannot convert a value of type Function to type List. Details...

I attached photos. I have a spreadsheet with multiple rows containing criteria to be met or unmet, and then columns pertaining to persons who have either met or unmet the criteria in the rows. What I would like to do is create a follow-up sheet that autopopulates any unmet items. The...

I'm trying to check each list if any of its content matches any other lists' contents, and then flag them if found e.g. for each List in Time if List.ContainsAny(Current List, Any List from time column) then flag repeat for all...

I have a column that contains lists of dates. How do I remove dates from those lists where value does not = x?

Hey team, In the one spreadsheet I have a data tab that has different pieces of information from 5 departs organised in a weekly table format, as a master sheet. I then have another sheet that summarizes data for each department individually with a week on week trend, but only for that month in...

Power Query: I have a column with strings and a list of words I need found in that column AND (this is the difficult part) when found these words need to get cut off from the string (or replaced by "")? How? A sort of textual substraction... have been trying so long... list.accumulate etc...

Hi, I am trying to generate headers for a table. I decided to create a function just to generate header for my table. and to decide which row the header will go to my idea is to put the first element of my array(array that will be pass into the function)as the row number. following is my...

Hi! I've just been Googling excel forums trying to find a way to do this. I just want to make a cell auto-populate a body of text based on a dropdown menu selection. I know how to do that, though... However, I want to be able to EDIT the text that populates...and I DON'T know how to do that...

Hi all! Your help with this would be greatly appreciated. I have 2 dropdown lists using the same source. When the value in either List 1 or List 2 is changed via the dropdown, I want the other to change to match. I've got it working for one using the below VBA code, however, if I repeat the...

Hi, I have a macro button to open a userform mailing list (see image) which includes a combobox and listboxes. I had written code which got enhanced by member 'beyond Excel' below. Credits to him/her. The goal is to save the Sender, CC and Recipient addresses in named ranges on the data sheet...

Hello! A set of data was gathered where it consists of name of certifications and those who have completed such certifications. Required certifications (certs to shorten) needs to have a 'Yes' filled out . What I'm trying to figure out is returning a list of what certs that are required against...

Hi, Specific Value = 0.1 BCD1DataNumberResult20.430.140.250.13260.570.11180.590.1100.2110.2120.1130.1140.3150.1160.284170.9Description: 1. C5 number is 3, so count 0.1 in B5,B4,B3 2. C7 number is 1, so just count 0.1 in B7 only 3. C16 number is 8, so count 0.1 from B16 -> B9 No count if there...

Hello everyone, First of all, I don’t have the files available so I’ll try to do my best to be clear ! Let’s imagine we have two columns, in the first one we have the employee’s number (it might be a number of numbers with letters). In the second column we just have a number (we can suppose...

Good afternoon, Hoping to get some help on this one. I have a file that has a list of jobs, my boss will then put a % to each one of these jobs in E starting from E6. Once that percentage hits 100%, I would like it to send an email to our billing person, that says something along the...

Hi guys, Can you please help me with this issue? I have a list with fruits (I2:I13), and I want to create VBA form with one lable and one button, where on the lable it will be written the name of the fruit (first on the list), and by clicking on the button it should change the name of the...

Hi, I've created an UDF which takes some arguments and returns a list as a result, see example: Function myFunction(a, b, c) Dim MyFunction_result(1 To 4) As Double result1 = a + b + c result2 = a * b * c result3 = Sqr(a ^ 2 + b ^ 2 + c ^ 2) result4 = a * (b + c) MyFunction_result(1) =...

Hey guys, I could use some type of formula to grab the dates from a list that connect with each persons name on Guest_Info and bring it to Guest_List. The idea is each time their name is typed and they associate with a date; it will automate into these cells (Check_In_1, Check_Out_1 etc.) The...

Hi, In power query when using the Table.FromList function, I add ; Splitter.SplitByNothing() after the source list, as it doesn't seem to work if you don't . It says in microsoft docs that the splitter is optional, I tried just putting the value null, but this doesn't work either, can...

Hello. I am new to the forum. I have spent about a week looking for answers and trying to solve this issue on my own. I am fairly well-versed with Excel... more so than a "general user"; however, I have little experience with coding and VBA. I have attached a mini-sheet of my list; it's pretty...