New Excel function

[Uncle Gizmo]

I was impressed with this video demonstrating an up-and-coming new function for filtering in Excel....

Return Multiple Results from an Excel Table with One Function

.....
....
...
..
.

 

[AccessBlaster]

Nice tip Uncle. Excel has to be the most under utilized App in the Microsoft suite. I believe Power users access a tiny fraction of this apps capabilities.

Note: I noticed Jon moved Excel off the bottom. I think that's fair.

 

[Slap]

Based on my experiences over the last 10 years & even more so with a new global employer for the last 3 months I'd say Excel is the most over used and abused application in the MS suite.. I watch hours being wasted battling files with umpteen nested lookups and isna formulae that become unreadable and a performance nightmare.

Just because users can doesn't mean they should