function

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

This function's behavior has me stumped. I want it to run and recalculate whenever a cell in rng changes. Sometimes it does, sometimes it doesn't. It depends on how I enter a new value in rng (copy/paste, keyboard, another UDF, etc.). The result is that the function isn't updating to the most...

macroTest1 runs fine when the entire function is commented, but this error comes when I comment the function I am using the following references can someone help me with it?

Hello - I'm trying to create a master Workbook that can take the average of the values of an individual cell across multiple workbooks, but given a certain condition is met. For example, I want to average all of the values of C3 (which is a number) across all worksheets, but only when cell A4...

morning, I have 3 rows of random data showing a number of product orders across 12 months. Each row shows a product line. However not all sales lines start in month 1. Therefore I need to shift the start month right by ’x’ number of months. X is again random. product 1 starts in month 1...

I'm trying to locate a row # with data I need to update based on two text boxes within a userform. Code is here: Private Sub cmdSendData_Click() Set wb = Workbooks.Open("\\TABLE.xlsx") Dim wsTgt As Worksheet: Set wsTgt = wb.Worksheets("Sheet1") Dim recRow As...

Hello, I would like to extract text between MULTIPLE parentheses in one cell (without using VBA). The blue text in the picture below is what I'd like to achieve automatically. When there is just one set of parentheses, it's easy. For B1 I could use...

Hello All, So I have a table which is doing a series of calculations based off of different language criteria. I want to add an additional variable which will only run this string of calculations if another text variable is present in a different cell. If that text variable isn't present...

Hi there First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working. I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to...