HI
Can you decide what you want in Column F
Your conditions :
Column E,F -: May be blank if there is value Character should not be greater
than 60
Column F -: Should not be blank and Character should not be
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf
So what xlstime is saying is that you can use something like this in your
row 5 cells
D5=Offset(E7,Column()-Column($D$5),0) and copied across
or
D5:AX5=Transpose(E7:E250)... this has to be entered as an array formula
Regards,
Sam Mathai Chacko
On Sat, Mar 30, 2013 at 10:40 PM, xlstime wrote:
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 wrote:
> Hi ,
>
> I am new on this group I have query plz help me?
>
> Hi
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 "$
c
column A,B,C,D mean column a (Cell ) or full column a...can u please
share example sheet
.
Enjoy
Team XLS
On Sat, Mar 30, 2013 at 4:09 PM, Shrinivas Shevde wrote:
> Dear All
>
> I want to write a formula to check Following condition if all the
> following condition f
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 gre
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 wrote:
> Dear Praful
> Very Helpful and thanks again providing this helpful knowledge.Now I
> understa
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 wrote:
> See,,
>
> i have divided for Avg purpose.
>
> *=SUMPRODUCT((($A$6:$A$2310>=M5)*(($A$6:$A$2310<=N5)*($G
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 wrote:
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 1-
Dear Ashish,
Can we do it by using formula.
Regards,
prafull Jadhav;
On Sat, Mar 30, 2013 at 1:00 PM, ashish koul wrote:
> *Try this*
>
> *Sub sample()*
> *Dim i As Long*
> *With Sheets(1)*
> *For i = 1 To .Range("a1").End(xlToRight).Column*
> *Z = .Range("a1048576").En
*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
12 matches
Mail list logo
