use =SMALL($B$2:$B$21,ROW()-1)
On 6/8/12, Rajan_Verma wrote:
> Hi Hilary
>
> You can take idea from this file.
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of hilary lomotey
>
Hi Hilary
You can take idea from this file.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hilary lomotey
Sent: 08 June 2012 6:56
To: excel-macros
Subject: $$Excel-Macros$$ Sorting Alphabetically wi
thanks Noorain for the examples really grateful, however, i noticed that
you still have to use COUNTIF($O$29:$O$44,"<="&O29) in other to be able
to sort,ie the sumproduct etc are all dependent on it.
THE PROBLEM WITH THE SHEET I AM WORKING IN IS THAT IT DOESNT BEGIN WITH 1
IF I USE THE COUNTIF
Thanks, Dave, but its not working, could you kindly do it in the sheet and
send back? thnks
On Fri, Jun 8, 2012 at 1:36 PM, David Grugeon wrote:
> Hi Hilary
>
> Use the SMALL function starting with 1 and increasing it each time.
>
>
> On 8 June 2012 23:25, hilary lomotey wrote:
>
>> Hi Experts
Hi Hilary,
Please find attached sorting sheet, Which have many example to sorting data
through formula. Hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Fri, Jun 8, 2012 at 7:06 PM, David Grugeon wrote:
> Hi Hilary
>
> Us
Hi Hilary
Use the SMALL function starting with 1 and increasing it each time.
On 8 June 2012 23:25, hilary lomotey wrote:
> Hi Experts
>
> i am trying to sort alphabetically with a formula in the attached sheet in
> column "O", i tried using COUNTIF($O$29:$O$44,"<="&O29) to get the first
> numb
