Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 10, 2016, 03:01:25 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Excel thingy... Tip for using OFFSET() function to restrict a droplist.  (Read 1525 times)

kunkel321

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 464
    • View Profile
    • Donate to Member
Nobody at home or work will appreciate this thing I did.  
I'll just leave it here.   :D



Excel file attached...
EDIT:  There's not macros...  And guaranteed no maljunk. :)

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 6,141
  • Slartibartfarst
    • View Profile
    • Donate to Member
Re: Excel thingy... Tip for using OFFSET() function to restrict a droplist.
« Reply #1 on: September 20, 2014, 10:20:26 AM »
Thanks! That's rather nifty if you need to set up (say) an efficient data input form for a user.
Otherwise I would usually use Tables and Filters nowadays.
Hmm, but I wonder whether you could use Regex in there...    :)
Excel is a pretty powerful tool.

kunkel321

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 464
    • View Profile
    • Donate to Member
Re: Excel thingy... Tip for using OFFSET() function to restrict a droplist.
« Reply #2 on: September 22, 2014, 01:23:23 PM »
Yea, I also make use of Tables...
I have a dashboard type of thing though that pulls from a Table, and also allows independent lookups of individual people...

There's about 1200 people in my list, so I was getting tired of scrolling the whole list.

I don't think it's possible to use Regex in formulas (only in VBA).  You can use wildcards * ? in some though. 

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 6,141
  • Slartibartfarst
    • View Profile
    • Donate to Member
Re: Excel thingy... Tip for using OFFSET() function to restrict a droplist.
« Reply #3 on: September 23, 2014, 05:23:12 AM »
Ah, I see why you use it now. Yes, of course.
I just might have a use for it actually. I may be required to develop a person lookup for an Excel database of a few thousand members of an alumni group that was set up a few years back and has now grown quite large.