Questions by Kithuzzz

0 votes
1 answer

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

Mar 30, 2023 in Others • 1,524 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 • 1,380 views
0 votes
1 answer

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

Mar 30, 2023 in Others • 3,321 views
0 votes
1 answer

Python write a list to multiple columns in excel

Mar 30, 2023 in Others • 6,931 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 • 1,609 views
0 votes
1 answer

How to find all internal ranges in a specified range

Mar 27, 2023 in Others • 1,645 views
0 votes
1 answer

Convert Yaml to excel in Python

Mar 27, 2023 in Others • 2,490 views
0 votes
1 answer

Runtime Error while dynamically adding controls to a userform

Mar 27, 2023 in Others • 1,958 views
0 votes
1 answer

Mapping cells between between two ranges

Mar 27, 2023 in Others • 2,039 views
0 votes
1 answer

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

Mar 27, 2023 in Others • 1,466 views
0 votes
1 answer

Count unique matches between two rows in Excel

Mar 27, 2023 in Others • 1,608 views
0 votes
1 answer

Highlight duplicates with only 2 colors

Mar 27, 2023 in Others • 1,487 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 • 1,715 views
0 votes
1 answer

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

Mar 25, 2023 in Others • 1,231 views
0 votes
1 answer

TextEffect to TextFrame Adjustment (Mismatch)

Mar 25, 2023 in Others • 1,776 views
0 votes
1 answer

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

Mar 25, 2023 in Others • 1,911 views
0 votes
1 answer

Run time error 3343 unrecognized database format

Mar 25, 2023 in Others • 1,595 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 • 1,914 views
0 votes
1 answer

Extracting tabular data from multiple .xlsx files with inconsistent structures

Mar 25, 2023 in Others • 2,143 views
0 votes
1 answer

VBA & Ascii Art

Mar 25, 2023 in Others • 1,741 views
0 votes
1 answer

VBA Macro to add a relative reference column

Mar 25, 2023 in Others • 1,506 views
0 votes
1 answer

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

Mar 25, 2023 in Others • 1,866 views
0 votes
1 answer

Open Workbook on new instance

Mar 23, 2023 in Others • 1,608 views
0 votes
1 answer

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

Mar 23, 2023 in Others • 1,725 views
0 votes
1 answer

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

Mar 23, 2023 in Others • 1,793 views
0 votes
1 answer

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

Mar 23, 2023 in Others • 3,649 views
0 votes
1 answer

VBA to create a dynamic rolling list of names

Mar 23, 2023 in Others • 1,458 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 • 4,156 views
0 votes
1 answer

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

Mar 23, 2023 in Others • 1,318 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

Mar 23, 2023 in Others • 1,494 views
0 votes
1 answer

Excel, unable to update count

Mar 23, 2023 in Others • 1,676 views
0 votes
1 answer

Reading Excel file Date/time Incorrectly

Mar 20, 2023 in Others • 1,985 views
0 votes
1 answer

Return value if scores contain value form min and Max column

Mar 20, 2023 in Others • 1,452 views
0 votes
1 answer

Divide data and copy other cells in google sheets or excel

Mar 20, 2023 in Others • 1,395 views
0 votes
1 answer

IF statement for a tax sheet does not work

Mar 20, 2023 in Others • 1,604 views
0 votes
1 answer

VBA Macro Iteration

Mar 20, 2023 in Others • 1,839 views
0 votes
1 answer

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

Mar 20, 2023 in Others • 1,729 views
0 votes
1 answer

Loop through files using "" instead of Dir

Mar 20, 2023 in Others • 1,433 views
0 votes
1 answer

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

Mar 20, 2023 in Others • 1,309 views
0 votes
1 answer

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

Mar 20, 2023 in Others • 1,506 views
0 votes
1 answer

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

Feb 27, 2023 in Others • 2,908 views
0 votes
0 answers

Input Box Date Validation

Feb 27, 2023 in Others • 1,221 views
0 votes
1 answer

VBA Comment Format

Feb 27, 2023 in Others • 1,609 views
0 votes
1 answer

VBA: Do While Loop does not want to looping

Feb 27, 2023 in Others • 1,874 views
0 votes
1 answer

How to read excel file column by column

Feb 27, 2023 in Others • 1,450 views
0 votes
1 answer

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others • 2,241 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 • 2,218 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 • 2,308 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 • 2,052 views
0 votes
1 answer

GetObject(xxx).Application not working/recognizing open files

Feb 24, 2023 in Others • 2,532 views
Page:
"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.