Support for Microsoft version of R, new stuff worth checking, Data Mining GUI for those intimidated by R code: http://togaware.com/rattle-5-0-0-alpha-released/
Install: install.packages("rattle", repos="http://rattle.togaware.com")
piątek, 16 grudnia 2016
wtorek, 13 grudnia 2016
Excel: Rank if with sumproduct (and VBA)
Look here: http://www.mrexcel.com/forum/excel-questions/82479-rank-if-2.html
eg.
=SUMPRODUCT(--(A$3:A$11=A3)*(B3<B$3:B$11))+1
Big thanks. Helped me a lot today.
eg.
=SUMPRODUCT(--(A$3:A$11=A3)*(B3<B$3:B$11))+1
Big thanks. Helped me a lot today.
Subskrybuj:
Posty (Atom)