Most answered questions in Others

0 votes
1 answer

How to format calculated land size in excel

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

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
568 views
0 votes
1 answer

Type the max number title in Excel

If you have duplicates and want to ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
387 views
0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
381 views
0 votes
1 answer

How to pass a JSON-formatted string from Excel VBA as argument to a MySQL Store Procedure

Set the parameter length to the json ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
614 views
0 votes
1 answer

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
223 views
0 votes
1 answer

Modify table data in excel sheet by userform

Try this: Private Sub CmdUpdate_Click() ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
627 views
0 votes
1 answer

Vba range object single column autofill

Just refer to the first column of rng. ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
• 38,010 points
322 views
0 votes
1 answer

Conditional formatting on a calculation in excel

In E5, you could use =IF(COUNTBLANK(E3:E4)=0,E3-E4,"") which would ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
638 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
511 views
0 votes
1 answer

How Do I Correct a ByRef Mismatch Error in VBA for Worksheet_Change Sub in Excel?

Len of a string returns what you need. ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
1,514 views
0 votes
1 answer

Excel Nested IF INDEX MATCH Function

Use COUNTIF and an array if all ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
809 views
0 votes
1 answer

Processing in vba

Try this: Option Explicit Sub Macro2() ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
281 views
0 votes
1 answer

VBA - Insert Spilt Cell Value

Your desired outcome will not be produced ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
302 views
0 votes
1 answer

Loops through Check Box in VBA

Please attempt the next option. Assuming you ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
752 views
0 votes
1 answer

Global Collections

To store your public objects and expose ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
404 views
0 votes
1 answer

Stuck on a Query for a stock trading spreadsheet

Try this: =QUERY(QUERY({QUERY('Movimentações'!A2:J,"Select F,C,D,E,(I*-1),(I*-1*J),(I*0),(J*0) where A matches 'Venda' ...READ MORE

Apr 1, 2023 in Others by narikkadan
• 63,720 points
250 views
0 votes
1 answer

Copying a sheet with specific formatting from an excel file to a new output

Using Python and the openpyxl package, you ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
9,172 views
0 votes
1 answer

Macro throwing error when run from customized ribbon

The original macro was created in an ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
411 views
0 votes
1 answer

How to transpose data in an other tab in excel

If you're using a previous version of ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
383 views
0 votes
1 answer

Run macro when on Worksheet change (i.e. changing sheets, not data within sheet)

Try this: 'put this sub in ThisWorkbook module ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
475 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Qualify the sheets with a workbook reference ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
392 views
0 votes
1 answer

Adjacent excel cells show same cell address on using =cell("address") formula.

Use the reference argument: =CELL("address",L54) From the docs: reference: The cell that you ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
258 views
0 votes
1 answer

How to change date format from 201904 to Apr-19 in excel

This 201904 is recognised as a number ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
315 views
0 votes
1 answer

VBA - Applying border around the areas with value/text

Try this: Sub BorderArroudAreas() Dim sh ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
445 views
0 votes
1 answer

List Fridays and Saturdays in excel

 Try this: =TEXT(FILTER(SEQUENCE(DAY(EOMONTH(A4,0)),,EOMONTH( ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
• 38,010 points
364 views
0 votes
1 answer

A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
298 views
0 votes
1 answer

How to turn a number recognized as string to number

Try this: =VALUE(SUBSTITUTE(A1," ", "")) Or select cells with ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
314 views
0 votes
1 answer

Trying to redo my Export Button Function on my document

You could directly publish the data to ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
358 views
0 votes
1 answer

"Errno 13 Permission denied" while running Python Script through VBA

According to the error message, the.xlsm file ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
1,400 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
325 views
0 votes
1 answer

Power Query - Search an element of column A in entire column B

The delta column in PowerQuery is calculated ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
419 views
0 votes
1 answer

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

Concatenate If Not Blank Replace the J with I to replace as ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
304 views
0 votes
1 answer

How to change where an email is sent FROM in Excel VBA

Inside the 'with out mail, insert this ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
1,118 views
0 votes
1 answer

Python write a list to multiple columns in excel

Make a nested list : L = [list1, list2, list3] Then ...READ MORE

Mar 30, 2023 in Others by narikkadan
• 63,720 points
3,562 views
0 votes
1 answer

How to do the comand IF THEN in Excel

Try this: =SUM(IF(AND(H39<=38,H39>=20),1,0),... If so then maybe this is ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
314 views
0 votes
1 answer

Is it possible to create a universal hyperlink in excel for windows and mac without programming

You may learn whether it runs on ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
617 views
0 votes
1 answer

Why am I not being able to read the Excel sheet in my Jupyter Notebook

Verify that it is actually in your ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
462 views
0 votes
1 answer

How do I build a loop into this TimeStamp VBA Code?

As Target is a range, it may ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
407 views
0 votes
1 answer

Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
411 views
0 votes
1 answer

Change sheet tab color depending on CountA function result

Try using the ws. prefix to set ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
215 views
0 votes
1 answer

Another method to extract the last row containing data in a column

The "used range" might not be accurate. ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
432 views
0 votes
1 answer

Selenium extract data after </strong>

Try this: phone_element = OBJ.find_element_by_xpath("//*[@id='main']/div[1]/div[2]/div[2]/div/div/div/div/div/section/div/div[1]/div[2]/ul/div/div[3]/li/div/div/strong/following-sibling::text()") phone_number = phone_element.strip() Using the ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
406 views
0 votes
1 answer

iCell.Value takes too long

Please try the following modified code. The ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
• 38,010 points
386 views
0 votes
1 answer

Excel - How do I round a date type to the next hour if it is more than one minute

Add almost 30 minutes and it'll get ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
267 views
0 votes
1 answer

How to find all internal ranges in a specified range

It is simple to compare once you ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
442 views
0 votes
1 answer

Convert Yaml to excel in Python

You can try this: First, install dependencies: pip install ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
868 views
0 votes
1 answer

Runtime Error while dynamically adding controls to a userform

You appear to be attempting to execute ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
355 views
0 votes
1 answer

Mapping cells between between two ranges

Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
670 views
0 votes
1 answer

See cell content instead of formula in formulabox in Excel using VBA

A VBA Lookup: Lookup Headers in an ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
372 views
0 votes
1 answer

Count unique matches between two rows in Excel

The formula should be (in Excel 365) =SUM(--(COUNTIF(Draws!$B$2:$G$18,B2:K2)>0)) so ...READ MORE

Mar 27, 2023 in Others by narikkadan
• 63,720 points
444 views