*Try this*
*Sub sample()*
*Dim i As Long*
*With Sheets(1)*
*For i = 1 To .Range(a1).End(xlToRight).Column*
*Z = .Range(a1048576).End(xlUp).Row + 2*
*.Range(a Z :c Z + 3).Value =
.Range(Sheets(1).Cells(1, i), .Cells(4, i + 2)).Value*
*i = i + 2*
*
Dear Ashish,
Can we do it by using formula.
Regards,
prafull Jadhav;
On Sat, Mar 30, 2013 at 1:00 PM, ashish koul koul.ash...@gmail.com wrote:
*Try this*
*Sub sample()*
*Dim i As Long*
*With Sheets(1)*
*For i = 1 To .Range(a1).End(xlToRight).Column*
*Z =
Dear Praful
Thats Great!!! Nice formula.
Still I confused why you divide.Can you explain formula for me.
And one more can I use this formula in separately means not take my date
bcos I adjust date manually like financial Year (Apr to Mar).Automatically
date pick up by Sum product formula means
See,,
i have divided for Avg purpose.
*=SUMPRODUCT((($A$6:$A$2310=M5)*(($A$6:$A$2310=N5)*($G$6:$G$2310 this
result cl amt for the year.*
*
*
*and then *
*divided no of count *
*
*
*/SUMPRODUCT((($A$6:$A$2310=M5)*(($A$6:$A$2310=N5*
On Sat, Mar 30, 2013 at 2:52 PM, amar takale
Dear Praful
Very Helpful and thanks again providing this helpful knowledge.Now I
understand divide Purpose.Other Date issue?
Regards
Amar
On Sat, Mar 30, 2013 at 3:01 PM, prafull jadhav prafulltjad...@gmail.comwrote:
See,,
i have divided for Avg purpose.
Dear Xlstime,
Thanks very much for short formula another way to solution.But I used
Excel 2003.So Can you send me Excel 2003 formula.
Regards
Amar
On Sat, Mar 30, 2013 at 3:40 PM, amar takale amartak...@gmail.com wrote:
Dear Praful
Very Helpful and thanks again providing this helpful
Dear All
I want to write a formula to check Following condition if all the following
condition fulfilled then resulta should be ok.
Condition-
- Column A -:Should not be blank and Character should not be greater
than 5
- Column B,C,D -:Should not be blank and Character should not be
Hi ,
I am new on this group I have query plz help me?
Hi!
I have a repayment schedule, the monthly instalments are in a row (eq from
E7 - E250) and I must to transpose these values in a row, in other sheet
(from D5 - AX5);
I don't want to use Copy - paste special...I have tried with to use $
Hi Priti,
we have lots of way (i.e..) offset (formula),transpose (formula) with array
and paste special transpose (function)
.
Enjoy
Team XLS
On Sat, Mar 30, 2013 at 9:11 PM, Priti_verma pritiverma1...@gmail.comwrote:
Hi ,
I am new on this group I have query