"Hi All,
This has got me scratchig my head I;m trying to figure out a formula which will allow me to workout the average for the top 90,80&70% based on client
In the example attached the client is in column A and the data to average is in B
The forumla will have to take into consideration that the numbers wont be in order which makes it a little tricker, I have had a little mess around with the percentile function not sure if that is the right one to use.
I hope I have explained it all properly
Thanks "
Bookmarks