questions/others/page/11
Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE
You are making heavy use of Target.Address ...READ MORE
Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE
Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE
Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE
Copy the next event code in the ...READ MORE
Although there are other approaches you may ...READ MORE
Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE
Application.DisplayStatusBar = True Is cancelling your ...READ MORE
Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE
Try this: Sub Test() Dim str As String: str ...READ MORE
Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE
You have to change: chrtname = Cells(i, 2).Value To: chrtname ...READ MORE
Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE
I have a homework to make a ...READ MORE
3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE
Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE
Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...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
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
Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE
Try this: Sub Tester() Dim ...READ MORE
Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...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
You just need to adjust the font ...READ MORE
It seems like the 32-bit version of ...READ MORE
You can use a Select Case statement : Option Explicit Sub ...READ MORE
I think there is no built-in function ...READ MORE
You have to use dateadd. For i = 1 ...READ MORE
Solution All your data is in column A ...READ MORE
Try this: def teste(id): listID = ...READ MORE
You can use useId to create a ...READ MORE
Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE
Try this: Option Explicit Sub demo() ...READ MORE
No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE
If you wish to utilise a single ...READ MORE
Try this: Sub OrderColumns() Dim ...READ MORE
Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE
VBA bubble sort - no changes to ...READ MORE
Data is separated into CSV (Comma Separated ...READ MORE
As you see LoginID is the id of the ...READ MORE
Use this: Option Explicit Type ObjLocData ...READ MORE
By replicating the data series and substituting ...READ MORE
PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE
FILTER Function: "filters" a range of data ...READ MORE
While using the Laravel project directory, edit ...READ MORE
Create a CSV file that is in ...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.