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