
Active Member

June 1, 2022

I am trying to get some values based on a selection criteria using the FILTER function. While the FILTER function works perfectly with the criteria I have provided I seem to be facing an issue when it comes to some of the cell values in the spill. What I observed is that the character length in these particular cells are greater than 255 and therefore excel seems to be giving the #VALUE! error message. Is this a known limitation and is there a work around for this?


July 31, 2020

Sorry for the delay in replying, I only got a notification today.
The formula you are trying to use if only filtering columns A & B based on col C, so there is no need to use choose.
If you want to display non-contiguous columns you can do that like
=LET(f,FILTER(Data!$A$2:$E$16,Data!$C$2:$C$16=$C$1),INDEX(f,SEQUENCE(ROWS(f)),{1,2,5}))

Answers Post
1 Guest(s)
