list

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

Dear Mr. and Mrs. Excels, I'm looking for a solution for the following problem: I have a huge list (28 000 rows) of items (practically document subchapter titles) that are connected to their parent items (main chapters) as follows: Chapter title Subchapter title Staring page no. 1.1...

I'm pretty much self-taught on Excel, and I'm really having trouble with this... I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data. My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of...

Hi I have a list in excel with following columns SocialID (unique number) Name Phone number A person can have several rows since they can have 1 or 2 phone numbers. I want to merge the list into a new with these columns. SocialID Name Phonenumber 1 Phonenumber 2 How can i do this?

hello i need a VBA code that gives me a list in cell B20 that contains values from sheet1 coulmn B:B. if value is writen 2 times, so give it to me only once. if value is writen oce, give it to me as well. each valuse only once. thank you!