questions/page/55
Column D's formula should be changed so ...READ MORE
When using the sep option in the ...READ MORE
It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE
PowerQuery would scan the contents of all ...READ MORE
It is necessary to list ThisWorkbook.model. Not ...READ MORE
Use this: SELECT *FROM ...READ MORE
I have integrated the chatgpt into my ...READ MORE
You can just delete the worksheets created ...READ MORE
See Conditional Formatting, which may be accessed ...READ MORE
You can make the listen callback an ...READ MORE
You can make a new checkbox object ...READ MORE
Remove Duplicates Based on a Single Column The ...READ MORE
Here is a refactored version of your ...READ MORE
Apart than the altered cell, Conditional Formatting ...READ MORE
You have set the global to false, ...READ MORE
Looks like the Worksheet_Change() sub needs two ...READ MORE
Just to show the behaviour of find(): READ MORE
You do not have the proper reference ...READ MORE
I need to use Excel formulas for ...READ MORE
You can change the formula in the ...READ MORE
You may learn whether it runs on ...READ MORE
For Excel 2019 and above use TEXTJOIN ...READ MORE
You can accomplish your goals in one ...READ MORE
To fix the issue of null temperature ...READ MORE
Try this: Sub UniqueList() Dim ...READ MORE
Use InStr function to find the beginning of the ...READ MORE
Use SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE
Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE
You can use pandas. import pandas as pd dict1 ...READ MORE
Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE
Use match() and if() without code at ...READ MORE
Try this: Sub Test() Dim ...READ MORE
You will need to save the attachment ...READ MORE
Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE
Try this: Sub BorderArroudAreas() Dim sh ...READ MORE
To store your public objects and expose ...READ MORE
With Formulas, Countif Partial String/Substring Match We can ...READ MORE
Solve By Calling with Module Name Another solution to the TypeError: 'module' object ...READ MORE
The xlsx extensions are not supported by ...READ MORE
In Excel 2016 at least the colors ...READ MORE
Replace Occurrences of a Substring With a ...READ MORE
Try this: 'put this sub in ThisWorkbook module ...READ MORE
I think this might be more of ...READ MORE
Ctrl-shift-home goes to the upper-left of all ...READ MORE
Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE
Try the following: The formula in F1 (as per my ...READ MORE
If you have duplicates and want to ...READ MORE
Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE
The delta column in PowerQuery is calculated ...READ MORE
Pivot Tables are mainly designed to create aggregated data from ...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.