Recent questions tagged excel

0 votes
1 answer

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 3,228 views
0 votes
1 answer

How to export print result to excel using python (for loop)

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 7,985 views
0 votes
1 answer

How can I measure time more precisely in VBA?

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 1,383 views
0 votes
1 answer

Need help to delete rows in VBA

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 1,281 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 4,692 views
0 votes
1 answer

Using createobject("Excel.application") to create excel 2007 application

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 2,279 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 2,655 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 2,591 views
0 votes
1 answer

VBA Loop To Import Changing File Names

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 2,181 views
0 votes
1 answer

Delimiters in Excel VBA Regex Patterns, filter something but not others

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,869 views
0 votes
1 answer

Export ListBox Data to Sheet range

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 3,230 views
0 votes
1 answer

Crawling through multiple excel files, match and copy data to master file

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,973 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,626 views
0 votes
1 answer

Look up value in dictionary and put the value in cell - Excel

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,626 views
0 votes
1 answer

Excel Power Query Group by

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,772 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,760 views
0 votes
1 answer

Excel VBA - Using Error Traps where Another Routine is Called

Jan 12, 2023 in Others by Kithuzzz
 • 38,000 points • 1,263 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

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

Weird Date change when copying a Worksheet into a new workbook

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

Find the serial number with criteria

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

Trying to apply Solver with Macros

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

How to improve VBA Code for Monte Carlo Simulation?

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

Textjoin with adjacent headers and rows with a twist

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

Excel: How to analyze data in a table that contains multivalue cells

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

Excel Conditional Formating to find numbers a cell with text

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

Why is my code grabbing row number from the wrong Excel sheet?

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

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

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

How to make lambda function working on excel365?

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,549 views
0 votes
1 answer

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

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 5,718 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 2,223 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,482 views
0 votes
1 answer

VBA code for dragging down contents of a cell

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 2,797 views
0 votes
1 answer

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

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 2,008 views
0 votes
1 answer

Map-like array function in Excel?

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,420 views
0 votes
1 answer

Excel pace formula gives incorrect answers

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 10,375 views
0 votes
1 answer

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

Jan 9, 2023 in Others by Kithuzzz
 • 38,000 points • 1,510 views
0 votes
1 answer

Delete all rows in filtered range Except first filtered row in excel VBA

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 4,502 views
0 votes
1 answer

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 2,346 views
0 votes
1 answer

How to hide rows based on dropdownlist?

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 2,062 views
0 votes
1 answer

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,841 views
0 votes
1 answer

A value which should be judged by a scale gets bad judgement sometimes

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,366 views
0 votes
1 answer

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

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 5,935 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,711 views
0 votes
1 answer

Date format conversion in Excel

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,664 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,622 views
0 votes
1 answer

Excel - Find the Max for Total revenue just for year 1

Jan 8, 2023 in Others by Kithuzzz
 • 38,000 points • 1,311 views
0 votes
1 answer

Trying to make my VBA run a little bit faster

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

How to merge two Tables and Add the amount at the same time?

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

How can find location of value in a square using excel

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

Opening large Workbooks in excel

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