questions/others
Copy the next event code in the ...READ MORE
Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE
You are making heavy use of Target.Address ...READ MORE
Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE
Application.DisplayStatusBar = True Is cancelling your ...READ MORE
Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE
Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE
Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE
Although there are other approaches you may ...READ MORE
Try this: Sub Test() Dim str As String: str ...READ MORE
Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE
Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE
I have a homework to make a ...READ MORE
Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE
3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE
You have to change: chrtname = Cells(i, 2).Value To: chrtname ...READ MORE
Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE
Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE
When the links in the master sheet ...READ MORE
You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE
The SUBSTITUTE() method can be used to ...READ MORE
Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE
Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE
Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE
Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE
You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE
Try this: Sub Tester() Dim ...READ MORE
You just need to adjust the font ...READ MORE
I think there is no built-in function ...READ MORE
You can use a Select Case statement : Option Explicit Sub ...READ MORE
It seems like the 32-bit version of ...READ MORE
You have to use dateadd. For i = 1 ...READ MORE
Try this: def teste(id): listID = ...READ MORE
You can use useId to create a ...READ MORE
Try this: Option Explicit Sub demo() ...READ MORE
Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE
If you wish to utilise a single ...READ MORE
Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE
No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE
Try this: Sub OrderColumns() Dim ...READ MORE
VBA bubble sort - no changes to ...READ MORE
Solution All your data is in column A ...READ MORE
Use this: Option Explicit Type ObjLocData ...READ MORE
As you see LoginID is the id of the ...READ MORE
FILTER Function: "filters" a range of data ...READ MORE
Data is separated into CSV (Comma Separated ...READ MORE
Try this: =SUBTOTAL(105;B2:B7) READ MORE
Create a CSV file that is in ...READ MORE
By replicating the data series and substituting ...READ MORE
With the next available row as the ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.