Hi,
In reference to the earlier thread (http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/), can we get unique(no duplicates) without blanks and alphabetically sorted list?
In my case, i have a hierarchy with which i want to design a dashboard with dynamic charts for the staff reporting to a particular manager, for a particular month. It works fine, when we select a particular month. But, we also have "Quarters" on a different column, and when we select quarter, we get duplicated results.
Any help shall be highly appreciated.
Thanks
In reference to the earlier thread (http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/), can we get unique(no duplicates) without blanks and alphabetically sorted list?
In my case, i have a hierarchy with which i want to design a dashboard with dynamic charts for the staff reporting to a particular manager, for a particular month. It works fine, when we select a particular month. But, we also have "Quarters" on a different column, and when we select quarter, we get duplicated results.
Any help shall be highly appreciated.
Thanks
