diamondjoechubbs
New Member
- Joined
- Oct 26, 2020
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
I am having some trouble combining some formulas using the unique feature. I was able to use an IF function with unique, but when combining IF and AND the function is not working
This one works with one criteria
=UNIQUE(IF('Tract Line List'!AK2:AK999>1,'Tract Line List'!$B$2:$B$999,""))
Using AND for two criteria, it does not return values the same way the single one does
=UNIQUE(IF(AND('Tract Line List'!W2:W999>1,'Tract Line List'!AK2:AK999>1),'Tract Line List'!$B$2:$B$999,""))
Thank you in advance
This one works with one criteria
=UNIQUE(IF('Tract Line List'!AK2:AK999>1,'Tract Line List'!$B$2:$B$999,""))
Using AND for two criteria, it does not return values the same way the single one does
=UNIQUE(IF(AND('Tract Line List'!W2:W999>1,'Tract Line List'!AK2:AK999>1),'Tract Line List'!$B$2:$B$999,""))
Thank you in advance