Main Area and Open Discussion > General Software Discussion

Excel thingy... Tip for using OFFSET() function to restrict a droplist.

(1/1)

kunkel321:
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:
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:
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:
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.

Navigation

[0] Message Index