Recent questions tagged excel

0 votes
1 answer

How to turn a number recognized as string to number

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

Trying to redo my Export Button Function on my document

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

"Errno 13 Permission denied" while running Python Script through VBA

Mar 30, 2023 in Others by Kithuzzz
 • 38,000 points • 9,035 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

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

Power Query - Search an element of column A in entire column B

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

Look at first empty row after the first few rows of my excel are empty, but the rest are populated

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

How to change where an email is sent FROM in Excel VBA

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

Python write a list to multiple columns in excel

Mar 30, 2023 in Others by Kithuzzz
 • 38,000 points • 6,807 views
0 votes
1 answer

How to do the comand IF THEN in Excel

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

Is it possible to create a universal hyperlink in excel for windows and mac without programming

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

Why am I not being able to read the Excel sheet in my Jupyter Notebook

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

How do I build a loop into this TimeStamp VBA Code?

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

Is there a function in excel to automatically calculate age using date of birth?

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

Change sheet tab color depending on CountA function result

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

Another method to extract the last row containing data in a column

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

Selenium extract data after </strong>

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

iCell.Value takes too long

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

Excel - How do I round a date type to the next hour if it is more than one minute

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

How to find all internal ranges in a specified range

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

Convert Yaml to excel in Python

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

Runtime Error while dynamically adding controls to a userform

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

Mapping cells between between two ranges

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

See cell content instead of formula in formulabox in Excel using VBA

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

Count unique matches between two rows in Excel

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

Highlight duplicates with only 2 colors

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

Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

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

How to create arrow buttons in Excel to scroll the table left and right?

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

How can I set a number for a public variable at userforms in excel?

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

Loop through each cell in a given range and change the value depending on value in a column in the same row

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

ActiveSheet.Hyperlinks.Add don't show Text To Display

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

Combine Two Formulas in Separate Cells Into One Cell

Mar 26, 2023 in Others by narikkadan
 • 86,360 points • 2,095 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

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

Extracting a Variable Number of Letters from a Formula using VBA Code

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

How to assign assign condition using if statement and VLOOKUP?

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

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

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

Comparison operator with duration that may exceed 1 day with format h:mm

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

TextEffect to TextFrame Adjustment (Mismatch)

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

Python: How do I get multiple results in the same excel sheet?

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

Run time error 3343 unrecognized database format

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

Is there a way to produce a sum according to date/time stamp values of another column on excel?

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

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

VBA & Ascii Art

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

VBA Macro to add a relative reference column

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

How do I stop python from appending data to the same row in excel?

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

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

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

VBA Regular Expression to return ALL matching patterns

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

Macro VBA code failing to execute a section of the code without an error

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

Open Existing PowerPoint via VBA

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

VBA how to calculate depth of items in excel, simliar to a BOM system

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

Issues with NULL in an added and custom column

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