questions/page/17
Looks like the Worksheet_Change() sub needs two ...READ MORE
Try this: Private Sub CmdUpdate_Click() ...READ MORE
PowerQuery would scan the contents of all ...READ MORE
Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE
Here is a refactored version of your ...READ MORE
Set the parameter length to the json ...READ MORE
I have integrated the chatgpt into my ...READ MORE
In Flutter, you can create reusable widgets ...READ MORE
You can try this: First, install dependencies: pip install ...READ MORE
For Excel 2019 and above use TEXTJOIN ...READ MORE
If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE
Switching from a career in QA testing ...READ MORE
Apart than the altered cell, Conditional Formatting ...READ MORE
In E5, you could use =IF(COUNTBLANK(E3:E4)=0,E3-E4,"") which would ...READ MORE
To get hectare (F2): =A2+QUOTIENT(B2*100+C2,10000) or =QUOTIENT(A2*10000+B2*100+C2,10000) To get are (G2): =QUOTIENT(MOD(B2*100+C2,10000),100) To ...READ MORE
To call a Dart async function from ...READ MORE
Try this: Sub UniqueList() Dim ...READ MORE
You can accomplish your goals in one ...READ MORE
You can make a new checkbox object ...READ MORE
Sounds to me like you need DateTime.ParseExact ...READ MORE
Use SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE
Convert Digits To Subscript (H₂SO₄) Excel Formula Improvement ...READ MORE
You can use the WidgetsBindingObserver to be ...READ MORE
The read() will read the whole file at ...READ MORE
Use InStr function to find the beginning of the ...READ MORE
Try the following: The formula in F1 (as per my ...READ MORE
Just to show the behaviour of find(): READ MORE
I think this might be more of ...READ MORE
You will need to save the attachment ...READ MORE
The xlsx extensions are not supported by ...READ MORE
Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE
Pivot Tables are mainly designed to create aggregated data from ...READ MORE
Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE
My form has a dropdown that I ...READ MORE
When a value is made up entirely ...READ MORE
If you have duplicates and want to ...READ MORE
Hi@akhtar, Actually, in kafka there is no command ...READ MORE
Hi, @Roshni, You can follow a few steps ...READ MORE
You can't put statements in JSX curly braces, only expressions. You ...READ MORE
By using the Text property, I was ...READ MORE
Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE
Try this: 'put this sub in ThisWorkbook module ...READ MORE
It's possible for someone to learn Flutter ...READ MORE
To store your public objects and expose ...READ MORE
You may learn whether it runs on ...READ MORE
A logit, or the log of the ...READ MORE
You can make the listen callback an ...READ MORE
Replace Occurrences of a Substring With a ...READ MORE
Try this: Sub BorderArroudAreas() Dim sh ...READ MORE
Just refer to the first column of rng. ...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.