Trending questions in Others

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,309 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,004 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,257 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,288 views
0 votes
1 answer

Bloomberg excel add-in BDH

Change an override Fill=P to, for instance, ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 86,360 points • 8,632 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,067 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,065 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,147 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,270 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,265 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,653 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,112 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,329 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,492 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,443 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,056 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,439 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,306 views
0 votes
1 answer

VBA How to extract the date and time of arrival of a answered email

Use MailItem.ReceivedTime property. I hope this helps you ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 86,360 points • 4,654 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,413 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,225 views
0 votes
1 answer

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 86,360 points • 8,017 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,403 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,274 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,001 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,295 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 • 972 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,355 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,207 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,080 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,245 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 4,611 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 • 981 views
0 votes
1 answer

Processing in vba

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

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,007 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,043 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 • 2,980 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,000 points • 1,162 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,237 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,225 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 • 2,991 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
 • 86,360 points • 961 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,474 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
 • 86,360 points • 959 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
 • 86,360 points • 1,170 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 • 18,803 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,157 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,327 views
0 votes
1 answer

Run time error 3343 unrecognized database format

Try using ADODB. Option Explicit Sub Export1line() ...READ MORE

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

VBA - Build an Array by Looping Through Another Array with Specific Criteria

Please attempt the next option. It is ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 86,360 points • 1,318 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,000 points • 975 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.