itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 115
- Office Version
- 2021
- Platform
- Windows
- MacOS
I’m trying to get the unique value in G column if E is greater than 5000. When using the formula below I get a #Spill! error.
=UNIQUE(FILTER(G1:G100, E1:E100>5000))
Not sure why. Can I get some help.
=UNIQUE(FILTER(G1:G100, E1:E100>5000))
Not sure why. Can I get some help.