function

Hello, I'm trying to create a function called TextByColor using VBA. The purpose of this function is to read through one of my sheets called "JOB CODES" and the return all the cells with a white or yellow cell background to a sheet called "TV". The function should read through all of "JOB...

I need a formula that is using the data from the table named "Costs". I need to sum the Hours column IF the Concatenate column has any of these values...162FOL, 392FAL, 392FGL, 392FFL, 392PFL, or 452FGL AND the date is before 6/1/2023. This is what I currently have and it is returning a result...

Hi Everyone I have done a bit of VBA coding but usually it involves modifying existing code I have found on forums such as these - so I am at a fairly basic level. In particular I have little to no experience in writing excel functions. I am working with two different types of Google Map URL's...

hello there, i would like to know if excel could apply search based on multiple condition and return a specific value that match with all conditions and there is the assumption. if i work in a bank and the bank sometimes do investigations to some customers to check their valid to have a credit...

I have two columns - Name and value. When I want to SUM the range using SUM function, I get total sum. value. But what I'd like to do is my total sum will be auto updated if I fill any cell with a color. In the example snippet (attached), when I fill cell D12 with any color for example yellow...

Hi guys, Already tried search, but could not find an answer to my question. Is there a way to have the function NETWORKDAYS to use two list, one of holidays and another one of vacation days? I could not find an answer to this question, so, I think I will have to use only one list of "holidays...

Hi, I would like to create below function using the header name in a dynamic table in another workbook as the range. =COUNTIF([Inventory0221.xlsx]CitiPlaza!Table1[[#Headers],[ Service Tag/Serial No.]],[@[Serial number]]) the range of which I want to use the header name is...

Situation: I have this VBA code that logs any change that is made in the excel sheet and that great; but i need it modified. The plan is to use this in one column as a master change log. But i need a sepret one that will log the window user ID / DATE / Time and lock it to the ROW they edited. So...

Situation: Here is what i have working now. The VBA code will save a copy of the current sheet as an archive file in .CSV format. I'm able to assigned it to a button and it will do it on a sheet by sheet basses. This means what ever sheet the button is assigned to it will export that sheet and...

I have both sides of the code but do not know how to join them together. One part of the cod will pull the Windows user name but not work with a selected range and not work with if there is a change in that range. The other part works with with timestamping when ever there is a change within a...

Hello, I'm trying to figure out a way to get a cells "last modified date" in order to use it with XLOOKUP. I've seen examples where people are using formulas to CREATE a TIMESTAMP in a separate column, but I can't use those examples as written considering I have actual dates in the column that...

So I have two worksheets in sheet 1 I am trying to perform a vlookup function that goes as follows XLOOKUP(B55,'Sheet2'!P:P,'Sheet2'!D:D) where the lookup value is 16/02/2023 00:00. I know this value is present in column P of sheet2 and that it has a corresponding value in column d but whenever...

I am confused why my Custom Column returns a Function instead of lists? Output: = Table.AddColumn(#"Grouped Rows", "Test", each if List.FindText(Text.Split([All Matches], ","), [Email Domain]) <> false then each let EmailDomainVar = [Email Domain] in List.Select(Text.Split([All Matches]...

Hi all, I've been looking for a solution to my problem for way too long so I hope someone here can help. From an Excel workbook, I run a macro that will open/activate an existing Word doc, copy some info from the spreadsheet onto this word doc, then, if the user requires it, another existing...

Supposing that column C2 contains the function: =LIEN_HYPERTEXTE(B2;A2) how can I delete both column B2 and A2 without affecting the column C2?

I'm trying to come up with a function that ranks scores sequentially with ties receiving the same rank. I've gotten really close by using: =SUMPRODUCT((I5>=I$5:I$129)/COUNTIF(I$5:I$129,I$5:I$129)) In fact, this works perfectly when sorting smallest to largest: In a ranking of 125...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare. How can we solve it in the shortest possible way...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare.

Hi I have a reference cell B2 which contains the year. I would like to create a formula that contains dates (not referenced in cells) and counts the duplicate dates. Within the formula I have the fixed dates DATE(YEAR(B2),1,1),DATE(YEAR(B2),3,2),DATE(YEAR(B2),5,1),DATE(YEAR(B2),5,9) and I would...

Hello, Why is it that this function always return 1 when used as a Excel function ? Function NbFeuillesActives() NbFeuillesActives = ActiveWindow.SelectedSheets.Count End Function Regards.