gt; SalesAid Software
> dguille...@gmail.com
>
> *From:* hilary lomotey
> *Sent:* Tuesday, May 08, 2012 6:30 AM
> *To:* excel-macros
> *Subject:* Re: $$Excel-Macros$$ Ranking formula problem
>
>
> Thanks guys, i have been able to write the formula.
>
>
>
> On Tu
could have put 1,2,3 in col a and this in col b and copied across and down
=INDEX(data!A:A,MATCH($A21,data!$O:$O,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Tuesday, May 08, 2012 6:30 AM
To: excel-macros
Subject: Re: $$Excel-Macros
Thanks guys, i have been able to write the formula.
On Tue, May 8, 2012 at 8:52 AM, hilary lomotey wrote:
> Hello Experts
>
> i have a data where i want to rank in order of 1 to the last number on a
> different sheet. Because i dont want it dynamically, i dont need to use
> sort, but rather a
