Dear Friends,
good morning, afternoon, night
i was using a formula to get the unique array Values from multiple columns using Let & stack.
so please me out how to resolve the error.
=LET(v,VSTACK(a!F3:G27,b!F3:G26,'c'!F3:G27,d!F3:G26),UNIQUE(FILTER(v,v<>"")))
Error: #value!
Regards,
Ravi
good morning, afternoon, night
i was using a formula to get the unique array Values from multiple columns using Let & stack.
so please me out how to resolve the error.
=LET(v,VSTACK(a!F3:G27,b!F3:G26,'c'!F3:G27,d!F3:G26),UNIQUE(FILTER(v,v<>"")))
Error: #value!
Regards,
Ravi