Oct 31 2019 03:56 PM
Hello
A few months ago I was set up in excel some sheets to keep the accounting record and use a function like this:
= YES.ERROR (INDEX (Temp_German! B $ 2: B $ 500; K. ESIMO.MENOR (YES (SERROR (Temp_German! B $ 2: B $ 500); ""; ROW (Temp_German! B $ 2: B $ 500) -MIN ( ROW (Temp_German! B $ 2: B $ 500)) + 1); ROW (413: 413))); "")
Now the question is that after row 500 the function used does not work for me, I don't know if the maximum range to evaluate is 500 or if there is another error.
In the Temp_German table if you take the data well but then those go to another sheet that is where that combined function is joined.
I have tried changing the 500 for another higher value and it does not work.
I would appreciate the comments and help
Dec 09 2019 11:56 PM
@Haude71500 seems too little, please post the excel? thanks.