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 ... 11

Title	Δ
Changing properties of Excel for only ThisWorkbook but not other wo...	0.00
Excel VBA random string	0.00
Retrieving a List of Declared Constants?	+0.35
excel count if text values separated by comma	-1.49
Find the last occurrence of a value in a row excel	0.00
Building an array by skipping blank values	-1.30
Is it possible to get the name of a range that the active cell is in?	-0.77
How to set the value of a cell based on several other cells in Excel	0.00
How do I capitalize the first letter in every paragraph when there...	-1.66
Excel hardcode, subnet value that increments	+0.34
Issue when indexing named range with more than one section	0.00
Transpose a dynamic range data from vertical to horizontal format	+1.27
Identify cells without array formulas	0.00
Flagging '0.0' value	-2.45
Remove duplicate rows from listbox	0.00
Prompt the file name from the cell value	0.00
Replace cells containing zero with blank	+1.60
Clarification of parameters in an INDEX MATCH formula	+1.46
Simple VBA to Delete Row	-0.24
Convert escaped HTML to raw HTML	0.00
MATCH function not working	0.00
Formula returning Column A value for row containing MIN value of a...	0.00
Calculate range and exclude some text	0.00
Using IF / ELSE or ISBLANK function on cells that contain functions	+0.34
Index number/worksheet name confusion with variables when worksheet...	0.00
Making 'For Each' loop faster	+1.68
Count cells with shown data (ignores hidden values)	0.00
Populating a temporary array to avoid using Preserve on a dynamic,...	+1.50
Display Value in cell Y based on greater than, less than of cell X	+0.35
VBA: Finding max value of sum among continuous numbers	-0.38
How can I convert these inelegant formulae into VBA?	-1.53
How do I write to a cell address which is defined as a variable?	+0.36
Set a range to a formula then to a value	-1.88
Replace RC Formula Value with Variable VBA	0.00
Represent a list in matrix format	+1.40
How to add each item 23 attribute	+1.07
Automated, selective copying/pasting cells based on multiple string...	+1.41
Convert 'yyyymmdd hhmmss' to 'mm/dd/yy hh:mm'	+0.36
I need to be able to match a date and store number to an array that...	0.00
Highlight cells which aren't formatted as 13 digit text...how?	0.00
Efficiently copy and paste block of cells based on multiple criteria	0.00
Printing entries in a Collection	-0.66
Formula returning Column A value for row containing MAX value of a...	+1.42
Repeat values every 5th space	0.00
Changing Formula Range with Another Variable in Excel	0.00
Removing few characters from a string using wild card	-1.63
Move specific row to other sheet	0.00
How to extract only name initials from a complex string in Excel us...	-2.37
Programmatically Position excel ListBox	0.00
How to identify the last data point in a row?	+1.70