3 ms·
Excel can handle millions of rows if he brings the data into PowerPivot. Note: I'm a PM on Excel
by bereasonable 10y ago
Excel can handle millions of rows if he brings the data into PowerPivot.
Note: I'm a PM on Excel
- newman314 10y agoRandom 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.
- bereasonable 10y agoWe'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-desktop-application/suggestions/9022339-built-in-regex-regular-expressions-functions-to https://excel.uservoice.com/forums/304921-excel-for-windows-...