View Single Post
 
Old 10-31-2024, 03:14 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by VKiprijan View Post
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.
Reply With Quote