Trending questions in Others

0 votes
1 answer

Way to run Excel macros from command line or batch file?

Solution Open the workbook and run the macro ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 8,465 views
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,034 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,099 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 • 2,380 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 • 2,688 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 • 1,965 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 • 1,719 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 • 2,657 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,625 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,618 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 • 2,373 views
0 votes
1 answer

Add a correct format date in Excel file with Python openpyxl

Use just datetime.fromisoformat(row['Date']) but I didn't have ...READ MORE

Feb 9, 2023 in Others by narikkadan
 • 86,360 points • 4,187 views
0 votes
1 answer

Degree of multiprogramming definition

In a multiprogramming-capable system, the jobs which ...READ MORE

Feb 11, 2022 in Others by Soham
 • 9,730 points • 19,839 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 • 1,543 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 • 1,757 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,575 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,401 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 • 1,991 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,342 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,411 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 • 1,535 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 • 1,611 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 • 1,679 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 • 4,518 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,406 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 • 1,567 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 • 1,649 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,271 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,000 points • 1,569 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 • 1,608 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 • 1,940 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,336 views
0 votes
1 answer

Document changes in a graph excel

To be able to trace changes, the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,203 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,320 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,223 views
0 votes
1 answer

Arrange charts position in 3x5 order

Your code was nearly complete. I believed ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 1,222 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,181 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,093 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,342 views
0 votes
1 answer

excel not reading some data

When using the sep option in the ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,163 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,287 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 • 1,802 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,005 views
0 votes
1 answer

Find specific term in a text string and return that term in the previous column

Try: You can either hard code the ...READ MORE

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

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 86,360 points • 8,171 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,457 views
0 votes
1 answer

Conditional formatting based on value with offset

Apart than the altered cell, Conditional Formatting ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,360 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 • 7,190 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,099 views
0 votes
1 answer

Check if cell found is in column "AP"

Find the Last Cell in the Row ...READ MORE

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