4 ms·
Excel has allowed array formulas for literally decades. It’s not as complicated as the link you posted makes it seem. You just need: 1. A formula that suppor
by parsimo2010 7y ago
Excel has allowed array formulas for literally decades. It’s not as complicated as the link you posted makes it seem. You just need:
1. A formula that supports array returns (like MMULT)
2. Know how big the returned array dimensions are
3. Highlight that array size, type in the formula, and press ctrl+shift+enter
Returning multiple matches from a single criteria isn’t what VLOOKUP was designed for, so rather than complain that a hammer does a bad job at screwing in nails, search for a screwdriver. Excel has tons of data filtering and table features, and allows DB connections for SQL queries.
- nashashmi 7y agoNever knew of mmult. Will try to look at that technique to simplify the formula. Aside from that, another user posted excel campus example of filter function. That also returns an array. And pretty much does what I need. However, it is only for office 365 insider and not to be released anytime soon.