New Excel function (1 Viewer)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 08:05
Joined
Jul 9, 2003
Messages
11,862
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


.....
....
...
..
.
 
Last edited:

AccessBlaster

Custom title here:
Local time
Today, 00:05
Joined
May 22, 2010
Messages
2,491
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

Registered User.
Local time
Today, 08:05
Joined
May 21, 2011
Messages
28
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 ;)
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom