Thank for the same
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871
Select ten cells starting from B2 to B11, starting from B2. Press F2,
and paste =LARGE(VALUE(RIGHT(B2:B886,8)),ROW(B2:B11)-1) and hit
CTRL+SHIFT+ENTER
Sam
On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 1
Hi,
You can use custom sort option to sort...
Regards,
Raghunandan M N...
9880379034
On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote:
> Dear All,
>
> I am facing the problem in the formula of the large to find the top 10.
>
> Here i am attaching the sample file for the reference.
>
> Tha
your data in B columns are TEXT data, not time data / numbers data
so you can pass into LARGE function
please try this array formula
=TEXT(LARGE(TIMEVALUE(RIGHT(B2:B886,8)),ROW(1:10)),"[hhh]:mm:ss")
array formula written on one_column (10 cells) at once !!
On Mon, Mar 28, 2011 at 5:59 PM, Bhus