Trending questions in Others

0 votes
1 answer

Embed picture in outlook mail body excel vba

The image needs to be added and ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 7,969 views
0 votes
0 answers

How to check if DynamoDB table exists?

I'm a new user in boto3 and ...READ MORE

Mar 14, 2022 in Others by Edureka
 • 13,690 points • 3,460 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 • 10,599 views
0 votes
0 answers

if cell "A" is mentioned as "vacant" then automatically cell "B" "C" "D" should be mentioned as "Vacant"

Hi, I am trying to get a solution ...READ MORE

May 31, 2023 in Others by Sulal
edited Mar 5, 2025 • 539 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 5,560 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
 • 86,360 points • 3,165 views
0 votes
1 answer

How to programmatically get the values of a spilled Excel range in VBA?

By using the Text property, I was ...READ MORE

Mar 23, 2023 in Others by narikkadan
 • 86,360 points • 3,434 views
0 votes
1 answer

VBA Help to find a column based on header value and cupy it to an other worksheet

You can break out the "copy column ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 5,776 views
0 votes
1 answer

Return empty cell from formula in Excel

There is no way to do this ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 86,360 points • 8,615 views
0 votes
0 answers

How to delete account?

i want to delete my account from ...READ MORE

May 26, 2023 in Others by Edureka
edited Mar 5, 2025 • 573 views
0 votes
0 answers

im facing the error in my yoast plugin that im not able to edit the seo title focus key phrase and meta description

im facing the error in my yoast ...READ MORE

May 25, 2023 in Others by anonymous
edited Mar 5, 2025 • 571 views
0 votes
1 answer

VBA - Split table rows based on a column value

Create Type-Specific Worksheets in Excel using VBA Description This ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 2,615 views
0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

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

Two different fonts in one cell using excel vba

Public Sub add_degree_symbol() ActiveCell.Value = ...READ MORE

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

Python: Converting Datetime into an integer

Try this: import datetime current_date = datetime.datetime.now() print("String Format of ...READ MORE

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

VBA - Dynamic Variable Name in a Loop

Set the array values with: Dim i as ...READ MORE

Mar 19, 2023 in Others by Kithuzzz
 • 38,000 points • 3,170 views
0 votes
0 answers

ExcelDataReader, can't read "html-format" file

I have the following code: ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 2,039 views
+1 vote
1 answer

ng is not recognized as an internal or external command

I solved this problem in accordance with ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 20,258 views
0 votes
0 answers

Copying values from multiple excel files to a single one with python

I want to replicate the values from ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,989 views
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,000 points • 2,323 views
0 votes
0 answers

How do I use text as reference in EXCEL

How can I reference one text-based cell ...READ MORE

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

Plot multiple datasets on the same chart with VBA

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

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 2,127 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,000 points • 2,257 views
0 votes
1 answer

PHPExcel file cannot open file because the file format or file extension is not valid

Just change the code to this: // Save Excel ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 7,805 views
0 votes
1 answer

Excel not closing using the COM in Python

There's a lot of superfluous assignment and ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 5,152 views
0 votes
0 answers

List files in specified directory without subdirectories

How can I only go through files ...READ MORE

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

How to get subscript into formulas text string

Convert Digits To Subscript (H₂SO₄) Excel Formula Improvement ...READ MORE

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

VBA Check to see if file is open before reopening a second file

You could replace the line: Set pre = ...READ MORE

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

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Fill Combo Box With Matches Sub GetSourceAcc() ...READ MORE

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

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 2,529 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
 • 86,360 points • 2,177 views
0 votes
1 answer

How to run Macro when press enter automatically and paste in different cell

A Worksheet Change: Keep Record of Each ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,775 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
 • 86,360 points • 2,374 views
0 votes
1 answer

Excel worksheet multi-criteria function (like Index-Match array) to fetch last value of an item, looking up by item name and date

Use: =SUMIFS(C:C,B:B,E12,A:A,MAXIFS(A:A,B:B,E12)) It will return the value at the ...READ MORE

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

Uipath(RPA) : read data from the PDF file and write to Excel file

is there any video recording to enable ...READ MORE

Jul 6, 2023 in Others by Santhosh
edited Mar 5, 2025 • 3,596 views
0 votes
1 answer

Split the column cell value of location in 3 different columns

If the Location column has always the same pattern, ...READ MORE

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

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 86,360 points • 9,946 views
0 votes
1 answer

VBA Regular Expression to return ALL matching patterns

You have set the global to false, ...READ MORE

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

Why is my excel calculation bringing back a "value" other than zero?

Column D's formula should be changed so ...READ MORE

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

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

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

Excel: importing data from another Excel file using VBA

Refer to the file variables folderName and ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,790 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
 • 86,360 points • 2,017 views
0 votes
1 answer

Copying an existing row which also copies the checkbox with its code

You can make a new checkbox object ...READ MORE

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

Filter a list by using another list in PowerQuery M code

Try this: let columnNames= {"E ...READ MORE

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

Copying only one column of Userform ListBox data to single cell in separate spreadsheet with commas separating data

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

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

Not Like has no effect while looping an Array

you can add parentheses instead... mixing an ...READ MORE

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

Combing data from multiple workbooks into a single master workbook using power query

PowerQuery would scan the contents of all ...READ MORE

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

Error Trying to Display The Names of All Excel Data Models in a Workbook

It is necessary to list ThisWorkbook.model. Not ...READ MORE

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

Count Function for identifying the Unique values in Excel

If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE

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

Excel VBA SQL Query on not saved Workbook

What can I do to get the ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,678 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.