Questions by narikkadan

0 votes
1 answer

VBA runtime error 1004 when copy and pasting

Feb 23, 2023 in Others • 3,753 views
0 votes
1 answer

How to calculate median of unsorted values

Feb 23, 2023 in Others • 1,799 views
0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

Feb 23, 2023 in Others • 1,832 views
0 votes
1 answer

Finding the minimum values from different columns according to the criteria and multiplying by another column

Feb 23, 2023 in Others • 2,032 views
0 votes
1 answer

Excel Count unique values beetween 2 columns

Feb 23, 2023 in Others • 1,760 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Feb 23, 2023 in Others • 3,844 views
0 votes
1 answer

My VBA Addin creates a custom ribbon tab, but should only be visible for intended workbooks

Feb 23, 2023 in Others • 3,821 views
0 votes
1 answer

Excel Script keeps giving error "Range merge: You cannot perform the requested operation."

Feb 23, 2023 in Others • 3,042 views
0 votes
1 answer

Get column index from table header in excel

Feb 23, 2023 in Others • 2,030 views
0 votes
1 answer

VBA Copy/Paste a Range in Next Available Column Then Add a Single Day to One of the Newly Pasted Cells Repeatedly

Feb 20, 2023 in Others • 2,563 views
0 votes
1 answer

Django upload and process multiple files failing with libreoffice

Feb 20, 2023 in Others • 2,670 views
0 votes
1 answer

Fill a FileDialog from another macro

Feb 20, 2023 in Others • 1,516 views
0 votes
1 answer

TODAY() function not working in Microsoft Excel

Feb 20, 2023 in Others • 3,288 views
0 votes
1 answer

Put text body above the pasted range

Feb 20, 2023 in Others • 1,371 views
0 votes
1 answer

Excel - count if multiple words are in a cell

Feb 20, 2023 in Others • 1,652 views
0 votes
1 answer

Create numbered XML nodes, set attributes when creating XML node

Feb 20, 2023 in Others • 2,596 views
0 votes
1 answer

Confused on VBA copy destination

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

Tableau For Loop a String

Feb 20, 2023 in Others • 1,690 views
0 votes
1 answer

Excel VBA select range

Feb 16, 2023 in Others • 2,176 views
0 votes
1 answer

How to reference an excel sheet by variable

Feb 16, 2023 in Others • 1,855 views
0 votes
1 answer

Function to filter excel table data in to a new dataset based on value defined in another table

Feb 16, 2023 in Others • 2,432 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Feb 16, 2023 in Others • 1,540 views
0 votes
1 answer

VLOOKUP to find weeknumber

Feb 16, 2023 in Others • 2,148 views
0 votes
1 answer

Excel number formatting thousands is not working

Feb 16, 2023 in Others • 19,821 views
0 votes
1 answer

Power Query - Find matching contents from multiple other tables

Feb 16, 2023 in Others • 2,043 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Feb 16, 2023 in Others • 1,561 views
0 votes
1 answer

Excel VBA: how to find a description from an AD-group

Feb 16, 2023 in Others • 2,485 views
0 votes
1 answer

Modifying Excel document using python and openpyxl

Feb 16, 2023 in Others • 2,728 views
0 votes
1 answer

Excel VBA: Obtain the Column and Row of current element in "For Each" loop

Feb 14, 2023 in Others • 2,822 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Feb 14, 2023 in Others • 2,527 views
0 votes
1 answer

Excel VBA creating a new Outlook appointment results in a cancelled appointment

Feb 14, 2023 in Others • 2,374 views
0 votes
1 answer

Asset Write off calculation Automation

Feb 14, 2023 in Others • 1,270 views
0 votes
1 answer

Appreciate any suggestion

Feb 14, 2023 in Others • 1,530 views
0 votes
1 answer

Struggling to move object based on the value to respect sheet

Feb 14, 2023 in Others • 1,876 views
0 votes
1 answer

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

Feb 14, 2023 in Others • 2,340 views
0 votes
1 answer

Excel: Get text between two characters

Feb 14, 2023 in Others • 1,696 views
0 votes
1 answer

Macro /excel date format change

Feb 14, 2023 in Others • 1,675 views
0 votes
1 answer

VBA SharePoint macro

Feb 14, 2023 in Others • 3,719 views
0 votes
1 answer

Type mismatch error when referring to array element by location vba

Feb 11, 2023 in Others • 3,770 views
0 votes
1 answer

How do ask ChatGPT with API from Excel macros (vba)?

Feb 11, 2023 in Others • 3,860 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

Feb 11, 2023 in Others • 2,575 views
0 votes
1 answer

Ordering data in python or excel

Feb 11, 2023 in Others • 1,565 views
0 votes
1 answer

Exclude worksheets from loop with a list

Feb 11, 2023 in Others • 1,497 views
0 votes
1 answer

Sort numeric values VBA

Feb 11, 2023 in Others • 1,646 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Feb 11, 2023 in Others • 1,694 views
0 votes
1 answer

Lock and unlock cells in Excel based on color in all worksheets

Feb 11, 2023 in Others • 2,213 views
0 votes
1 answer

How to query a matrix for multiple values and receive value

Feb 11, 2023 in Others • 1,977 views
0 votes
1 answer

VBA to protect and unprotect in given range in sheet

Nov 24, 2022 in Others • 4,607 views
0 votes
0 answers

Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?

Sep 5, 2022 in Database • 3,071 views
0 votes
0 answers

MySQL Multiple Joins in one query?

Sep 4, 2022 in Database • 1,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.