Hi Skanda,
Please find attached the solution file.
Regards,
Andy
On Sat, May 2, 2009 at 2:54 AM, Skanda wrote:
> Columns A and B give the sum of ceizg and paracept in each row.
> Is there any formula that sums all the values of "Ceizg" ad "Paracept".
> e.g:96,00 is the sum of all "paracept"
Hi Harmeet
Thanks for the formula. It works perfectly when the start day is not
included.
Aindril De:
Thanks Aindril for raising the concern as said above. Anyways I was working
on the solution.
Dilip Pandey:
Thanks for the nice formula. But I am not getting the result when I vary the
duration (i
Columns A and B give the sum of ceizg and paracept in each row.
Is there any formula that sums all the values of "Ceizg" ad "Paracept".
e.g:96,00 is the sum of all "paracept" in the first row.
4,600 is the sum of all "Ceizg" in the second row.
I gave only partial data. I have about 50K r
look if the attached workbook fits your needs
2009/4/30 DittoDan
>
> Greetings, I am new to this list. If this question was recently asked,
> please point me to it and forgive me for asking it so soon.
>
> I want to make an Excel table to do a task. I want a drop down (I know
> how to use Data v
Hi
Try the following code.
It assumes that column A has the maximum number of entries, to determine how
many rows to loop through.
If that is not the case, change the column letter from "A" to wahtever you
wsih.
Sub CopyLines()
Dim wsS As Worksheet, wsD As Worksheet
Dim lr As Long, i As
Hi
The other solution offered, has the -1 outside of the parentheses.
This is incorrect.
The formula should be
=WORKDAY(B3,F3-1)
You need the Analysis Toolpak loaded, Tolls>Addins>Analysis Toolpak.
Note, you can also Exclude holidays as well as Weekends with the Workday
function.
If you have a l
Hi,
I would like to build a macro that does the following:
I am in Sheet 1.
If the cell of "Column E" = "1"
Then copy the entire ligne.
Select Sheet 2
Paste the whole line
Select Sheet 1
Repeat as long as there is a "1" in column E.
At the beginning of the macro, Sheet 2 is entirely empty.
Th
HI,
As per the previous comments on this, it essentially is an array formula,
that is applied to a range of a cells instead of a single cell. The function
DfListHolidays() is designed to return an array, and not a single value. So
if you enter the function as usual in a cell, DfListHolidays() sti
Hi dear,
{ - is a formula which occupys the array instead of a cell - the basics to
use the formula is you need to type the formula and press Ctrl + Shift +
Enter by selecting the particular array.
Cheers
Surya
On Fri, May 1, 2009 at 2:16 PM, Yu wrote:
>
> Hi all,
>
> I've been programming V
*Hi Shine,*
Slight modifications in the method suggest by Satti,
Enter following in cell A3
"" (blank)
Enter following in Cell A4
=A1*OFFSET(A1,0,1)
Now select the range A3:A4 and drag them to the right side as per your need.
Now apply the following formula to get the answer:-
=sum(3:3)
Note:
Dear Yu,
That is an array formula which is applied by using Ctrl + Shift + Enter.
Best Regards,
Jitendra
On Fri, May 1, 2009 at 2:16 PM, Yu wrote:
>
> Hi all,
>
> I've been programming VBA for around 1 and half years.But this is
> the first time I encounter this . It is a not a VBA issue.it
Hi all,
I've been programming VBA for around 1 and half years.But this is
the first time I encounter this . It is a not a VBA issue.it is a
Excel Function i guess. But I have no idea what it is.
Here is what it does: Retreive Financial Calendar from a specified
date to a specified data via
Hi Praveen,
You can use following function:-
=IF(TEXT(B3+F3-1,"DDD")="Sat",B3+F3-1+2,IF(TEXT(B3+F3-1,"DDD")="Sun",B3+F3-1+1,B3+F3-1))
Note: Excel file is also attached for your reference.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gm
13 matches
Mail list logo
