Hi Guys,
excel noob here. I'm trying to create a top 10.. I have the formula =LARGE($L$2:$L$27/$M$2:$M$26,M31) but I'm getting an num Div error. I need the top 10 for two row's divided for %. How can I fix this?
thank you in advance.
Hi Guys,
excel noob here. I'm trying to create a top 10.. I have the formula =LARGE($L$2:$L$27/$M$2:$M$26,M31) but I'm getting an num Div error. I need the top 10 for two row's divided for %. How can I fix this?
thank you in advance.
The two ranges are different, for a start
2-27
2-26
I assume that M31 contains a 1.. to signify that it is the largest value that you want.
Last edited by Glenn Kennedy; 07-14-2022 at 10:51 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks