value

I am looking for assistance in setting up a formula to return incremental values to a list (including duplicates) only when selected values are present in a different column. Please see the example attached, if the produce is apples, banana or peach assign the number (1,2,3) representing the...

Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...

I have a list of correct and incorrect names as seen in sample file below. I am trying to loop through a list of sheets and do a find and replace for each item on the List. The Correct Name is what the replace is going to be and the Incorrect Name is the find. I have looped through specific...

Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...

Hi all! I'm new to this forum and I'm not quite an expert in VBA, but I'm trying. I use this function to get the filedate time from a file: Function GetFileDateTime(R As Range) Set R = R.Cells(1, 1) GetFileDateTime = format(filedatetime(R.Value), "dd-mm-yyyy hh:nn") End Function This works...

Hello: I worked for over an hour last night trying to get this darn formula to work and have been unsuccessful. I know it is probably something stupid, but my brain won't get to the solution for some reason. I split my home with another and we use a list to keep track of expenses that we both...