function

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.

Hi, I am trying to copy and paste some data from one sheet to another. I created a function to just do the copy paste becuse I have to do that for multiple headers. below is my code Function insert(header) Sheets(2).Activate Sheets(2).Cells.Find(What:=header, After:=ActiveCell...

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

Please help to make the function count the oldrows Public Sub Delete_Or_Insert_Rows() Dim NewRowCount As Long Dim OldRowCount As Long Dim LRow As Long Dim rng As Range Dim ws As Worksheet...

I have a project scheduling spreadsheet that I also use to create a P&L per project. At the moment it works with a fixed salary, however, salaries change with annual pay rises so I'd like to try and find a way to factor this in to my data so it stays accurate. I have a number of sheets working...

I have a function I wrote years ago. I'm not sure why, but sometimes, the string sent, is arriving empty to the function; not sure how this can be happening. This is very strange. Function FrameLoad102(ByVal MyQuery As String) MsgBox MyQuery End Function 'function call method...

One of the cells has an #NUM! error. Should be 0.0% This is the function: =([Total Sales] - [Total Sales DATEADD 1 Year Back])/[Total Sales DATEADD 1 Year Back] Thank you.

I have a situation here with me and I need someone to help me to fix it. There are two textboxes which contain dates That is textbox1 and textbox2 Then I have two columns with dates as well. Thats columns AO and AP. AO3 and AP3 are headers with the labels START and ENDED respectively. Now...

I have a sheet which calculates totals in column H. I need to be able to total only the positive numbers. The column looks like this: 5 4 3 2 1 0 -2 -5 -23-6 The location of the Zero changes depending on the data is entered, but it is always there somewhere. Would someone be able to help me...

Hello, I was using 32-bit Excel 2013 and had a workbook with a number of bespoke functions, some simple, some not so simple. However, after upgrading to 64-bit Office 365 all of my bespoke functions do not seem to be working. Here is example code to work out the inverse of the tangent...