questions/others/page/4
Here is a refactored version of your ...READ MORE
For Excel 2019 and above use TEXTJOIN ...READ MORE
Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE
Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE
Hey, I completed my graduation in civil ...READ MORE
Looks like the Worksheet_Change() sub needs two ...READ MORE
You may learn whether it runs on ...READ MORE
I need to use Excel formulas for ...READ MORE
You can change the formula in the ...READ MORE
is there any video recording to enable ...READ MORE
To store your public objects and expose ...READ MORE
Try this: Sub BorderArroudAreas() Dim sh ...READ MORE
Use SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE
You can accomplish your goals in one ...READ MORE
You will need to save the attachment ...READ MORE
Use InStr function to find the beginning of the ...READ MORE
Try this: Sub UniqueList() Dim ...READ MORE
Use match() and if() without code at ...READ MORE
Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE
Try this: Sub Test() Dim ...READ MORE
Replace Occurrences of a Substring With a ...READ MORE
Ctrl-shift-home goes to the upper-left of all ...READ MORE
The xlsx extensions are not supported by ...READ MORE
Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE
Verify that it is actually in your ...READ MORE
Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE
The delta column in PowerQuery is calculated ...READ MORE
Qualify the sheets with a workbook reference ...READ MORE
Workbooks can be secured against certain actions, ...READ MORE
Try this: 'put this sub in ThisWorkbook module ...READ MORE
If you're using a previous version of ...READ MORE
I think this might be more of ...READ MORE
Try the following: The formula in F1 (as per my ...READ MORE
If you have duplicates and want to ...READ MORE
Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE
Try this : Option Explicit '~~> Since we are ...READ MORE
Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE
Use the openpyxl module in Python to do that, ...READ MORE
Pivot Tables are mainly designed to create aggregated data from ...READ MORE
This 201904 is recognised as a number ...READ MORE
You might keep a txt file with ...READ MORE
When a value is made up entirely ...READ MORE
Try this: let columnNames= {"E ...READ MORE
It is simple to compare once you ...READ MORE
When you press the Display button, the ...READ MORE
You get your code to make a ...READ MORE
Try this: =VALUE(SUBSTITUTE(A1," ", "")) Or select cells with ...READ MORE
For a cell that is consistent across ...READ MORE
When a message body is created by ...READ MORE
Try this: =SUM(IF(AND(H39<=38,H39>=20),1,0),... If so then maybe this is ...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.