•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
FILTER function shows errors when combined with UNIQUE and CHOOSECOLS
I have a big data set on Sheet 1. On Sheet 2, I want to extract column E (contains value numbers) from Sheet 1. I use the following formula UNIQUE(CHOOSECOLS(‘Sheet 1’!A4:AD1048576),5)). The formula works. However, I want to show values greater than 0 only on Sheet 2. When I include FILTER function in like this UNIQUE(CHOOSECOLS(FILTER(‘Sheet 1’!A4:AD1048576), (‘Sheet 1’!E4:E1048576>0)),5)), it shows error #VALUE! for some reason. Does anyone know how to fix it? Any feedback is greatly appreciated. Thank. you!
[link] [comments]
Want to read more?
Check out the full article on the original site