Forum Discussion
excel_learner
Nov 10, 2021Brass Contributor
IFS Formula help
Hi, Im trying to write a IFS formula With the attached file. In column AP I'm trying to get the relevant category for that cell from my "reference table" column G. I want to use the criteria for c...
excel_learner
Nov 10, 2021Brass Contributor
Hi
That is because Tier 1 and Tier 3 are not effected by Policy/Non Policy
meaning i dont want to show categories for Tier 1 thats dictated by Policy/non policy criteria
That is because Tier 1 and Tier 3 are not effected by Policy/Non Policy
meaning i dont want to show categories for Tier 1 thats dictated by Policy/non policy criteria
mathetes
Nov 10, 2021Gold Contributor
If you have the most recent version of Excel, you could start by sifting through column G of your Reference table tab to get only one instance of each value there. That can be done very easily with the new function UNIQUE, and to have it sorted, just add SORT, as in
=SORT(UNIQUE(G2:G44))
That shorter list could be used in your IFS function. I am going to defer now to Hans for the rest of your inquiry.