Skip to main content
rotabor's user avatar
rotabor's user avatar
rotabor's user avatar
rotabor
Senior Industrial Process Control Systems Service Engineer
  • Member for 3 years, 4 months
  • Last seen this week
Profile Activity

496 Answers

Score Activity Newest
5 votes
Accepted

RANK formula gives incorrect result when values exist more than one

5 votes

Remember old string during loop

5 votes
Accepted

How to avoid code duplication in Windows Forms C#?

4 votes
Accepted

How to create an excel formula using LET and other dynamic array functions which gives an calculated output of each column?

4 votes
Accepted

How to sample a range of Excel values (i.e. one column) to pick 100 random values

4 votes

Range() using a long string variable

4 votes

Can Lambda functions use text references passed from the ByCol function?

4 votes

Excel VBA range does not return range

3 votes

Count the value of the current stock in excel

3 votes

Transpose with flexible range based on input in a cell

3 votes
Accepted

How to assign cell values to an array with named arguments

3 votes

How can I apply a series of formulas across an entire workbook/file

3 votes
Accepted

2D Non-Jagged Arrays

3 votes
Accepted

Why does comparing dates (using 'IF' function) return unexpected outcome?

3 votes
Accepted

Is there a way to search a cell using a key word and add up values on that row?

3 votes
Accepted

Excel VBA - Having issues while Using Range Function with multiple variables in Embedded Charts

3 votes
Accepted

I am getting a Value error when calling a VBA function in Excel

3 votes

Counting the number of times a date is entered but ignoring the time

3 votes
Accepted

Adding Record to table with Column names and arrays

3 votes

Looping within 4 columns to find an exact match of my array

3 votes
Accepted

Excel array formula that references previously calculated values within the array

3 votes
Accepted

XLOOKUP with RIGHT function

3 votes
Accepted

REPT function in Excel

3 votes

Excel return sum of variable date in row where criteria is met

3 votes

First the nth value in a table with a specific condition in Excel

3 votes
Accepted

How to import a range into a variant array in Excel VBA and sort using the sort method?

3 votes

How to use SEQUENCE formula in Excel data validation

2 votes
Accepted

C# Bitwise operations Generic class

2 votes

How to get one of each type returned from an EF Core query

2 votes
Accepted

Exporting Excel ranges on different tabs as a pdf in VBA

1
2 3 4 5
…
17