Citrusandsage
New Member
- Joined
- May 13, 2021
- Messages
- 12
- Office Version
- 365
I need help so I have 2 columns I’m working off of, column B is a unique filter of industry being pulled from a control tab and then Column C is the number of opportunities. I want the Unique filter in column B to automatically sort by the number of opportunities high to low. The UNIQUEFILTER formula is
=UNIQUE(FILTER(Control!$N$4:$N$80,(Control!$N$4:$N$80<>0)))
how the heck do I get this to work? The range in which I need to sort is C7:C44
=UNIQUE(FILTER(Control!$N$4:$N$80,(Control!$N$4:$N$80<>0)))
how the heck do I get this to work? The range in which I need to sort is C7:C44