Forum Discussion
Solved
Need help with #value! error
Hello everyone, I am getting #Value! error while trying to get an outcome with the below formula: =TEXTJOIN("; ",TRUE,UNIQUE(IF(A1444=$A$3:$A$3060,$AG$3:$AG$3060,""))) Please note that the for...
nathtaani7 Try FILTER() formula instead IF().
=TEXTJOIN("; ",TRUE,UNIQUE(FILTER($AG$3:$AG$3060,$A$3:$A$3060=A1444)))If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.
nathtaani7 Try FILTER() formula instead IF().
=TEXTJOIN("; ",TRUE,UNIQUE(FILTER($AG$3:$AG$3060,$A$3:$A$3060=A1444)))If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.
Harun24HR okay, I will check and get back to you. Thank you so much