"unique" function
data validation for a drop-down list can reference an entire column with a "#" postscript that dynamically adds new entries to the drop-down list as the column is modified.
For a dependent drop-down menu, the "filter" function can dynamically add more categories as the source cell references them.
And the "sort" preface can sort the drop-down list and the resulting column alphabetically.
No comments:
Post a Comment