function

I have a userform that takes input from the user and adds it to the first five rows in the next available column of the worksheet. In row 6, I want a formula like: =IFERROR(AVERAGE(D7:D32),"") but the cell reference, of course, has to be for the current column (which changes with each instance...

I have a list of values in a named range and I want to count each of their occurrences in another range with text added to the end of it. For example, the named range contains the value "L, E, & N". I want to find the amount of times those values appear in another range with "-FAL" or "-SAL"...

Hi guys! I created a user form with various checkboxes. I need a code that will write all the selected checkboxes into one cell divided with comas. For example: If a user checks the boxes "apple" and "pear" I want to write apple, pear to one cell. If the check only "apple" it should write apple...

I have a Excel table in the form below that was extracted from a separate sheet: Level1 Level1-Level2 Level2 Level2-Level3 Level3 Level3-Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild...

I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...

Hi, I am trying look for a function or a solution to finding the second highest value in the array of data that may contain multiple instance of same values. for example: array = [31,28,31,27,28,29,26]. The LARGE function couldn't help me because if I pass arguments like LARGE(array.2) it will...

I am trying to make a function where, based on an article code, the funciton looks in a different sheet with matching codes and takes the right discount (5 columns to the right of the cell with the code). Then I would like to return a specific value when the discount is set as "standaard"...

I am using a workbook as an order form for inventory. I have a macro that copies all the Items that were entered on the order form to a Item Master Sheet. Another Macro then removes any duplicate items. When I fill out a new order form and start typing in the item, I want excel to...

I am not well versed in VBA and have no idea where to start finding the issue here. I need to write a function that will take a 1 dimensional array as an input and spit out a new array with all the values sorted alphabetically and duplicates removed. This input "SourceList" column has text...

Can someone help me find a shorter formula. I would like the corresponding row's first column to appear in successive columns in a second sheet. Each F number (ie F1, F2, etc) refers to a person. the cells to the right of each person refer to a job that they will be doing (ie Team 1, Team 2...

Running in Excel 2016 on Win10: I've been testing a workbook that will be used by several users to write data to a single workbook stored on a network. I am using a VBA function to checks that the network file is not already open before opening it, writing data in it, and saving and closing...

Hello everybody! It's nice to be back on the MrExcel forum :) I am currently managing a list that essentially looks like this (just a lot bigger): I would like to create a pivot table and a slicer for this (the real file is over 1000 cells) so it becomes much easier to look up specific...

Dear all, I am relatively new to Excel and have little experience with functions, especially across different excel files. I currently have two excel-files, where one looks like this (file 1): And the other one looks like this (file 2): Currently, what I would like is for file 1 to...

Is there a way to add another condition to the code below to read if the cell it's targeting for the function is not blank then do not push the function? Thanks! For Each cellAR In Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row) If InStr(cellAR.Text, "City, ST, Zip") > 0 Then...

Hello everyone, I recently ran an experiment that required participants to select exactly 35 out of 100 squares on a 10x10 grid. I now need to calculate the mean of all possible pairwise distances between the 35 selected squares on the grid. I have attached images of a file that has two tabs...

Can someone help me please, I'm trying to get this COUNTIF function's criteria to be a cell (see image below) it works fine when I have it as =COUNTIF(P2100:P2205;"Nov 2020") but then every month I would have to change it manually. cell N2208(highlighted in green) updates automatically every...

Greetings All, I'm looking for a VBA solution or function to help in this scenario. In A2 I have some text. I want to know if some of that text is in a long text string within B2. And if so, HIGHLIGHT that text so it is easily identifiable. SOURCE FOUND GRANNY SMITH APPLE ORANGES...

Hi all, I am extremely new to VBA so I apologize if this is a stupid question. However, I have created this code sub (format) Sheets("T_maintained").Select ActiveCell.Offset(0, 2).Activate Dim B As Long For B = 1 To 36 Fill Next B Sheets("Mastersheet").Select ActiveCell.Offset(1, 0).Activate...

I have question is it possible to combine a normal formula and array formula because as of my knowledge one only requires enter and another ctrl shift and enter. How do I combine them both if it is possible? =IF(IFNA(VLOOKUP(M2,CHOOSE({1,2},IF('[Tier Price List.xlsx...

hi everybody ,,, i have created a function named check_ punctuation like this : Function check_punctuation(my_str As String) As Boolean Dim asci_code Dim str_temp For i = 1 To Len(my_str) asci_code = Asc(Mid(my_str, i, 1)) Select Case asci_code Case 32 To 47 check_punctuation = True Case 123 To...