Trending questions in Others

0 votes
0 answers

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,087 views
0 votes
1 answer

Export All appointments and meetings (including recurring meetings) Excel VBA

However, when I use the code above ...READ MORE

Feb 13, 2023 in Others by narikkadan
 • 86,360 points • 3,545 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,000 points • 1,558 views
0 votes
1 answer

Read .xls file with Python pandas read_excel not working, says it is a .xlsb file

Try: import openpyxl xls = pd.ExcelFile('data.xls', engine='openpyxl') df = pd.read_excel(xls) Recently, ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 86,360 points • 6,052 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
 • 86,360 points • 1,591 views
0 votes
1 answer

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 8,371 views
0 votes
1 answer

Why does this VBA Macro that copies and paste range into email in the wrong order?

When a message body is created by ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,967 views
0 votes
1 answer

How to detect value in change in excel using python?

You might keep a txt file with ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,824 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,000 points • 1,425 views
0 votes
1 answer

Validation of postcodes in several countries

When a value is made up entirely ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,328 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
 • 86,360 points • 1,536 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
 • 86,360 points • 1,531 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,000 points • 1,488 views
0 votes
1 answer

Filter only certain columns in Excel Pivot Tables

Pivot Tables are mainly designed to create aggregated data from ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,313 views
0 votes
1 answer

Python: How do I get multiple results in the same excel sheet?

Try this: fmin = lambda x: abs(x).min() fmax = ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,743 views
0 votes
1 answer

VBA how to calculate depth of items in excel, simliar to a BOM system

Add on the sheet an ActiveX Microsoft ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,777 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,213 views
0 votes
1 answer

How do ask ChatGPT with API from Excel macros (vba)?

A few things that will help. Don't ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 3,541 views
0 votes
1 answer

Close One Tab within Chrome via VBA

Sod's law worked it out within a ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 3,580 views
0 votes
1 answer

Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,721 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
 • 86,360 points • 1,481 views
0 votes
1 answer

VBA SharePoint macro

I believe you are attempting to open ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 3,377 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
 • 86,360 points • 1,606 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,000 points • 1,563 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,000 points • 1,563 views
0 votes
0 answers

asking about career advice

Hey, I completed my graduation in civil ...READ MORE

Apr 21, 2023 in Others by anonymous
edited Mar 5, 2025 • 523 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,000 points • 1,322 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,000 points • 1,313 views
0 votes
1 answer

How do I stop python from appending data to the same row in excel?

There is no indication in your code ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,656 views
0 votes
1 answer

Excel formatting: show percent value without percent sign

You can change how it appears while ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 86,360 points • 5,969 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,000 points • 1,521 views
0 votes
1 answer

Choosing a random text value from a list

Try this: =CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1, ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,260 views
0 votes
1 answer

TextEffect to TextFrame Adjustment (Mismatch)

Delete the original shape and then replace, ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,631 views
0 votes
1 answer

Reading Excel file Date/time Incorrectly

Use dateutil.parser. Example usage: import dateutil.parser as parser parser.parse("2021-04-04 00:00:00 1900-01-01 ...READ MORE

Mar 20, 2023 in Others by narikkadan
 • 86,360 points • 1,841 views
0 votes
1 answer

Excel - allow result to change if value is greater than

Try this: =IF(OR(C9>1200,D9>1200),E9*E$4,E9*E$3) It will determine if C9 or ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,236 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

We utilise MID to parse the string. ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 3,436 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
 • 86,360 points • 1,392 views
0 votes
1 answer

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,513 views
0 votes
1 answer

User form to print an array of sheets

It appears that when a UserForm is ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,206 views
0 votes
1 answer

How can I set a number for a public variable at userforms in excel?

Try: Public b As Integer Private Sub exa_Click() b = ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,546 views
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Here's how Excel functions. Not a bug, ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,543 views
0 votes
1 answer

VBA & Ascii Art

This is possible with a two-dimensional array. ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,582 views
0 votes
1 answer

Differences between git pull origin master & git pull origin/master

To answer your question, the git pull ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 19,133 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
 • 86,360 points • 1,488 views
0 votes
1 answer

Substring/Find last occurence of "/" and output everything to the right of it

Use TEXTAFTER() Function: =TEXTAFTER(B2,"/",-1) READ MORE

Mar 23, 2023 in Others by narikkadan
 • 86,360 points • 1,654 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,000 points • 1,197 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,000 points • 1,283 views
0 votes
1 answer

Export multiple worksheets without formula with the ability to select exact sheets and location

Try this: Sub ExportSheets() Dim ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,585 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,000 points • 1,267 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,561 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.