Hello Lynn
In Conditional Formatting, you can use the formula (Please select the entire
column or rows where you have the dates)
=MOD((1+INT(($A2-DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,5)
+WEEKDAY(DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,3)))/7)),2)=0
However, this formula is not exactly correct because Wee
Wow, that works great, thank you very much. I was trying to hack
through it and was up over 50 lines so far, I see I was on the
completely wrong track...
Thanks,
Steve
--~--~-~--~~~---~--~~
---
Hi all,
I currently have a macro that takes data from a spreadsheet and
reformats it to a pipe delimited .txt file then saves to a location on
my C: drive.
I then manually place the file on an ftp server - is there any way
that I can save the file direct to the ftp server or move it from my
C:dri
Hi,
Iam a regular user of this group, and some of the tips have helped me a lot
in my regular work, as my work also is excel based.
I have a little concern. I need to sum up data from different sheets into a
master, using 2 or 3 different criteria...Iam unable to do this at the
moment...Can any o
hi excel gurus
can you please provide me code for convert number in words in excel
regards
vikas
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutoria
Hi Steven,
Solved. Have a look at the attached file. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jul 20, 2009 at 6:50 PM, Steven Dsouza wrote:
> Hi,
>
> Iam a regular user of this group
Hello.
Have a look at the attached file. Use the following formula in C2 and drag
down :
=SUMPRODUCT((Dump!$A$2:$A$23=A2)*(Dump!$B$2:$B$23=B2)*Dump!$C$2:$C$23)
Regards.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Steven Dsouza
Sent: lundi 2
Hi Marty
I think uplaoding the file to FTP server is not within the range of Excel
vba work. it is the FTP client that does this.
1) You should have a FTP client that uploads files to server.
2) There is auto-update function in the FTP client . so once you point the
folder where the file is,
Hi Dilip
Excellent one, just one issue
You would have to lock the cells where you have given the table array,
otherwise the values go out of range and the formula does not work on
all the cells
On 7/20/09, Dilip Pandey wrote:
> Hi Steven,
>
> Solved. Have a look at the attached file. Tha
could you teach me how you came up with this formula?
thanks
On Jul 20, 1:40 pm, Ashish Pradhan wrote:
> Hello Lynn
>
> In Conditional Formatting, you can use the formula (Please select the entire
> column or rows where you have the dates)
>
> =MOD((1+INT(($A2-DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,5
Hi
You can use following formula in Excel 2007
SUMIFS(Dump!$C$2:$C$23,Dump!$A$2:$A$23,Analysis!A2,Dump!$B$2:$B$23,Analysis!B2)
Regards
Krupesh
On Mon, Jul 20, 2009 at 8:20 AM, Steven Dsouza wrote:
> Hi,
>
> Iam a regular user of this group, and some of the tips have helped me a lot
> in my
Hello.
Give a look at the web site :
http://www.bygsoftware.com/Excel/VBA/ftp.htm
Regards.
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of MartyH
> Sent: lundi 20 juillet 2009 13:07
> To: MS EXCEL AND VBA MACROS
> Su
Hi Daniel,
Thanks for the template that you made.
Can you modify the conditions like this:
Condition 1: Any points that falls outside 3 Sigma limits
Condition 2: Any two successive points fall on the same side of the center
line and outside 2 Sigma limits BUT inside 3 Sigma limits.
Condition 3: A
Hi,
For that you need to define a key in the dump sheet in Column A -
Merging data from cells in column B & C and then use sumif formula in
Analysis sheet,
For your reference I have done and attached excel sheet.
Hope this is what you required...
On 7/20/09, Steven Dsouza wrote:
> Hi,
>
>
Thanks a ton :)
On Mon, Jul 20, 2009 at 3:44 PM, Dilip Pandey wrote:
> Hi Steven,
>
> Solved. Have a look at the attached file. Thanks
>
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On
Hi
I have data in 14-3-2008 format which is in text format. I want these Date
"date format".I can do it by control F to find and replace the month by "apr"
june" etc or i can convert into text to column and then do concatenate and
>>cntrl F2
I want some eaiset trick
___
No thoughts on this at all?
On Jul 2, 12:54 pm, Dustin wrote:
> Hi Everyone!
>
> The following code works (not the best), but is inefficient, in my
> opinion. It takes a few minutes to run, which is unacceptable. I am
> looking for a re-think about how this can be done in order to make it
> run
Hi friends,
i m new to this group...
Can somebody help me with the attached sheet
Regards,
Ruchi
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutor
I've got a named range ("account") in a workbook named list.xls. I've
defined a name in another workbook as account=list.xls!account so I
can reference the range in the other workbook and the formula is
clean.
Now my problem occurs when I close the source workbook, the link to
the workbook doesn'
Hi Vikas
This request was posted earlier by one of our friends. Heres the macro to
convert numbers into words.
Sub SetNums()
Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven",
"Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen",
"Fifteen", "Sixteen", "Sevent
Hi Ruchi,
attached is the solution.
On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena wrote:
> Hi friends,
>
> i m new to this group...
>
> Can somebody help me with the attached sheet
>
> Regards,
>
> Ruchi
>
> >
>
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~---
TRY THIS ONE
Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = " Thousand ": Place(3) = " Million "
Place(4) = " Billion ": Place(5) =
22 matches
Mail list logo