Questions by narikkadan

0 votes
1 answer

Change sheet tab color depending on CountA function result

Mar 28, 2023 in Others • 1,250 views
0 votes
1 answer

Another method to extract the last row containing data in a column

Mar 28, 2023 in Others • 1,965 views
0 votes
1 answer

Selenium extract data after </strong>

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

iCell.Value takes too long

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

How to create arrow buttons in Excel to scroll the table left and right?

Mar 26, 2023 in Others • 2,078 views
0 votes
1 answer

How can I set a number for a public variable at userforms in excel?

Mar 26, 2023 in Others • 1,662 views
0 votes
1 answer

Loop through each cell in a given range and change the value depending on value in a column in the same row

Mar 26, 2023 in Others • 2,074 views
0 votes
1 answer

ActiveSheet.Hyperlinks.Add don't show Text To Display

Mar 26, 2023 in Others • 1,687 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Mar 26, 2023 in Others • 2,226 views
0 votes
0 answers

Excel Formulas Limitations when compared to Excel VBA Power

Mar 26, 2023 in Others • 1,132 views
0 votes
1 answer

Extracting a Variable Number of Letters from a Formula using VBA Code

Mar 26, 2023 in Others • 1,615 views
0 votes
1 answer

How to assign assign condition using if statement and VLOOKUP?

Mar 26, 2023 in Others • 1,520 views
0 votes
1 answer

Select data that meet criteria from a table, adding it to a combobox in userform VBA Excel

Mar 26, 2023 in Others • 2,617 views
0 votes
1 answer

VBA - Build a Two-Column Array By Looping Through one Array with a Specific Criteria and Selecting From Another Array

Mar 24, 2023 in Others • 1,445 views
0 votes
1 answer

VBA Regular Expression to return ALL matching patterns

Mar 24, 2023 in Others • 2,585 views
0 votes
1 answer

Macro VBA code failing to execute a section of the code without an error

Mar 24, 2023 in Others • 2,180 views
0 votes
1 answer

Open Existing PowerPoint via VBA

Mar 24, 2023 in Others • 2,667 views
0 votes
1 answer

VBA how to calculate depth of items in excel, simliar to a BOM system

Mar 24, 2023 in Others • 1,941 views
0 votes
1 answer

Issues with NULL in an added and custom column

Mar 24, 2023 in Others • 1,668 views
0 votes
1 answer

Why does difference between same dates shows a difference of 1 month in Excel?

Mar 24, 2023 in Others • 1,663 views
0 votes
1 answer

Export multiple worksheets without formula with the ability to select exact sheets and location

Mar 24, 2023 in Others • 1,753 views
0 votes
1 answer

How to detect value in change in excel using python?

Mar 24, 2023 in Others • 1,995 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Mar 24, 2023 in Others • 1,742 views
0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Mar 21, 2023 in Others • 3,417 views
0 votes
1 answer

How to read a txt with pandas, and correctly put it in a dataframe to be converted to excel

Mar 21, 2023 in Others • 4,069 views
0 votes
1 answer

Encrypting and securing sheets for users

Mar 21, 2023 in Others • 1,424 views
0 votes
1 answer

Why does this VBA Macro that copies and paste range into email in the wrong order?

Mar 21, 2023 in Others • 2,127 views
0 votes
1 answer

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Mar 21, 2023 in Others • 2,546 views
0 votes
1 answer

Count number of equal values in two rows in Excel

Mar 21, 2023 in Others • 1,730 views
0 votes
1 answer

Excel VBA code not running using F5 only F8

Mar 21, 2023 in Others • 1,743 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

Mar 21, 2023 in Others • 2,289 views
0 votes
1 answer

Microsoft Excel - slow to open

Mar 21, 2023 in Others • 1,360 views
0 votes
1 answer

VBA - Dynamic Variable Name in a Loop

Mar 19, 2023 in Others • 3,316 views
0 votes
1 answer

Use union with find

Mar 19, 2023 in Others • 1,536 views
0 votes
1 answer

VBA Excel get data from Access database Error

Mar 19, 2023 in Others • 1,803 views
0 votes
1 answer

VBA - Msgbox inside a Loop

Mar 19, 2023 in Others • 1,898 views
0 votes
1 answer

Runtime Error when trying to Loop Worksheets

Mar 19, 2023 in Others • 1,650 views
0 votes
1 answer

How to merge the Two Columns with two different Tables without getting duplicates in either of the resulting columns

Mar 19, 2023 in Others • 1,870 views
0 votes
1 answer

Filter date with time

Mar 19, 2023 in Others • 1,463 views
0 votes
1 answer

How to read an Excel CSV file in Python?

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

Copy data with filter applied using Excel VBA

Mar 19, 2023 in Others • 1,803 views
0 votes
1 answer

EXCEL - Is there a formula for TEXTSPLIT from 3 different rows into a sequencing of rows without data /text duplication?

Feb 26, 2023 in Others • 1,757 views
0 votes
1 answer

Dragging Down Skipping Rows

Feb 26, 2023 in Others • 1,603 views
0 votes
1 answer

How to calculate current streak of conditional number, and excluding blanks?

Feb 26, 2023 in Others • 1,451 views
0 votes
1 answer

How can I sum all the data in January example

Feb 26, 2023 in Others • 1,512 views
0 votes
1 answer

Cross sum from a number but cross sum should total to one digit

Feb 26, 2023 in Others • 1,550 views
0 votes
1 answer

Reference Excel sheet number in an external workbook

Feb 26, 2023 in Others • 1,438 views
0 votes
1 answer

How to make an error flagging array in VBA and translate all array elements as a string message?

Feb 26, 2023 in Others • 1,594 views
0 votes
1 answer

Reshaping/Deduping long data to wide in R

Feb 26, 2023 in Others • 1,643 views
0 votes
1 answer

outputting a coloured excel file, python

Feb 26, 2023 in Others • 1,300 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.