Hi Rajesh
Try
in F5 cell use below formula and drag it
'=RANK(E5,$E$5:$E$14)
On Fri, May 13, 2011 at 8:20 PM, Rajesh K R wrote:
> Hi Experts,
>
> Pls find the attachment and tell me how to rank the rooms as per the
> collection received from them.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> --
Hi
You can use the formula
=RANK(C5,$C$5:$C$14)
I have used Rent as the Ranking Criteria. If you want to use Total
Collection, simply change C5 in the above formula to E5.
Copy the formula in all the required cells.
Thanks
Ashish
On 5/13/2011 8:20 PM, Rajesh K R wrote:
Hi Experts,
Pls
Hi Rajesh,
Please find attached.
Regards,
Mayur
On Fri, May 13, 2011 at 9:50 AM, Rajesh K R wrote:
> Hi Experts,
>
> Pls find the attachment and tell me how to rank the rooms as per the
> collection received from them.
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
> ---
Hi Experts,
Pls find the attachment and tell me how to rank the rooms as per the
collection received from them.
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips