Hi,
It is difficult to suggest without having sample data. However we can give
a try to below formula,
*=round(product(divide(SUMPRODUCT((Data!$N:$N = $A2)*(Data!BG:BG > G$1),
ISNUMBER(Data!BG:BG)), $B2),100),1)*
It should work. If not works please share some sample data.
On Monday,
I am having trouble finding out the issue that I have in this formula here.
I do 100 percent believe there might be a glitch because the formula works
for the first 4 columns then it just stops working. I have run down what it
could be, here is the formula I have down.