Reputation
7,165
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 7 12
Newest
 Tenacious
Impact
~699k people reached

1d
answered How to add higest ten values from odd/even columns in Excel 2010
2d
comment Convert a group of letters into a date in excel
....or you can even get rid of MOD function if you do it like this: =TEXT(SUMPRODUCT(FIND(MID(A1,{1,2,3,4,5,6},1),"RSWITCHGEA")-1,10^{5,4,3,2,1,0})‌​,"0-00-00")+0
2d
comment Convert a group of letters into a date in excel
Are you always using 6 letters? How is 1st Jan 2015 represented?
2d
comment Convert a group of letters into a date in excel
Nice! If there will always be 6 letters in A1 you could simplify to this non-array version =TEXT(SUMPRODUCT(MOD(FIND(MID(A1,{1,2,3,4,5,6},1),"SWITCHGEAR"),10),10^{5,4,3,2‌​,1,0}),"00-00-00")+0 to return an actual date
2d
answered Excel 2007 How do I get rid of the 0 (zero) in this formula
Apr
11
answered Excel sees date/time value as text
Apr
8
answered How to convert a number for a salary amount, to a specific, 9 digit, format in Excel
Apr
8
answered EXCEL: Additional COUNTIFS / Condition Needed for Value Ranges
Apr
6
answered SUMPRODUCT with VLOOKUP
Apr
3
comment Adding multiple IF formulas into one cell
I'd be very surprised if MS removed any functions from Excel - I can't remember that happening in the last 15 years!.....but it's easily achievable with a similar syntax using other functions, e.g. HLOOKUP like this: =HLOOKUP(Source!C24,{0,70,80,90;"F","C","B","A"},2)
Apr
2
answered Adding multiple IF formulas into one cell
Apr
2
revised Summing multiple cells that match row AND column criteria?
typo corrections
Apr
1
comment Counting the Cells in a Named Range without VBA
Not sure what you mean - text values won't work in this context because SMALL only deals with numbers. Do you want to pick random text values from a discontiguous range? That might be tricky......
Apr
1
comment Counting the Cells in a Named Range without VBA
From Excel Help: FREQUENCY ignores blanks cells and text.....
Apr
1
comment Counting the Cells in a Named Range without VBA
Why count the number of cells? If you do that then the SMALL function can return an error because RANDBETWEEN can return a number larger than the count of numbers in MyPicks
Apr
1
comment Counting the Cells in a Named Range without VBA
Does this really do what you asked? Doesn't =SUM(FREQUENCY(MyPicks,MyPicks)) just give a count of numbers in MyPicks - you can get the same result using =COUNT(MyPicks)
Mar
31
answered Summing multiple cells that match row AND column criteria?
Mar
27
comment Excel: Sum a column of text excluding duplicates in another column of numbers
No problem - Can you "accept" my answer please
Mar
27
comment Excel: Sum a column of text excluding duplicates in another column of numbers
I edited my answer to fit your sheet - google sheets isn't the same as Excel - some formulas need to be different - you don't have "custom" on it's own in column G - you need a different approach to search for it within other text
Mar
27
revised Excel: Sum a column of text excluding duplicates in another column of numbers
added 456 characters in body