StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

Excel Hero

Rating
1610.32 (1,391st)

Reputation
10,663 (14,157th)

Page: 1 2 3 4 5 6 ... 11

Title	Δ
Adding a Column of Data Table if Rows Match	0.00
Where is the Excel Object Library file	0.00
excel error 424 object required when calling sub	+0.41
Filter a column and select the last used row	-0.33
Return value based on earliest date value within set	-2.42
Exclude headers from calculation	0.00
Excel function that copies rows if they fall within the range of 2...	+0.39
Look up/search one of three criteria and return appropriate value	+0.97
How to get value of child element from json data directly in VBA	+1.58
Run time error 438, excel VBA Macros - AutoFilter	+0.99
unable to ignore date while calculating time difference	-2.40
Need to put multiple values from VBA to cells using loop/for	+0.34
Counting rows with criteria and not counting the same row more than...	+1.02
Excel Formula (if, sumproduct...)	+0.37
Excel Macro to Change Active Cell	0.00
Detect user initiated copy	+0.37
Looping the whole cells to change a specific formula issue	+0.36
trying to understand ms excel formula	0.00
Copy Range to Named Range in different Sheets	0.00
Populating a combobox on a userform from a range of cells	0.00
Using LARGE with AVERAGEIFS	0.00
Type mismatch error using 'AdvanceFilter'	0.00
'.Find'/'.FindNext' finding same cell repeatedly or...	+0.95
Cleaning a list of URLs	0.00
How to code Excel VBA equivalent of INDIRECT function?	+0.37
I want to make this code to work for two variables it only copies d...	+0.40
Method Out of Range error	-0.36
Changing text inside of shapes	0.00
Inserting a formula containing an ampersand into a cell	+0.25
Next without for	0.00
Create charts using dynamic ranges	0.00
SUMIFS for multiple criteria	0.00
VBA: Protection.AllowEditRanges with dynamic range	0.00
Using excel find all possible combinations in five columns	+0.37
Reference a statement from one subroutine in another	0.00
"Ambiguous Name Detected"	0.00
Marking an area with a double 'For' loop	0.00
Case-Insensitive String Comparison	-0.15
INDEX MATCH array formula for 1M rows	+0.37
View names of controls in worksheet	0.00
float precision visual basic	+0.36
Simple code to calculate "time to expiration" for call op...	-1.93
SUMPRODUCT and WEEKDAY ignore #VALUE error but keep values	-0.30
Excel 365 Print Preview	0.00
Refactor two sub procedures into one and pass parameters as argument	0.00
Filtering mulit-sheet data document with use of advanced filter vba	0.00
Copy a range of cells from one sheet and insert into next empty row	0.00
Making my VBA Code update automatically when data is changed	+1.00
Skip any NA values and take average	+1.54
Boolean, True & True & True coming in as False?	+0.36