Recent questions tagged excel

0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

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

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

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

How to detect value in change in excel using python?

Mar 24, 2023 in Others by narikkadan
 • 86,360 points • 1,749 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

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

Open Workbook on new instance

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

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

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

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

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

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

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

VBA to create a dynamic rolling list of names

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

VBA Loop to select then copy a range of cells based on value in column B

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

How do I change the format of an excel workbook from 'General' to 'Text'

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

Merging duplicate cells into a new column with VBA

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

Excel, unable to update count

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

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

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

How to read a txt with pandas, and correctly put it in a dataframe to be converted to excel

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

Encrypting and securing sheets for users

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

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

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

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Mar 21, 2023 in Others by narikkadan
 • 86,360 points • 2,225 views
0 votes
1 answer

Count number of equal values in two rows in Excel

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

Excel VBA code not running using F5 only F8

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

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

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

Microsoft Excel - slow to open

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

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

Divide data and copy other cells in google sheets or excel

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

IF statement for a tax sheet does not work

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

VBA Macro Iteration

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

Excel Date separate with =DAY(), =MONTH() and =YEAR()

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

Loop through files using "" instead of Dir

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

Delete table rows if time in column is >07:45

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

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

VBA - Dynamic Variable Name in a Loop

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

Use union with find

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

VBA Excel get data from Access database Error

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

VBA - Msgbox inside a Loop

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

Runtime Error when trying to Loop Worksheets

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

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

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

Filter date with time

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

How to read an Excel CSV file in Python?

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

Copy data with filter applied using Excel VBA

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

How do I adjust the size of the pasted image in Outlook email?

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 2,636 views
0 votes
0 answers

Input Box Date Validation

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,054 views
0 votes
1 answer

VBA Comment Format

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,384 views
0 votes
1 answer

VBA: Do While Loop does not want to looping

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,680 views
0 votes
1 answer

How to read excel file column by column

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,131 views
0 votes
1 answer

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,891 views
0 votes
1 answer

Why does WinHTTPRequest responseText return a different value to MsgBox than Debug.Print dynamic web pages

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,948 views
0 votes
1 answer

How to automatically get a specified range of data from Excel to XML in VBA

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,971 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Feb 27, 2023 in Others by Kithuzzz
 • 38,000 points • 1,615 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

Feb 26, 2023 in Others by narikkadan
 • 86,360 points • 1,490 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.