Re: $$Excel-Macros$$ Ranking formula problem

2012-05-08 Thread hilary lomotey
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

Re: $$Excel-Macros$$ Ranking formula problem

2012-05-08 Thread dguillett1
$$ Ranking formula problem 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

Re: $$Excel-Macros$$ Ranking formula problem

2012-05-08 Thread hilary lomotey
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

$$Excel-Macros$$ Ranking formula problem

2012-05-08 Thread hilary lomotey
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 formula. in the sheet attached, i have in the "data sheet" where i have ranked the data in the order at which the data a