•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
Tagged with
#Excel alternatives for data analysis
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#financial modeling with spreadsheets
#FILTER
#UNIQUE
#CHOOSECOLS
#Sheet 1
#Sheet 2
#data set
#column E
#values greater than 0
#error #VALUE!