thanks NOORAIN sir its is working cool.
On Tue, Aug 9, 2016 at 5:36 AM, NOORAIN ANSARI
wrote:
> Dear Sourav,
>
> Please try it
>
> =INDEX($A$1:$A$20,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20),""),ROW(A1)))
> Press Ctrl+Shift+Enter
> =OFFSET($A$1,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)-1,""),ROW(A1)
Dear Sourav,
Please try it
=INDEX($A$1:$A$20,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20),""),ROW(A1)))
Press Ctrl+Shift+Enter
=OFFSET($A$1,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)-1,""),ROW(A1)),0)
Press Ctrl+Shift+Enter
See attachment for more clarity...
On Tue, Aug 9, 2016 at 5:48 PM, sourav d
Hi Abhishek,
[image: Inline image 1]
On Mon, Aug 8, 2016 at 12:50 PM, Abhishek Jain
wrote:
> =lower(a1)
>
> A1 is your first value, then you can drag.
>
> On Monday, August 8, 2016, sourav devrani
> wrote:
>
>> A
>>
>> B
>>
>> C
>>
>> D
>>
>> How to small these values using Small Formula.
>>
=lower(a1)
A1 is your first value, then you can drag.
On Monday, August 8, 2016, sourav devrani
wrote:
> A
>
> B
>
> C
>
> D
>
> How to small these values using Small Formula.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join officia
A
B
C
D
How to small these values using Small Formula.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. P