questions/others
Create a table (insert > table) from ...READ MORE
on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE
You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE
Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE
Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE
No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE
Use the pandas library import pandas as pd a ...READ MORE
At the top of the script you ...READ MORE
Here is a basic macro that deletes ...READ MORE
The workbook doesn't have the UsedRange property ...READ MORE
Try the next adapted way. No need ...READ MORE
Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE
Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE
You can use a FOR loop and ...READ MORE
Change your code to this: Function RemoveTags(ByVal Value ...READ MORE
Use ListCount to retrieve the number of ...READ MORE
One application only. It would be quicker ...READ MORE
To insert the dropdown, you can go ...READ MORE
Use VLOOKUP, to make sure that your "Another ...READ MORE
Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE
In a Textbox it is a vbcrlf ...READ MORE
Macro1 is illegible as syntax. After the ...READ MORE
The copy inside the loop is overwriting ...READ MORE
Try this: Dim wb ...READ MORE
Use the filter function: =FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4)) Maybe you have to ...READ MORE
The MaxMinVal was when you wanted to ...READ MORE
Try this: Option Explicit Sub MC_Sim() ...READ MORE
Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE
The below formula will create a unique ...READ MORE
Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE
I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE
If J17's value is a true or ...READ MORE
Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE
Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE
Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE
ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",","))) shows TRUE if Maria is found and false if it would ...READ MORE
Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE
In Excel-365 you can directly use ABS() function with array of ...READ MORE
6.3 is correct answer just not in ...READ MORE
In Excel 2013 this formula can be ...READ MORE
Use a flag to omit first row Sub ...READ MORE
The filtering criteria applied to a column ...READ MORE
No need of any variable (besides Target). Please, ...READ MORE
Excel will automatically make assumptions about the ...READ MORE
Only the period (.) is accepted by ...READ MORE
Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE
There is an excel if() function for ...READ MORE
You appear to be misunderstanding the point: ...READ MORE
In PQ, highlight the Group column and ...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.