• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

New Excel function (1 Viewer)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 00:02
Joined
Jul 9, 2003
Messages
12,004
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
Yesterday, 17:02
Joined
May 22, 2010
Messages
2,647
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, 00:02
Joined
May 21, 2011
Messages
29
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

Top Bottom