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

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

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

Python write a list to multiple columns in excel

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

How to find all internal ranges in a specified range

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

Convert Yaml to excel in Python

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

Runtime Error while dynamically adding controls to a userform

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

Mapping cells between between two ranges

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

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

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

TextEffect to TextFrame Adjustment (Mismatch)

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

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

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

Run time error 3343 unrecognized database format

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

Extracting tabular data from multiple .xlsx files with inconsistent structures

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

VBA & Ascii Art

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

VBA Macro to add a relative reference column

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

VBA to create a dynamic rolling list of names

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

Excel, unable to update count

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

Reading Excel file Date/time Incorrectly

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

Return value if scores contain value form min and Max column

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

Divide data and copy other cells in google sheets or excel

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

IF statement for a tax sheet does not work

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

VBA Macro Iteration

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

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

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

Loop through files using "" instead of Dir

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

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

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

VBA Excel FormulaR1C1 "Application Defined or Object Defined Error"

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

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

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

Input Box Date Validation

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

VBA Comment Format

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

VBA: Do While Loop does not want to looping

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

How to read excel file column by column

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

Excel VBA Type Mismatch calling Private Sub from ListBox_Click

Feb 27, 2023 in Others • 1,937 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,999 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,003 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,669 views
0 votes
1 answer

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

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