questions/page/126
Use InStr function to find the beginning of the ...READ MORE
Yes, I can help you with that. To ...READ MORE
Add column, custom column with formula: = try ...READ MORE
I need to use Excel formulas for ...READ MORE
Try this: Sub UniqueList() Dim ...READ MORE
def strictlyInc(l): for i in range(len(l)-1): if l[i]>l[i+1]: return "No" break return ...READ MORE
For a cell that is consistent across ...READ MORE
SourceFolder is an object that only understands ...READ MORE
Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE
Yes, you can swap the slots in ...READ MORE
Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE
Hey @kartik, Named routing is another amazing feature of ...READ MORE
Hey, I completed my graduation in civil ...READ MORE
The "used range" might not be accurate. ...READ MORE
I am looking for a secure collaborative ...READ MORE
Try the following: The formula in F1 (as per my ...READ MORE
To dismiss the on-screen keyboard, you can ...READ MORE
Projection means choosing which columns (or expressions) the query shall ...READ MORE
These messages are classified as warnings rather ...READ MORE
Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE
You might keep a txt file with ...READ MORE
This 201904 is recognised as a number ...READ MORE
Try this: =VALUE(SUBSTITUTE(A1," ", "")) Or select cells with ...READ MORE
If you're using a previous version of ...READ MORE
If you have duplicates and want to ...READ MORE
The RibRefresh sub's logic is overly convoluted ...READ MORE
When you press the Display button, the ...READ MORE
You could directly publish the data to ...READ MORE
The delta column in PowerQuery is calculated ...READ MORE
Pivot Tables are mainly designed to create aggregated data from ...READ MORE
When a value is made up entirely ...READ MORE
When a message body is created by ...READ MORE
I have a Jenkins pipeline job. When ...READ MORE
If you could go back in time ...READ MORE
Firebase is a popular backend-as-a-service (BaaS) platform ...READ MORE
Yes, Podcasts, those nice little Audiobooks I ...READ MORE
Try =INT((YEARFRAC(TODAY(),B3,1))) Where cell B3 contains a date like ...READ MORE
Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE
Add on the sheet an ActiveX Microsoft ...READ MORE
Not able to connect remote host via ...READ MORE
Just refer to the first column of rng. ...READ MORE
Multiple crucial tasks are carried out by ...READ MORE
Assuming the input data for the second ...READ MORE
Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE
How is marital status distributed each year? ...READ MORE
Try this: =SUM(IF(AND(H39<=38,H39>=20),1,0),... If so then maybe this is ...READ MORE
Delete the original shape and then replace, ...READ MORE
A few things that will help. Don't ...READ MORE
To obtain temporary AWS credentials for an ...READ MORE
There is no indication in your code ...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.