Quote:
Originally Posted by VKiprijan
But will it show the results for other teams in different tabs or the function has to be adjusted for each tab?
|
As long as the data in each tab is laid out in a similar way, that is with 7 columns next to each other:
2024-10-31_100509.jpg
then as long as you have a column somewhere with the goal ranges, like:
2024-10-31_100728.jpg and you adjust the ranges referred to in the function to those cells, there should be no problem.
Note that the function doesn't use the first half results at all (columns 3 and 4 of the referred-to source data), so they could be blank.