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,294 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,043 views
0 votes
1 answer

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

Mar 30, 2023 in Others • 2,716 views
0 votes
1 answer

Python write a list to multiple columns in excel

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

How to find all internal ranges in a specified range

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

Convert Yaml to excel in Python

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

Runtime Error while dynamically adding controls to a userform

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

Mapping cells between between two ranges

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

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

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

Count unique matches between two rows in Excel

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

Highlight duplicates with only 2 colors

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

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

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

TextEffect to TextFrame Adjustment (Mismatch)

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

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

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

Run time error 3343 unrecognized database format

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

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

VBA & Ascii Art

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

VBA Macro to add a relative reference column

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

Open Workbook on new instance

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

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

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

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

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

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

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

VBA to create a dynamic rolling list of names

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

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

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

Merging duplicate cells into a new column with VBA

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

Excel, unable to update count

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

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

Divide data and copy other cells in google sheets or excel

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

IF statement for a tax sheet does not work

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

VBA Macro Iteration

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

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

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

Loop through files using "" instead of Dir

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

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

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

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

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

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

Input Box Date Validation

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

VBA Comment Format

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

VBA: Do While Loop does not want to looping

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

How to read excel file column by column

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

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others • 1,767 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,810 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 • 1,842 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,469 views
0 votes
1 answer

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

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