Dear Dew,
Rank is already starting from 1. Please check and revert with some
more details. Thanks.
Best Regards,
DILIPandey
On 5/20/11, dewbro2 wrote:
> How can I make this rank start with 1 instead of zero.
>
> On Jul 7 2010, 2:41 am, Dilip Pandey wrote:
>> HI Subbu,
>>
>> I hope you have f
HI Subbu,
I hope you have found the solution for this query.
Recently I came across a similar kind of query and after solving that I have
customized the solution to solve your query. Please find the attached
solution and let me know if this helps. Thanks.
--
Thanks & Regards,
DILIP KUMAR PAND
=IF(AND(G2=G3,H2=H3,K2>0),0,1) for First Row
=IF(AND(G3=G4,H3=H4,K3>0),K3+1,1) For first row onward
ocity ostate carrier price Rank
a b X 12001
a b Y 290 2
a b Y 11003
a b Y 15004
c d
Kindly try this formula...
=IF(AND(G3=G4,H4=H3,J3>J4,L2>0),1,0)+1
On May 20, 4:14 am, subs wrote:
> ocity ostate carrier price
> a b X 1200
> a b Y 1290
> c d X 1300
> c d Z 1500
> e f
Dear Friend,
Please Find Attached File with solution as u need.
Thanks,
Chandrabhan Singh
On Thu, May 20, 2010 at 4:44 AM, subs wrote:
> ocity ostate carrier price
> a b X1200
> a b Y 1290
> c d X1300
> c d
Hi Subs,
I am not able to find dcity in the data, as you have mentioned in your
explanation.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, May 19, 2010 at 5:01 PM, subs wrote:
>
