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 ... 4 5 6 7 8 ... 11
Title Δ
Refresh pivot tables but not external data source +0.39
Declare value based on date range without year +1.22
Combine a number with a date without showing 'year' as 1900 -0.44
Generate random numbers in a table 0.00
Decipher letters (e.g. AABC) to numbers (e.g. 3328) by formula, wit... +0.46
Assign new tab names without knowing previous tab names 0.00
For Each Worksheet in Workbook +1.22
How to split data (that contains a specific character) in a cell us... -0.01
Condensing an If Not Statement with multiple criteria 0.00
Populate the selected value from a drop down box into a separate wo... 0.00
Add a plus sign to every word in a cell using Excel or Google Sprea... 0.00
Copy from one workbook to another +0.39
Copy content from multiple .xls files into one file and file name i... 0.00
Convert number into date +1.74
Combining 2D (2-dimensional) arrays +0.21
Index Match if begins with +1.38
How can I post-process the data from an Excel web query when the qu... +0.40
How to enter data from a form on one sheet onto a log on another sh... -0.56
Rearranging Columns in Multiple Excel Files using VBA +1.64
Convert string date to date value +1.70
Manipulating objects in design view -0.11
Need help trimming spaces out of column +0.84
User-Defined Object In Array VBA 0.00
How to get a blank value in lookup? +0.41
Visual Basic 6 export special Polish characters to Excel 0.00
Refresh specific pivot tables when cell value changes -0.08
Combine data from two sheets to form conglomerated output (similar... 0.00
How to convert text type Duration data to time data format in Excel? 0.00
Excel 2013 Overflow due to lack of VBA optimization +1.06
Accessing an array that is stored in a single cell +1.29
VLOOKUP - IF Statement - Column Compare - YES or NO result desired 0.00
Excel VBA that looks at a form field for text and line breaks and t... -0.08
Calculating exact fraction of months during period -2.10
Formula to compare beginning of text in cells only 0.00
Working with ChartObjects 0.00
How to handle events of a Frame Scrollbar? 0.00
Wildcard in Array Formula 0.00
Count a specific value disregarding repeating dates +1.63
VBA interpretation of input date 0.00
Excel Userform with Textbox, how to toggle through values in range... +0.41
If worksheet name appears within range of cells then select -0.18
Get the column name -1.59
Obtain entire array from a single cell that is part of a collection... -0.10
Extract data separated by a comma from a single cell +0.39
Check if one of multiple values is present in a column +1.82
Need to save xls file as xlsx, close and then reopen it +1.29
Select and Insert if two conditions are met 0.00
I am working with pipe delimited files which go off my screen horiz... -0.14
Sort Part Numbers by First Character in Excel +1.83
Find the difference between two text fields in excel -0.42