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,433 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,249 views
0 votes
1 answer

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

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

Python write a list to multiple columns in excel

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

How to find all internal ranges in a specified range

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

Convert Yaml to excel in Python

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

Runtime Error while dynamically adding controls to a userform

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

Mapping cells between between two ranges

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

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

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

Count unique matches between two rows in Excel

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

Highlight duplicates with only 2 colors

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

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

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

TextEffect to TextFrame Adjustment (Mismatch)

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

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

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

Run time error 3343 unrecognized database format

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

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

VBA & Ascii Art

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

VBA Macro to add a relative reference column

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

Open Workbook on new instance

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

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

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

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

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

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

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

VBA to create a dynamic rolling list of names

Mar 23, 2023 in Others • 1,354 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,011 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,212 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

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

Excel, unable to update count

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

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

Divide data and copy other cells in google sheets or excel

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

IF statement for a tax sheet does not work

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

VBA Macro Iteration

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

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

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

Loop through files using "" instead of Dir

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

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

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

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

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

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

Input Box Date Validation

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

VBA Comment Format

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

VBA: Do While Loop does not want to looping

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

How to read excel file column by column

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

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others • 2,091 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,122 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,132 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 • 1,872 views
0 votes
1 answer

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

Feb 24, 2023 in Others • 2,446 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.