categorywise top values

**vjharry** · 03-26-2013, 02:32 PM

Hi,
Can I have top 10 values of only C category in F column by formula
I am able to get top 10 values but I want it Categorywise only

Thanks

**vjharry** · 03-26-2013, 03:28 PM

I have Got top values but trying to get by Category wise accoding to column C (file attached)

**micope21** · 03-26-2013, 03:48 PM

Hi

Please see the attached file

cell F3

Formula:

Please Login or Register  to view this content.

ctrl+Shift+enter then copy down.

Re: categorywise top values