StackRating

An Elo-based rating system for Stack Overflow
Home   |   About   |   Stats and Analysis   |   Get a Badge
Rating Stats for

Dirk Reichel

Rating
1543.53 (10,209th) 		Reputation
7,375 (21,633rd)
Page: 1 2 3 4 5 6 ... 9
Title Δ
Looking to be able to look through header columns and reformat cell... 0.00
How to un-flatten data in VBA 0.00
#VALUE! align cell position missing (excel) 0.00
Improve VBA flexibility to convert VLOOKUP to INDEX/MATCH 0.00
VBA issue : Simple operations with multiple types of variables -0.07
copy sheet to another workbook but the sheet is also saved in a new... 0.00
Monte Carlo Simulation of Probability of Shortfall - VBA +0.18
how to sum first 5 values in column B corresponding to a particular... +1.20
EXCEL - object variable or with block variable not set 0.00
VBA, Advanced Filter & Remove Duplicates +0.13
Create Multiple Data Validation Lists in One Sheet with VBA 0.00
VBA (Excel) Solver for multiple rows + File Saving -0.20
Finding the last value in a row 0.00
Excel - Match two columns, add value from third column and also app... 0.00
Excel - how to get if a date is a specific day of the week? -0.13
VBA code won't write array to range, only it's first element -0.54
vba elseif wont run next condition +0.03
how to get the next or previous to active cell with avoiding invisi... -0.06
Excel: using vlookup but with wildcards in the array 0.00
Count number of non-empty fields in Excel VB array's column 0.00
Find all numbers in specified intervals [Min; Max] and write them i... -0.44
EXCEL Get the column header of the lowest value in the row -2.32
Finding a particular value in an excel file and its relevant column +1.82
VBA, Excel macros: copy cell value to another sheet, offset, repeat... -0.05
Extracting Multiple Dates from a single cell -0.71
VBA to find column by name and reference values from it in a formula -0.19
Search for last occurence of an duplicated item in an array -0.31
Convert String To Time Duration In Excel In Any Of The Different Fo... +1.96
If Cell In Column Partially contains text in another Column -1.68
Vlookup function with 2 possible lookupvalue +0.43
Declaring multiple ranges with changing integer n 0.00
Transporting many non-contiguous values to other ws: copy/paste or... 0.00
Leaving Macro Dialog Box In Place +1.87
How to remove 1 character from a column in excel -1.17
VBA : error in creating pivot table 0.00
Run code from current active cell to not overwrite previous cells 0.00
probability calculation on excel 0.00
assigning entire column of data to specific column of an array in vba +0.46
Excel formula to identify the most recent non blank cell in a column +1.10
how to count number between certain range of rows? +0.41
How to break the DATE function into different segments in Excel 2010 +0.43
VBA excel row copying method doesn't work +0.19
Creating For and if statements in VBA for boolean values 0.00
make link to column excluding certain value(s) in excel +1.72
Excel multiple search/match and sum (edit: answered with SUMIFS, CO... 0.00
Excel vba - multiple conditions and multiple statements -2.41
Convert Countif to VBA +1.02
How do I switch off recalculation when using Solver in VBA? +2.04
Error:- Run-time error '1004' -1.36
Sumproduct or Countif on a 2D matrix +0.46