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 ... 8 9 10 11

Title	Δ
Record active cell address in new sheet on button click	+3.85
Formula to return second to last number in a row	-0.13
Selecting part of a row dynamically for colouring cells	+3.92
excel vba formula for duplicate entries	+3.37
reference last column of worksheet	-1.40
Application.OnTime doesn't work with userform	0.00
alter function to count vbRed	0.00
Formula to get a ratio out of specific fields	0.00
Create new column in Excel based on previous column data	+3.48
MATCH-based Excel (2007) array formula not iterating over the desir...	0.00
VBA poker hands	+4.64
Using MIN/MAX in excel array formula	-2.27
Excel:Checking if a name appears in the last month within the same...	+4.10
Copy a cell unless it contains the same value as a previous cell	0.00
Dynamic Range Between Blank Rows in Excel	-1.18
updating values in excel column depending on two other columns bein...	-4.38
Excel Date calculation using todays date negative values	0.00
Exporting items in list box to range in Excel	0.00
Changing the format of excel turns file in to insane size	0.00
Excel Mix & Match Concatenate Columns	+0.11
Conditional Formatting on dates older than a month Excel	0.00
Populate next empty cell with value above plus 1 until all rows are...	+3.45
Clear collection object or retrieve last item	0.00
Run-time error '91': Object variable or With block variable...	0.00
Prevent re-sizing of charts when column and row dimensions are chan...	0.00
Generate a straight sequence of numbers depending on the lastrow	+1.63
Change data source of a list table in Excel 2010	0.00
Random Number within a range without repetition in VBA	+3.94
Excel DB connection: insert, update & delete?	+3.50
Adding a Trailing Twelve Months array feature to VBA code	0.00
Using or() within Index/Match?	-2.97
Create general validation using variables	0.00
VBA Go to the next filtered cell	+3.53
Using Excel cells as parameters to update a database	0.00
How to build a dynamic cell range output function using VBA	+3.84
VBA Plotting Graph and adjust point width	0.00
Excel VBA code to compare system date with date in the worksheet	0.00
Extract strings from one text cell in VBA	-0.30
Convert Time Values (In-Cell) to Minutes - Excel VBA	+3.93
Using Iferror function in excel	0.00
Excel VBA Combobox search for worksheet and display data table in a...	0.00
VBA: Splitting and Joining Arrays & Strings	0.00
vba- Case statements requiring to meet three conditions to execute	+4.08
Copying a worksheet in Excel 2013 using VBA to the end of the workb...	+3.71
SUMIF as a macro in Excel (VBA)	+1.16
The brute force method using VBA for solving an equation with nine...	+3.99
Progress Bar in Excel using VBA and userForms	0.00
Excel VBA Adding 1 hour to a date / time string	+2.05
How to parse this specific type of data in excel VBA?	+2.48
Excel - Define Named Range with Array Formula	0.00