I adjusted the formulas in cells CL16:CQ 21, but they are not working as the formulas used in CL10:CQ15.
I guess I don's understand completely how the formulas work.
I made shre I pressed the Ctl>Alt.Enter buttons to create an array. Root-Cause-Analysis-Ver-31-development.x
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!)
David Miller (dlmille)
This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…