Re: $$Excel-Macros$$ Help on Week Formula

2017-07-25 Thread Aindril De
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 https://groups.google.com/d/optout. > -- Warm Regards, Aindril De Ph: 9811300157

Re: $$Excel-Macros$$ Re: needed formula to convert hejri date to gregorian date

2016-05-08 Thread Aindril De
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 https://groups.google.com/d/optout. &g

Re: $$Excel-Macros$$ please help me GRK

2013-03-02 Thread Aindril De
roup 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 http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/gro

Re: $$Excel-Macros$$ how to insert logo in excel print

2013-02-06 Thread Aindril De
unsubscribe 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 http://groups.google.com/group/excel-macros?hl=en. > For more options,

Re: $$Excel-Macros$$ Sumproduct Formula Required

2013-01-11 Thread Aindril De
If you Delete the rows mentioned.. then the formula you have mentioned works On Fri, Jan 11, 2013 at 2:09 PM, amar takale wrote: > No problem hide row delete,no matter. > > > On Fri, Jan 11, 2013 at 1:59 PM, Aindril De wrote: > >> Dear Amar, >> >> You are g

Re: $$Excel-Macros$$ Sumproduct Formula Required

2013-01-11 Thread Aindril De
; To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- Warm Regards, Aindril De Ph: 9811300157 -- Join official Facebook page of this forum @ https://www.facebook.com/discus

Re: $$Excel-Macros$$ is that is sunday

2012-08-17 Thread Aindril De
mail to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-04 Thread Aindril De
--- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-02 Thread Aindril De
> To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Warm Regards, Aindril De Ph: 9811300157 -- FORU

Re: $$Excel-Macros$$ Addition of Formula in Pivot

2012-05-17 Thread Aindril De
s-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ----------

Re: $$Excel-Macros$$ suggest a formula on this attachement

2012-05-16 Thread Aindril De
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 wrote: > Hi, > > Please correct my formula on this attachment. > > > On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote: > >> Hi, >> >>

Re: $$Excel-Macros$$ suggest a formula on this attachement

2012-05-16 Thread Aindril De
Hi Smitha, Attached is the soln. Cheers, Andy On Wed, May 16, 2012 at 2:31 PM, Smitha S R 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, like Please >

Re: $$Excel-Macros$$ Need help in ranking with multiple criteria

2012-04-23 Thread Aindril De
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 wrote: > > Hi Exp

Re: $$Excel-Macros$$ Week Ending formula help.

2012-04-21 Thread Aindril De
, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-15 Thread Aindril De
---------- > To post to this group, send email to excel-macros@googlegroups.com > -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ hindi version of excel

2012-01-17 Thread Aindril De
--------- > To post to this group, 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 t

Re: $$Excel-Macros$$ shortcut key .

2011-12-17 Thread Aindril De
Hi Try this: http://dmcritchie.mvps.org/excel/shortx2k.htm Cheers, andy On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use c

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

2011-12-07 Thread Aindril De
Sorry NOT USING TRIM On Wed, Dec 7, 2011 at 2:39 PM, Aindril De 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 wrote: > >> Dear Laksh

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

2011-12-07 Thread Aindril De
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 wrote: > Dear Lakshman, > > You are not able to do the SUM as the data in the last column has leading > and trailing spa

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

2011-12-07 Thread Aindril De
or confidential data 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 > --

Re: $$Excel-Macros$$ Formula Help

2011-12-07 Thread Aindril De
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 some

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-07 Thread Aindril De
://www.w3.org/TR/REC-html40*";> - Mr. Aindril De Mr. Aindril De 2011-12-07T08:39:05Z 14.00 - < OfficeDocumentSettings xmlns="*urn:schemas-microsoft-com:office:office*"> - 7995 16275 240 75 False False - - <Ali

$$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-05 Thread Aindril De
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 ti

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-04 Thread Aindril De
>>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> >>> >>> -- >>> Regards >>> Rajan verma >>> +91 9158998701 >>> -- >>> FORUM RULES (934+ members already BANNED for violation) >>> >>> 1)

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

2011-12-03 Thread Aindril De
answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-pr

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-01 Thread Aindril De
48 PM, Divaker Pandey 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 wrote: > >> Thanks all.. >> >> >> On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh wrote: >>

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-01 Thread Aindril De
Thanks all.. On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh wrote: > =LARGE(A1:G1,2) > Regards > jeet > > On Thu, Dec 1, 2011 at 3:51 PM, Aindril De 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

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-01 Thread Aindril De
-ansari.blogspot.com/> > > On Thu, Dec 1, 2011 at 3:51 PM, Aindril De 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 ha

$$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-01 Thread Aindril De
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 UD

Re: $$Excel-Macros$$ Need Help with IF(AND formula

2011-11-22 Thread Aindril De
OTE : Don't ever post personal or confidential data 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 D

Re: $$Excel-Macros$$ Help Required

2011-11-15 Thread Aindril De
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 wrote: > Dear Experts, > > How can I make the qty against particular

Re: $$Excel-Macros$$ Convert Date to month

2011-11-15 Thread Aindril De
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, N

Re: $$Excel-Macros$$ Listing name of worksheet & renaming them

2011-11-13 Thread Aindril De
Pl chk this, http://support.microsoft.com/kb/812386 Cheers, Andy On Sun, Nov 13, 2011 at 1:36 PM, Amit Desai (MERU) wrote: > 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 name. > > ** ** >

Re: $$Excel-Macros$$ Query related to subtotal and condition

2011-11-11 Thread Aindril De
; > ---------- > 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)

Re: $$Excel-Macros$$ Help Required.xlsx

2011-11-11 Thread Aindril De
eaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workboo

Re: $$Excel-Macros$$ Help Required.xlsx

2011-11-11 Thread Aindril De
---------- > 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 t

Re: $$Excel-Macros$$ Validation

2011-10-31 Thread Aindril De
> > NOTE : Don't ever post personal or confidential data 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 RULE

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

2011-10-31 Thread Aindril De
t; NOTE : Don't ever post personal or confidential data 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 Unified

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-04 Thread Aindril De
Hi Ayush, Great Going Brother Keep up the Good Work... Cheers, Andy On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain 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 support and > con

Re: $$Excel-Macros$$ Urgent Help needed-Dashboards

2011-07-21 Thread Aindril De
t;><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Warm Regards, Aindril De Unified Learning Pvt Ltd. Ph: 9811300157 -- --

Re: $$Excel-Macros$$ SUMIFS

2011-07-19 Thread Aindril De
vba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><&g

Re: $$Excel-Macros$$ Simple Code

2011-07-17 Thread Aindril De
ttp://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 > > <><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

2011-04-06 Thread Aindril De
-- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-

Re: $$Excel-Macros$$ Re: कविता : महिमा SUMPRODUCT की

2011-03-12 Thread Aindril De
t links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.qui

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-28 Thread Aindril De
-- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutor

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

2011-02-22 Thread Aindril De
I go for 1) building XL-lence - Andy On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th

Re: $$Excel-Macros$$ Wedding Planner

2011-02-22 Thread Aindril De
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 wrote: > The most expensive wedding ever was that of Vanisha Mittal, daughter of > world’s 8th richest person Lakshmi Mittal, to investment banker Amit Bhatia > in 2004. It c

Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-15 Thread Aindril De
Hi Mike, Please use: =VLOOKUP(A2,Sheet1!B:B,1,0) instead. Regards, Andy On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike wrote: > I am struggling with this and wondering if you could help.. > > Worksheet 1 Column A & B > Keyword Category > telecom Telecom > tele com#N/A > > Worksheet 2 Colu

Re: $$Excel-Macros$$ Official launch of Knowledge Portal - discussexcel.com

2011-02-02 Thread Aindril De
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 wrote: > Hello e

Re: $$Excel-Macros$$ if formula help

2010-12-07 Thread Aindril De
Hi Abhinda, PFA the solution.. Regards, Andy On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > 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, subsequelntly I hve tried

Re: $$Excel-Macros$$ Need it in seperate excel sheets

2010-11-30 Thread Aindril De
Hi Manjunath, The solution provided in the link should suffice: http://www.mvps.org/dmcritchie/excel/saveas.htm Regards, Aindril On Tue, Nov 30, 2010 at 2:50 PM, Manjunath C wrote: > Hi > > Can anyone help me, as I Have data in each tab, I need

Re: $$Excel-Macros$$ sum duplicate value

2010-11-14 Thread Aindril De
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 wrote: > Hi Everyone. > > Can someone explain I have data in sheet 1 The columns Name and Production > . Now I want to fetch data in sheet 2 . I use

Re: $$Excel-Macros$$ Please help regard this question

2010-11-11 Thread Aindril De
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."

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

2010-11-10 Thread Aindril De
from the URL. > * > Regards, > Ayush Jain > > On Tue, Nov 9, 2010 at 5:27 PM, Aindril De wrote: > >> 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 the

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

2010-11-09 Thread Aindril De
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 wrote: > Dear Group Members, > > Good news for all of you !! > > Now

Re: $$Excel-Macros$$ small help

2010-11-09 Thread Aindril De
Hi Sidhu, Please find attached the solution. Regards, Andy On Tue, Nov 9, 2010 at 3:36 PM, sudarshan rampe wrote: > hi friends > plz find the attached sheet in which i want a formula in which if i enter > the month it should give no. of days of a month in the next column. please > help me out

Re: $$Excel-Macros$$ Urgent Help needed

2010-11-02 Thread Aindril De
,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 wrote: > Hi Ayoub, > > Can you please explain this: > > Of these columns s

Re: $$Excel-Macros$$ Urgent Help needed

2010-11-02 Thread Aindril De
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 wrote: > Good afternoon > I need some help on a project that is buzzing ma head > attach

Re: $$Excel-Macros$$ OPEN EXCEL - Needs your support and enthusiasm...

2010-11-01 Thread Aindril De
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 wrote: > Dear Members, > > We're proud to launch OPEN EXCEL under the GNU P

Re: $$Excel-Macros$$ vlookup? sumproduct? sumif? argghhh!?

2010-10-11 Thread Aindril De
Hi Michael, It would be easy for anyone in the group to respond, if you can send a set of sample data. Regards, Andy On Tue, Oct 12, 2010 at 5:35 AM, MikeMikeMike wrote: > First of all thank you for any effort put in this direction. I am > having problems with a couple excel formulas that I rea

Re: $$Excel-Macros$$ Rupee symbol on PC

2010-10-08 Thread Aindril De
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 the

Re: $$Excel-Macros$$ Conditional Sum or Sumproduct.

2010-10-07 Thread Aindril De
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 wrote: > I am looking for conditional sum i.e. sum based on criteria. But neither > Sumproduct nor SUMIFS and Pivot serve the purpose. > > Attached

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-04 Thread Aindril De
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 wrote: > Congratulations Ayush Jain. Really Very proud of you man. > > On 10/4/10, rajasekhar praharaju wrote: > > hearty congratulation

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-03 Thread Aindril De
Congratulations Brother!! You deserved it!!! Cheers, Andy On Sun, Oct 3, 2010 at 3:47 PM, Ayush 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 technical communities fo

Re: $$Excel-Macros$$ Hi

2010-09-30 Thread Aindril De
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 3

Re: $$Excel-Macros$$ use in vlookup isna and isblank iserror

2010-09-22 Thread Aindril De
Hi Praveen, Can you be more specific with your question and if possible send a sample sheet in response to this email with some dummy data and explaination of the required result. Regards, Andy On Wed, Sep 22, 2010 at 4:52 PM, praveen kumar wrote: > hello > Dear Sir, > this is praveen > i have

Re: $$Excel-Macros$$ Cubic spline interpolation macro in VBA

2010-09-20 Thread Aindril De
Hi Pratik, Dont know much about this, however I have googled this up for you: http://www.business-spreadsheets.com/forum.asp?t=120 please check if this works Regards, Andy On Sun, Sep 19, 2010 at 12:34 AM, Pratik wrote: > Hi, > > Can anyb

Re: $$Excel-Macros$$ Random Numbers generation

2010-09-20 Thread Aindril De
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 wrote: > Hi Giorgio, > > Use the following UDF. > > *Function RandLotto(Bottom As Integer, Top As Integer, _ > > Amount

Re: $$Excel-Macros$$ Stock Monitoring from Raw data

2010-09-18 Thread Aindril De
You can use a pivot Table to resolve this issue On Sat, Sep 18, 2010 at 4:16 PM, Kal xcel 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 > > -- > > -

Re: $$Excel-Macros$$ Help: Date to Days conversion

2010-09-18 Thread Aindril De
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

Re: $$Excel-Macros$$ Random Numbers generation

2010-09-17 Thread Aindril De
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 Top)

Re: $$Excel-Macros$$ What is UBOUND and L Bound In VBA (Excel Macros)

2010-09-05 Thread Aindril De
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 followin

Re: $$Excel-Macros$$ Formula for Military Time Calculations

2010-09-03 Thread Aindril De
Hi John, Could you send a sample set of data. Regards, Andy On Thu, Sep 2, 2010 at 11:41 PM, JohnA 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 hours from militar

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Aindril De
> > One more thing the soultion given by Michael Brumby that i know sir Then > also thanks for the answer. > > Thanks > > Have a nice day > CP SAVLA > > > > > > > On Thu, Sep 2, 2010 at 1:05 PM, Aindril De wrote: > >> Hi, >> >>

Re: $$Excel-Macros$$ How to create Speedometer chart in Excel

2010-09-02 Thread Aindril De
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 wrote: > Hi Experts, > > > -- > Pankaj Pandey > Bhopal > > -- > > --

Re: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE

2010-09-02 Thread Aindril De
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 wrote: > Respected Excel Guru's > > How to make the macro so that > > When ever i start the file my cursor goes into

Re: $$Excel-Macros$$ extract only product name

2010-09-01 Thread Aindril De
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: http://www.eggheadcafe.com/software/aspnet/28074391/need-to-find-first---f

Re: $$Excel-Macros$$ Need Help in Cross tab

2010-08-21 Thread Aindril De
Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack wrote: > Hi Shariq > I've done this with worksheet functions, not VBA. > The ori

Re: $$Excel-Macros$$ Ageing of data

2010-08-21 Thread Aindril De
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 h

Re: $$Excel-Macros$$ Birthdays list formula or macro

2010-08-20 Thread Aindril De
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 (A

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

2010-08-12 Thread Aindril De
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 Regards,

Re: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

2010-08-11 Thread Aindril De
Hi Noorain, Vlookup cant do this.. However u can use the Offset and Match formula combination to do this.. The following link has the solution... Look at the section "Left Lookups" http://www.cpearson.com/excel/TablesAndLookups.aspx Regards, Andy On Wed, Aug 11, 2010 at 2:46 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ save all sheets as csv and KEEP xls format open for edit (Excell 2003)

2010-08-09 Thread Aindril De
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 f

Re: $$Excel-Macros$$ Open pipe delimited file

2010-08-09 Thread Aindril De
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

Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

2010-08-07 Thread Aindril De
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 wrote: > Hi Rahul, > > Which version of Excel are

Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

2010-08-07 Thread Aindril De
Hi Rahul, Which version of Excel are you using? Regards Andy On Sat, Aug 7, 2010 at 5:08 PM, rahul 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 Excel recalculates

Re: $$Excel-Macros$$

2010-08-04 Thread Aindril De
Sorry got your name wrong On Thu, Aug 5, 2010 at 10:22 AM, Aindril De 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 solu

Re: $$Excel-Macros$$ Need Help

2010-08-04 Thread Aindril De
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 wrote: > Hi All, > Please help. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > On Wed, Aug 4, 2010 at 10:49 PM,

Re: $$Excel-Macros$$ Format Problem

2010-08-02 Thread Aindril De
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 wrote: > Hi all > > This is a excel file and its not opening normally can anybody fix the > problem. > > Regards, > Deepak > > -- > > ---

Re: $$Excel-Macros$$ how to enable macros?

2010-07-30 Thread Aindril De
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), E

Re: $$Excel-Macros$$ How to ADD product of two columns in a single cell

2010-07-22 Thread Aindril De
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 wrote: > Please help to add the product of two columns e.g. > > Column1Column2 > > 23 119 > 8954 > 63 32 > >

Re: $$Excel-Macros$$ XML files to Excel

2010-07-20 Thread Aindril De
http://www.youtube.com/watch?v=r0S2CQd46C4 On Tue, Jul 20, 2010 at 9:33 PM, Aindril De wrote: > Try this > > http://www.forgram.com/ > > <http://www.forgram.com/>Regards, > Andy > > > On Tue, Jul 20, 2010 at 12:59 AM, Al wrote: > >> >> Dear All

Re: $$Excel-Macros$$ XML files to Excel

2010-07-20 Thread Aindril De
Try this http://www.forgram.com/ Regards, Andy On Tue, Jul 20, 2010 at 12:59 AM, Al 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 > > -- > > -

Re: $$Excel-Macros$$ Need SUMIF with 3 criteria

2010-07-20 Thread Aindril De
You can simply use SUMIFS if you are using excel 2007 On Tue, Jul 20, 2010 at 11:49 AM, saggi 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 > > -- > >

Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

2010-07-15 Thread Aindril De
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 wrote: > Hi Dave, > > It's really amazing!!! > > How could u do this?? > > > regards, > Vijay > > On Tue, Jul 13, 2010 at 4:54 AM, Dave Bonallack > wrote: >

Re: $$Excel-Macros$$ Count months

2010-07-15 Thread Aindril De
Dear Nadine, Assuming cell A1 has Apr-Jun. In Cell B1 you can type =MONTH(1&RIGHT(A1,3))-MONTH(1&LEFT(A1,3)) to get the desired result. Cheers, Andy On Thu, Jul 15, 2010 at 10:43 PM, Nadine S wrote: > If a cell says Apr - Jun what formula is there to count how many months > that is? The month

Re: $$Excel-Macros$$ Help Reqired Loop in macros

2010-07-06 Thread Aindril De
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 cons

Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet

2010-07-06 Thread Aindril De
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]&quo

Re: $$Excel-Macros$$ Re: Running Count for particular data

2010-07-05 Thread Aindril De
Hi Sameer, PFA the solution, Regards, Aindril On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh wrote: > I want avoid sorting the data as far as possible . > > thanks > > > On Mon, Jul 5, 2010 at 5:49 PM, WizExcel wrote: > >> Dear Experts, >> >> want to know if there is way / function for having a

Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-05 Thread Aindril De
Sorry for the Typo please read "text filter with Containg option" as"custom text filter with * contains* option" Regards, Andy On Mon, Jul 5, 2010 at 5:59 PM, Aindril De wrote: > Hi Iqbal, > > I don't know the way out. > However, though it does not show up

  1   2   3   >