topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • Thursday March 28, 2024, 6:26 am
  • Proudly celebrating 15+ 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 3270 times)

kunkel321

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 597
    • 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: 7,540
  • @Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Excel thingy... Tip for using OFFSET() function to restrict a droplist.
« Reply #1 on: September 20, 2014, 10:20 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: 597
    • 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 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: 7,540
  • @Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Excel thingy... Tip for using OFFSET() function to restrict a droplist.
« Reply #3 on: September 23, 2014, 05:23 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.