scr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Warm Regards,
Aindril De
Ph: 9811300157
--
Are you =EXP(
ubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit
at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Warm Regards,
Aindril De
Ph: 9811300157
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Warm Regards,
Aindril De
Ph: 9811300157
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
-macros?hl=en.
--
Warm Regards,
Aindril De
Ph: 9811300157
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem
If you Delete the rows mentioned.. then the formula you have mentioned works
On Fri, Jan 11, 2013 at 2:09 PM, amar takale amartak...@gmail.com wrote:
No problem hide row delete,no matter.
On Fri, Jan 11, 2013 at 1:59 PM, Aindril De aind...@gmail.com wrote:
Dear Amar,
You are getting
EXCEL AND VBA MACROS group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
--
Warm Regards,
Aindril De
Ph: 9811300157
--
Join official facebook page of this forum @
https
Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (986+ members already BANNED
Hi Smitha,
Attached is the soln.
Cheers,
Andy
On Wed, May 16, 2012 at 2:31 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Please suggest a formula on this attachment.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Sorry missed the last part of the formula
The corrected formula is:
=IF(F4=0,MIN(E4,C4),(E4+F4-C4))
Cheers,
Andy
On Wed, May 16, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Please correct my formula on this attachment.
On Wed, May 16, 2012 at 2:31 PM, Smitha S R
Dear Vijay,
The easiest way to do that is to select the entire table and then Sort on
Multiple Criteria.
1) Quality (Largest to Smallest)
2) Achieved (Largest to smallest)
That would do the trick..
Hope that helps...
Cheers!
Andy
On Tue, Apr 24, 2012 at 11:01 AM, Vijay Mane levb...@gmail.com
, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM
to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Hi
Try this:
http://dmcritchie.mvps.org/excel/shortx2k.htm
Cheers,
andy
On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hello sir
Can you tell me what is shortcut key for data clear(filter)?
Thanks
--
FORUM RULES (934+ members already BANNED for
-com:office:spreadsheet* xmlns:html=*
http://www.w3.org/TR/REC-html40*;
- file:///C:/Users/ade/Desktop/TEST-XML/Sheet2.xml# DocumentPropertiesxmlns
=*urn:schemas-microsoft-com:office:office*
AuthorMr. Aindril De/Author
LastAuthorMr. Aindril De/LastAuthor
Created2011-12-07T08:39:05Z/Created
Dear Hemant,
It can be achieved using the vlookup formula.
Suppose you have a data set in Sheet 1 from A1 to A9, which you need to
compare with the values present in column A in Sheet 2
Then in Column B, please type:
=VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0)
and drag the formula down.
You will get
loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use
NOTE:
I am using the simple TRIM() function as the data you have sent contains
multiple spaces in the trail.
On Wed, Dec 7, 2011 at 2:35 PM, Aindril De aind...@gmail.com wrote:
Dear Lakshman,
You are not able to do the SUM as the data in the last column has leading
and trailing spaces.
You
Sorry NOT USING TRIM
On Wed, Dec 7, 2011 at 2:39 PM, Aindril De aind...@gmail.com wrote:
NOTE:
I am using the simple TRIM() function as the data you have sent contains
multiple spaces in the trail.
On Wed, Dec 7, 2011 at 2:35 PM, Aindril De aind...@gmail.com wrote:
Dear Lakshman,
You
Hi All,
I have a dataset in Excel.
I have to do the following:
1) Convert the dataset to XML Format
2) Create a different XML File for each row.
Any help would be really appreciated.
Cheers
--
Andy
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread
-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Hi Friends,
I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
extract the second biggest number from this list.
Note: This list cannot be sorted. I have already found out how to do it
from a sorted list. Also I would need this to be done possibly through a
formula and not any
, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote:
Hi Friends,
I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
extract the second biggest number from this list.
Note: This list cannot be sorted. I have already found out how to do it
from a sorted list. Also I would
Thanks all..
On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh jeete2...@gmail.com wrote:
=LARGE(A1:G1,2)
Regards
jeet
On Thu, Dec 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote:
Hi Friends,
I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to
extract the second
, Divaker Pandey divake...@gmail.com wrote:
try this one,
=LARGE(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+1)
On Thu, Dec 1, 2011 at 5:32 PM, Aindril De aind...@gmail.com wrote:
Thanks all..
On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh jeete2...@gmail.comwrote:
=LARGE(A1:G1,2)
Regards
jeet
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hi Sandeep,
We do not need a formula to do the same.
Simple select the column/cell that has your date and change the format to a
custom format delete everything in the Type: box and fill to
display the full month name or mmm to display the month in a short form.
Cheers,
Andy
On Tue, Nov
Hi Neeraj,
You can use the Consolidate function of Excel to achieve the same. Please
follow the link below for the steps:
http://support.microsoft.com/kb/214270
Cheers,
Andy
On Tue, Nov 15, 2011 at 4:00 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
How can I make
Pl chk this,
http://support.microsoft.com/kb/812386
Cheers,
Andy
On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Master,
** **
I have an excel file with sheet names ranging from A to V. However I want
to change its sequence post changing its
to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
to excel-macros@googlegroups.com
--
Warm Regards,
Aindril De
Ph: 9811300157
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Hi Ayush,
Great Going Brother Keep up the Good Work...
Cheers,
Andy
On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am proud to share that I have been re-awarded the Micrososft MVP award in
2011. My deep thanks to each group member for all your
://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph
://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157
://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157
link
http://www.facebook.com/discussexcel
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Warm Regards,
Aindril De
Unified Learning Pvt Ltd.
Ph: 9811300157
--
--
Some important
Haha.. Gr8 one as usual Ayush...
Wish I had one when I got married... ;) cheers!!!
On Wed, Feb 23, 2011 at 8:46 AM, Ayush jainayus...@gmail.com wrote:
The most expensive wedding ever was that of Vanisha Mittal, daughter of
world’s 8th richest person Lakshmi Mittal, to investment banker Amit
Hi Mike,
Please use:
=VLOOKUP(A2,Sheet1!B:B,1,0) instead.
Regards,
Andy
On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike michael.lovel...@gmail.comwrote:
I am struggling with this and wondering if you could help..
Worksheet 1 Column A B
Keyword Category
telecom Telecom
tele com#N/A
Hey Ayush,
This is indeed a great news!!
A great initiative from your side once again!!
By profession I do a little bit of web development and content development.
Therefore I would like to be the first volunteer to this job..
Cheers,
Andy
On Wed, Feb 2, 2011 at 9:09 PM, Ayush
Hi Abhinda,
PFA the solution..
Regards,
Andy
On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit abhidha.di...@gmail.comwrote:
Dear All,
please help me with the formula where in I should get the result
1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then
B2-300,
Hi Manjunath,
The solution provided in the link should suffice:
http://www.mvps.org/dmcritchie/excel/saveas.htm
http://www.mvps.org/dmcritchie/excel/saveas.htmRegards,
Aindril
On Tue, Nov 30, 2010 at 2:50 PM, Manjunath C cmanjunathchen...@gmail.comwrote:
Hi
Can anyone help me, as I Have
Hi,
Looking at the data, the easiest you can use is SUMIF, instead of VLOOKUP
Regards,
Aindril
On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna bhavya...@gmail.com wrote:
Hi Everyone.
Can someone explain I have data in sheet 1 The columns Name and Production
. Now I want to fetch data in
Hey Jai,
Supposing the dates are in cells A1 and A2, you can use the following in
cell A3:
=DATEDIF(A2,A1,y)IF(DATEDIF(A2,A1,y)1, years ,, year
,)DATEDIF(A2,A1,ym)IF(DATEDIF(A2,A1,ym)1, months ,, month
,)DATEDIF(A2,A1,md)IF(DATEDIF(A2,A1,md)1, days left., day left.)
Please modify accordingly.
Hi Ayush,
Thanks a ton.. for the effort..
Something seems to be wrong at my end as the link you have given is not
opening..
Is there any way you can send the file to me plz..
Cheers,
Andy
On Mon, Nov 8, 2010 at 7:35 PM, Ayush jainayus...@gmail.com wrote:
Dear Group Members,
Good news for
Hi Ayoub,
Can you please explain this:
Of these columns some lack data if less than 8 of the above columns lack
data word missed should appear
Regards,
Andy
On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande akaka...@gmail.com wrote:
Good afternoon
I need some help on a project that is buzzing
the formula:
=IF(COUNTIF(A2:BL2,missed)8,Missed,SUM(D2,H2,L2,P2,T2,X2,AB2,AF2,AJ2,AN2,AR2,AV2,AZ2,BD2,BH2,BL2))
Copy down the formula to the last row of your range and it should give you
the desired result.
Regards,
Andy
On Tue, Nov 2, 2010 at 5:36 PM, Aindril De aind...@gmail.com wrote:
Hi Ayoub
Dear Ashish,
I just downloaded the Open Excel.
It looks like a neat set of features.
Excellent work...
Would like to contribute to it, whever I get some time...
Cheers,
Andy
On Sun, Oct 31, 2010 at 11:27 PM, Ashish Jain ashishj...@openexcel.comwrote:
Dear Members,
We're proud to launch OPEN
Hi C.G.,
Could you please elaborate more on what condition you would like to put in
here?
Regards,
Andy
On Fri, Oct 8, 2010 at 10:34 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
I am looking for conditional sum i.e. sum based on criteria. But neither
Sumproduct nor SUMIFS and Pivot serve
Hi,
I accidentally found an answer to the question put up by N Shivkumar. So
wanted to share the same, though I am sure most of you must have found the
solution to this. Following are the steps:
1) Select the column/cell where you want to have the format with the
new ` rupee
symbol.
2) Change
Hey Ayush!! You haven't responded to Neil's email
Where is the Treat Man!!!? [?][?]
Cheers,
Andy
On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina lovemekris...@gmail.comwrote:
Congratulations Ayush Jain. Really Very proud of you man.
On 10/4/10, rajasekhar praharaju
Congratulations Brother!!
You deserved it!!!
Cheers,
Andy
On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
I am proud to announce that I am awarded Microsoft Most Valuable
Professional MVP on October 01, 2010 for providing technical expertise
in Excel
Hi Pankaj,
In your attached example put the following formula in cell C2 and copy it
down:
=IF(NOT(ISERROR(VLOOKUP(B2,$A$2:$A$8,1,0))),Match,Mismatch)
The above formula matches the entries in the Column B with the column A.
Pl let me know if this works for you.
Regards,
Andy
On Thu, Sep 30,
As Integer, Amount As
Integer) As String*
It should work fine now
Cheers
Andy
On Sat, Sep 18, 2010 at 10:55 AM, Aindril De aind...@gmail.com wrote:
Hi Giorgio,
Use the following UDF.
*Function RandLotto(Bottom As Integer, Top As Integer, _
Amount As Integer) As String
Hi Pratik,
Dont know much about this, however I have googled this up for you:
http://www.business-spreadsheets.com/forum.asp?t=120
http://www.business-spreadsheets.com/forum.asp?t=120please check if this
works
Regards,
Andy
On Sun, Sep 19, 2010 at 12:34 AM, Pratik pratik...@rediffmail.com
Hi Janet,
This can be possible if you have the dates in proper date format.
From the data it seems that the dates are not in the proper format.
If you can enter the dates in a consistent format, then you can easily use
the following formula in Column C to get the days
=DATEDIF(A2,B2,d) - Paste
You can use a pivot Table to resolve this issue
On Sat, Sep 18, 2010 at 4:16 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I am facing a problem to lookup data from another sheet. Please help me.
Details is in attached file.
Thanks in advance
Kalyan
--
Hi Giorgio,
Use the following UDF.
*Function RandLotto(Bottom As Integer, Top As Integer, _
Amount As Integer) As String*
Dim iArr As Variant
Dim i As Integer
Dim r As Integer
Dim temp As Integer
Application.Volatile
ReDim iArr(Bottom To
HI,
The largest available subscript for the indicated dimension of an array can
be obtained by using theUbound function. In our one-dimensional array
example, Ubound(arr) is 5.
In our two-dimensional array example above, there are two upper bound
figures - both are 2.
UBound returns the
Hi John,
Could you send a sample set of data.
Regards,
Andy
On Thu, Sep 2, 2010 at 11:41 PM, JohnA johnasmit...@gmail.com wrote:
I need to determine time increments from postings in Excel in the 24
hour mode (commonly called military time).
I can't come up with a formula to give me decimal
Hi,
Please use the following code:
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
Cheers!
Andy
On Thu, Sep 2, 2010 at 9:58 AM, big smile bigsmile...@gmail.com wrote:
Respected Excel Guru's
How to make the macro so that
When ever i start the file my
Hi Pankaj,
Pl go through this link
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm
Regards,
Andy
On Thu, Sep 2, 2010 at 12:39 PM, Intelligent But Crazy secrets...@gmail.com
wrote:
Hi Experts,
--
Pankaj Pandey
Bhopal
--
Have a nice day
CP SAVLA
On Thu, Sep 2, 2010 at 1:05 PM, Aindril De aind...@gmail.com wrote:
Hi,
Please use the following code:
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
Cheers!
Andy
On Thu, Sep 2, 2010 at 9:58 AM, big smile bigsmile
Hi Kalyan,
You can use the following formula in the cell B2 and then copy it down
=LEFT(A2,LEN(A2)-(LEN(A2)-FIND(^^,SUBSTITUTE(A2, ,^^,LEN(A2)
-LEN(SUBSTITUTE(A2, ,))
For more info on the above please check:
Hi Antony,
Assuming that the Header Start date is in Cell A1, please use the
following formula in the Category column:
=IF(AND(C2=0,C2=30),1,IF(AND(C2=31,C2=60),2,IF(AND(C2=61,C2=90),3,IF(AND(C2=91,C2=120),4,IF(C2=120,5,)
Please let me know if this helps or u need any further help on this.
Hi Phillip,
Please find attached the solved workbook.
Do let me know if it helps or you need further help.
I have added some other features other than your requirement which I felt
might come handy, as well, which will predict the following:
Today (As required)
Tomorrow (As required)
Day After
Hi Steve,
In Excel 2007 certain things have changed in the VBA front as well. While
saving the file in any XML format that is .xlsx in this case, you need to
supply the file fomat value as well. The following link will give you
further details on this.
http://www.rondebruin.nl/saveas.htm
Hi Mat,
Open the file in Excel. You will find all the information in Column A.
Select Column A and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and click finish if
Hey Rolf,
You can use the following Code.
Public Sub SaveWorksheetsAsCsv()
Dim WS As Excel.Worksheet
Dim SaveToDirectory As String
Dim CurrentWorkbook As String
Dim CurrentFormat As Long
CurrentWorkbook = ThisWorkbook.FullName
CurrentFormat = ThisWorkbook.FileFormat
' Store current details
Hi Rahul,
Which version of Excel are you using?
Regards
Andy
On Sat, Aug 7, 2010 at 5:08 PM, rahul axyin.ra...@hotmail.com wrote:
When you open a workbook and then close it with out making any
changes, you are prompted as follows:
Do you want to save the changes to Filename.xls?
Microsoft
* in the *New Workbook* task pane.
2. Click the *Calculation* tab. Under *Calculation*, click *Manual*.
Click to clear the*Recalculate before save* check box.
3. Click *OK*.
Regards,
Andy
On Sat, Aug 7, 2010 at 5:52 PM, Aindril De aind...@gmail.com wrote:
Hi Rahul,
Which version of Excel
Hi I have responded to your email
sent before pl chk and see if this is what u wanted
Regards,
Andy
On Thu, Aug 5, 2010 at 9:48 AM, prabhakar thakur prabhakarthak...@gmail.com
wrote:
Hi All,
Please help.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Wed, Aug 4,
Sorry got your name wrong
On Thu, Aug 5, 2010 at 10:22 AM, Aindril De aind...@gmail.com wrote:
Hi Prabhat,
This is happening because the column date contains actual dates and not
months. However I have added a column called month, which takes care of the
issue.
PFA the solution Its
Looks like a part of the content in the file is corrupt..and cannot be
repaired
Regards,
Andy
On Mon, Aug 2, 2010 at 3:56 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi all
This is a excel file and its not opening normally can anybody fix the
problem.
Regards,
Deepak
--
Which version of Excel are you using??
In Excel 2003:
To allow unsigned macros to run, the *Trust all installed add-ins and
templates* check box must be selected on the *Trusted Publishers* tab of the
*Security* dialog box. This option is selected by default. If it is not
selected (recommended),
Use =SUMPRODUCT(A1:A3,B1:B3)
Assuming Column 1 is A and Column 2 is B
Cheers
Andy
On Thu, Jul 22, 2010 at 11:42 AM, Rave Patwal ravepat...@gmail.com wrote:
Please help to add the product of two columns e.g.
Column1Column2
23 119
8954
63
You can simply use SUMIFS if you are using excel 2007
On Tue, Jul 20, 2010 at 11:49 AM, saggi realsa...@gmail.com wrote:
=SUM(IF(($A$1:$A$15=A2)*($D$2:$D$50=D8)*($C$3:$C$30=C5),1,0))
This way you can use Sum IF formula for 3 Condition
--
Try this
http://www.forgram.com/
http://www.forgram.com/Regards,
Andy
On Tue, Jul 20, 2010 at 12:59 AM, Al ali6...@gmail.com wrote:
Dear All :
I have bunch of xml files, i would like to convert them in to an
excel sheet ..
how can this be done ?
Thanks in advance
Al
--
http://www.youtube.com/watch?v=r0S2CQd46C4
On Tue, Jul 20, 2010 at 9:33 PM, Aindril De aind...@gmail.com wrote:
Try this
http://www.forgram.com/
http://www.forgram.com/Regards,
Andy
On Tue, Jul 20, 2010 at 12:59 AM, Al ali6...@gmail.com wrote:
Dear All :
I have bunch of xml files
Dear Nadine,
Assuming cell A1 has Apr-Jun. In Cell B1 you can
type =MONTH(1RIGHT(A1,3))-MONTH(1LEFT(A1,3)) to get the desired result.
Cheers,
Andy
On Thu, Jul 15, 2010 at 10:43 PM, Nadine S n8dine4ma...@yahoo.com wrote:
If a cell says Apr - Jun what formula is there to count how many months
Thanks Dave...
This opens a new angle of experimenting with Excel for me...
Cheers!!
Andy
On Thu, Jul 15, 2010 at 9:53 PM, Vijay Aggarwal vjaggarwal2...@gmail.comwrote:
Hi Dave,
It's really amazing!!!
How could u do this??
regards,
Vijay
On Tue, Jul 13, 2010 at 4:54 AM, Dave
Hi Alex,
Please find attached the solution.
I have used the following code inside a module
Sub village()
' This loop runs until there is nothing in the last cell
' Aindril De (Andy)
Do
ActiveCell.Value = [village] ActiveCell.Value [/village]
ActiveCell.Offset(1, 0).Select
Hi Venkat,
*
The purpose of a loop is to get Excel to repeat a piece of code a certain
number of times. How many times the code gets repeated can be specified as a
fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as
many times as there are rows of data).
Loops can be
Hi Sajid,
Would it be possible for you to share a sample sheet
Regards,
Aindril
On Mon, Jul 5, 2010 at 10:23 AM, SAJID MEMON sajidwi...@hotmail.com wrote:
Hi
Dear I want in excel, when i press enter key cursor should go to particular
cell example: my cursor is at A1 and after press enter
Hi Rajender,
Use the following VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rg As String
MsgBox Target.Address has been selected 'displaying the selected cell
address
rg = Split(ActiveCell.Address, $)(1) 5 'getting the column name and
createing the range column
Hi Iqbal,
I don't know the way out.
However, though it does not show up because of its length, you can still do
a text filter with Containg option and search for something unique in that
string to show that up in the result.
Regards,
Andy
On Mon, Jul 5, 2010 at 5:04 PM, Iqbal Muneeb
Sorry for the Typo
please read text filter with Containg option ascustom text filter with *
contains* option
Regards,
Andy
On Mon, Jul 5, 2010 at 5:59 PM, Aindril De aind...@gmail.com wrote:
Hi Iqbal,
I don't know the way out.
However, though it does not show up because of its length, you
Hi Sameer,
PFA the solution,
Regards,
Aindril
On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh ssw...@gmail.com wrote:
I want avoid sorting the data as far as possible .
thanks
On Mon, Jul 5, 2010 at 5:49 PM, WizExcel ssw...@gmail.com wrote:
Dear Experts,
want to know if there is way /
Hi Rajender,
I am not quite sure how would you want to do it. However there is a very
simple solution mentioned in the link below, which almost does what you are
trying to achieve.
http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html
Hi Radhe,
PFA the attached solution
Regards,
Andy
On Wed, Jun 30, 2010 at 12:44 PM, Radhe Sham radhe2...@gmail.com wrote:
Hi Group
I have data which has repeated values for a set of product every month for
12 months
Need the output as total for each product ( sumif formula helps here)
Hi Magan,
Can u please send a sample file
Regards,
Andy
On Mon, Jun 28, 2010 at 8:09 AM, CA MAGAN DEEP AGGARWAL
magandeepc...@gmail.com wrote:
DEAR MEMBERS
I WANT TO CREATE A WORKBOOK CONTAINING DIFFERENT WORKSHEETS. FIRST
WORKSHEET WILL BE A MASTER WORKSHEET AND ALL OTHER WORKSHEETS ARE
Hi,
Would it be possible for you to attach a sample sheet?
Regards,
Andy
On Sat, Jun 26, 2010 at 4:34 AM, Nadine S n8dine4ma...@yahoo.com wrote:
I have two worksheets:
Sheet 1 contains extracted data from an application
Sheet 2 is my working file
I need to match 3 different columns in
Hi Venkat,
This can be achieved using array formulas in Excel.
Suggest you to look into the discussion in the attached link that should
resolve your issue:
http://www.mrexcel.com/forum/showthread.php?t=312142
Regards,
Andy
On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c venkat1@gmail.com
You Can use Mailmerge
On Thu, May 27, 2010 at 3:23 PM, vibs vvibhor.ve...@gmail.com wrote:
Dear Members,
I have to send the emails using Microsoft Outlook to multiple users
individually (And not to all of them in one go) with their respective
records. For example,
Users Pending
1 - 100 of 222 matches
Mail list logo