News for hackers. Stuff that matters.

A comment on Is Microsoft Excel an Adequate Statistics Package?. Parent comment

Re:Is Microsoft Excel an Adequate Statistics Package? by newman314 on Sunday August 28, 2016 @11:41AM (#12376931)
Random point but Excel sure could use a CONTAINS function for substring matches.

I was looking for something like this yesterday and the solutions I found were quite ugly.

Ended up having to use DSUM/DCOUNT instead which is still inelegant when one has to to multiple lookups with slightly varying parameters.

[ Parent | on HN ]
Re:Is Microsoft Excel an Adequate Statistics Package? by bereasonable on Sunday August 28, 2016 @11:55AM (#12376993)
We're planning on adding support for regex. The current state of the work is shown on our User Voice site. https://excel.uservoice.com/forums/304921-excel-for-windows-...
[ Parent | on HN ]