Hi Sara,
Please find attached the soln.
Hope it helps.
Rgds,
Andy
On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
i have a column in excel with the following date format--
ship date
20110801
20110823
20110903
I need another column adjacent to it which gives
Hi Sara,
Refer the below thread for feasibility.
http://www.excelforum.com/excel-worksheet-functions/639013-number-of-the-week-in-month.html
---
Ms.Exl.Learner
---
On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
i have a
Dear Excel Gurus,
I am free lance data analyst, I have set of excel templates to
calculate the Savings and Overcharges. I would like to auto-maize the
whole process using VBA and Macro. I would like to know the
professional who can create the package ( Excel along with VBA and
Macro. Please
Hi lee,
Please find attached formula for your query.
Thanks
Mukesh
- Original Message -
From: Sara Lee
To: excel-macros@googlegroups.com
Sent: Monday, October 31, 2011 6:49 AM
Subject: $$Excel-Macros$$ formulas to get the week in the month and week of
the year
hi
i
hi
i have a column in excel with the following date format--
Invoice Date 20111003 20111003 20111003 20111003 20111003 20111003
20111003 20111003 20111003 20111003 20111003 20111003 20111003 20111003
20111024 20111024 20111024 20111003 20111003 20111003 20111003
I need the date format like
Dear Airan,
Please find attached sheet with solution..
=TEXT(DATEVALUE(MID(A2,5,2)-RIGHT(A2,2)-LEFT(A2,4)),dd-mmm-yy)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Hi Shashank,
Considering A2 has country and The Code in B1, the formula to be placed
in C1 is as follows:
=IF(AND(A2=India,OR(B2=8,B2=11)),TRUE,ERROR)
On Mon, Oct 31, 2011 at 4:40 PM, shashank bhosle
catchshashankbho...@yahoo.co.in wrote:
Hello ,
When Cell= India and other cell Code is
Hi All,
I need some reporting template for manufacturing company (all kinds of
analysis which we can perform for a manufacturing company).
appreciate your response.
Regards,
Mayank
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Shashank,
Select both Cell and Type formula in Data-Validation-Custom
=AND($A2=India,or($B2=8,$B2=11))
Check Attached Sheet.
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Lee,
Please use simple..
*=INT(DAY(H7)/7+0.99)*
for your format use
*=INT(DAY(MID(H9,5,2)-RIGHT(H9,2)-LEFT(H9,4))/7+0.99)
*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Thanks,
Problem solved
On Oct 22, 3:57 am, abhishek pandey gjobabhis...@googlemail.com
wrote:
Hi
You can use the converter technology Office Converter or OMPM for office
2010.
Thanks
Regards
Abhishek
On Thu, Oct 20, 2011 at 10:21 PM, Brian brianfosterbl...@gmail.com wrote:
I have
Hi Don,
I tried your macro, but still it doesn't solving my problem,
I wanted worksheet name should appear in column A and for all the data which
copied from that particular worksheet.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com
Worked perfectly - thank you so much for your help Chethan and Sam - truly
appreciated!!!
Thank you,
Kent
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of B.N.Chethan Kumar
Sent: October 28, 2011 5:38 PM
To:
This copies only columns shown
Sub CopyMRandCYSAS()
Application.Goto Sheets(ci).Range(a1)
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range(A4:as lr)
.AutoFilter Field:=39, Criteria1:==*mr*
Range(a1:b1,e1,h1:i1).EntireColumn.SpecialCells(xlCellTypeVisible) _
.Copy Sheets(mr).Range(a1)
The format that you provided is really good but I have one other issue. What I
have been doing is taking a very large number (in the millions) and I have
reducing by millions and then rounding. Here is an example:
English accounting:
1) $4,333,222 - =round((4,333,222/1,000,000),2)
2)
Which is what I was point out all along in my previous mails Kent. You'll
have to use the other format that I suggested. With the format you are
using, it will always show a ,00 in the end, instead of the decimal values.
And you'll have to divide in by 10,000 instead of 1,000,000 just to
Please send resumes to* g...@deegit.com*
*DATA ANALYST *
*Warren, NJ*
*6 months *
*Key Requirements:*
- 5+ Years of financial industry background is mandatory
- Person should have worked with operations, financial positions,
transactions, benchmarking, corporate actions data
-
Please send resumes to *g...@deegit.com*
*
*
*BA with Treasury applications*
*Atlanta,GA*
*12 Months
*
1. Experience implementing Treasury applications working for a large
consulting firm
2. Need functional configuration knowledge of the Wallstreet suite of
products. must have
Not sure what 'aspose.cells' means. Please be absolutely clear as to what
your objective is. Sometimes it may be easier to explain with a sample file
that represents your original data file.
Please also adhere to the rules of this forum
Are you referring to the Paste Link feature in excel, and
Thank you Noorain and Aindril...one thing Noorain u have been always
inspiring for me
From: Aindril De aind...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, 31 October 2011 4:50 PM
Subject: Re: $$Excel-Macros$$ Validation
Hi Shashank,
Hi Sam,
I did see your note but I was unable to use the code # ### ### ###
###\,00. When the value gets close to zero it displays ,00 instead of 0,00. Is
there any way I can get it to equal 0,00 when the value is zero?
Thanks,
Kent
From:
*Experience:* 3 - 6 Years
*Location:* Gurgaon
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* Telcom/ISP
*Role:* Operations Mgr
*Functional Area:* ITES/BPO/KPO, Customer
=TEXT(TEXT(A2,\/00\/00),dd-mmm-)
Regards,
Sam Mathai Chacko
On Mon, Oct 31, 2011 at 12:52 PM, Aivi aivran...@gmail.com wrote:
hi
i have a column in excel with the following date format--
Invoice Date 20111003 20111003 20111003 20111003 20111003 20111003
20111003
Hi,
I would be interested in taking up the project. But to automate your
worksheets I need to look into the sample sheets. If you could please
mail me a few samples and what you want to achieve we can discuss this
further.
Warm regards,
Anand Kumar
anand...@gmail.com
New Delhi
--
FORUM RULES
Anand,
This is difficult for me but only tell me how I recall this macro by means
of add in. When I am creating add in load into the excel this macro not
converting the amount to million however in the working sheet this is
working fine.
*Private Sub Worksheet_Change(ByVal Target As Range)
Dim
25 matches
Mail list logo