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,353 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,149 views
0 votes
1 answer

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

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

Python write a list to multiple columns in excel

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

How to find all internal ranges in a specified range

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

Convert Yaml to excel in Python

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

Runtime Error while dynamically adding controls to a userform

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

Mapping cells between between two ranges

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

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

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

Count unique matches between two rows in Excel

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

Highlight duplicates with only 2 colors

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

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

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

TextEffect to TextFrame Adjustment (Mismatch)

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

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

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

Run time error 3343 unrecognized database format

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

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

VBA & Ascii Art

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

VBA Macro to add a relative reference column

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

Open Workbook on new instance

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

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

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

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

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

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

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

VBA to create a dynamic rolling list of names

Mar 23, 2023 in Others • 1,254 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 • 3,856 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,113 views
0 votes
1 answer

Merging duplicate cells into a new column with VBA

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

Excel, unable to update count

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

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

Divide data and copy other cells in google sheets or excel

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

IF statement for a tax sheet does not work

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

VBA Macro Iteration

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

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

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

Loop through files using "" instead of Dir

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

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

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

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

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

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

Input Box Date Validation

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

VBA Comment Format

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

VBA: Do While Loop does not want to looping

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

How to read excel file column by column

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

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others • 1,934 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 • 1,995 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,001 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,667 views
0 votes
1 answer

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

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