Excel Blog

#ExcelWorldChamp Round 1 Answers

Johnnie Thomas ‎01-19-2017 08:28 AM

10 Excel Tricks you did not yet know

Olaf Hubel ‎12-13-2016 04:17 PM

The Excel Community, Updates and UserVoice

Olaf Hubel ‎12-06-2016 04:12 PM
Latest Comments

Re: 10 Excel Tricks you did not yet know

I tried several times Tell Me feature, but Google (okay, full scale Bing) works much better. Mainly due to adjustmens you could make for the search. O...
02-14-2017 10:41 AM

Re: #ExcelWorldChamp Round 1 Answers

Thanks Johnnie for the explanations. I think I even recognize parts of my solutions. I was certainly not the only one but never the less.Nice to know ...
02-08-2017 10:28 AM

Re: #ExcelWorldChamp Round 1 Answers

what about this solution for question 4. Just two functions, albeit still an array formula: =MIN(IF((G20:G95<26)*(H20:J95>0);H20:J95))
02-05-2017 11:13 PM

Re: #ExcelWorldChamp Round 1 Answers

AWESOME! Alexander. 3 functions i almost never use. I had to crack open Excel jog my memory on how they work. Thanks for sharing!
02-03-2017 08:43 AM

Re: #ExcelWorldChamp Round 1 Answers

I used a different formula for question 5: =SUM(SIGN(FREQUENCY(DECIMAL(F20:F95,36),DECIMAL(F20:F95,36)))) Not as consise as the COUNTIFS solution thou...
02-03-2017 08:37 AM