Hi all,
Hopefully it's possible, what not in excel :)
I'm familiar with the large function, the thing is that I would like to make it dynamic with a vlookup or match function in it. So in the below case if a user wants to find out the highest sales of the three weeks by a certain product, he...