But when I change the last array from k2:k5050 to f2:f5050 then began to value error but in some cells not in all. The basic formula are in columns J thru M, and on N I changed the array. But keeping the formula basic you can see in U5 and V5 the error and in U6 and V6 no error.
Thanks for your time, I try to manually reduce the data an still getting the same error. If you see the table submitted you will that the value error seem to occur in the first part where it has to identify the RBS ID to select the REC ID in CPR_OPEN. You can see this happening in the same column with the exact same formula, for one works perfect, but for other get the value error.
Thanks again tor the info, how I might be able to limit the amount of characters it can recover from each option? As you can see in Universe columns N and O Textjoin will bring a lot of info per option, maybe limit it to 5K's per option in case have more than 4 options.