$$Excel-Macros$$ Looking For Payroll Executive / Sr. Executive
Looking for Payroll Executive / Sr. Executive with 1.5yrs to 3.5yrs of work experience in Payroll Domain/Statutory compliance / retrial benefits in a medium or large organization. Good understanding of salary structures, employee benefits, tax rules and / or retrial benefits essential. Person Should have Good Communication Skills and Hands on Command in Excel. Please call @ 9711772297 or Drop your resume at rahul.gan...@aol.in / rahul.gan...@videocon.com - Rahul Gandhi -- 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 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 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 workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ MIS Opening
I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll Employee and One in Master Franchisee of United Colors of Benetton. Package 2.5-3 Lac. Please call @ 9711772297 Regards Rahul Gandhi -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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
$$Excel-Macros$$ Investment Declaration
Guys, I need a help of your expertise. I want to send email to all the employees of my organisation for their investment declaration. Would request your help that how will i do this. In Mail there is a table in which employee enter there declaration and press on submit button. as they press the submit button with the help of macro automatically we receive the email from them. I know its sounds lammy but i received the above task from my boss. Regards Rahul Gandhi +91-9711772297 -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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
$$Excel-Macros$$ Re: Number sequentially, skipping blank cells
Can you please let us know what exactly you require in output On Jan 7, 4:01 am, scoobysnack88 scoobysnac...@gmail.com wrote: Does anyone have a formula or vbs to accomplish the sequential numbering as listed here? The rows with no information would get a nill and the next cell would not break the number sequence. 1 5t67 2 g786 3 1234r 4 ty765 5 24567u 6 78ytr89 7 56ytre 8 re45789 9 2ewqs78 10 45iyunhg -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Dear Team, I Checked the appendedlinks, It only shows the Format, I want my output in bold format. Thanks On Nov 29, 3:54 pm, roberto mensa robb@gmail.com wrote: 2010/11/29 Chandra Shekar chandrashekarb@gmail.com Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar get.cell returns (not set) information about the formatting, location, or contents of a cell. A function used in a formula can return a value. It cannot make any changes to the workbook. There are some exceptions: Merge UnMerge AddComment ClearComments InsertIndent regards r -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Sir, Thanks for the prompt action, But I have a Data of 9000 Employees. I have to Send the Letters to Employees without using the Mail Merge. Only with The Hlp of Concatenate. Eg. =Your Salary is increased with Rs. A1/- Please find enclosed attachment which contains the breakup of amount What actually I want is the Value which is derived from A1 should be Bold. Thanks. Rahul Gandhi On Nov 28, 9:37 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Rahul, I dont think there is any existing function using which you can bold at text. Considering your problem, I have thought of one smart way :- let say A1 has the text which needs to be bold. Go to B1 and type the formula =a1. Now apply conditional formatting in B1 that if cell B1 is not blank, then text should be bold. (=not(isblank(b1)) :) Best Regards, DILIPandey On 11/28/10, Rahul Kamal Gandhi myname.ra...@gmail.com wrote: Guys, Can anyone Help me to Bold the text with the help of Formula Eg. A1 Cell Contains ABC I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) And My output should be *ABC* But in Bold Format Any Formula or Code. Please Guys I am Struck Regards, Rahul Gandhi +91-9711772297 -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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/pages/discussexcelcom/160307843985936?v=wall;... -- Sent from my mobile device Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ An Excel Query.for duplicate value)..
Great Job Done Dilip... Regards, Rahul Gandhi On Jul 23, 6:42 pm, Dilip Pandey dilipan...@gmail.com wrote: You are always welcome..!! And formula logic is explained below:- =OFFSET($D$1,SMALL(IF($B$2:$B$51=$G$7,ROW($B$2:$B$51),),ROW(1:1))-1,0) So, I am offsetting the heading D1 in the array which contains the data rows related with Emp ID 10779 and here I am considering the min(smallest) row so that I can offset the heading D1 to the first match and if you drag the same formula to down it will take the second smallest one.. and so on.. and this is why I have used Row(1:1) in the formula, which will automatically changes to Row(2:2) automatically upon drag. Get back to me if you still face some challenge. Note:= I have applied the conditional formatting to the solution which will hide the #N/A and other errors, alternatively this can be accomodated in the formula itself if you want. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jul 23, 2010 at 6:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thank you Dilip Ji to Solve my problem...but i couldn't understand logic of formula.. Thanks, Noorain On Fri, Jul 23, 2010 at 6:24 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Noorain, Though pivot table can be a good tool to solve your problem, but I have done the same using formulas. Please check the attached file and let me know if this helps. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jul 23, 2010 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, An Employee iD comes in a column three or four times..i want to display all infomation in next column (Types of Reimbursment) behalf of Emp ID.. Please see attached file..to clearfy. -- Thanks regards, Noorain Ansari -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks regards, Noorain Ansari -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ PLEASE HELP WITH ATTACHED DATA
I Think in particular this scenerio we have one more function of Concatenate or . that also helps us to do the same, at the other hand this formula is also very suitable for so many conditions.. Thanks again sir. On Jul 23, 6:33 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Hari, I have achieved the desired result using array functionality in Vlookup function. See the attached file and let me know if this helps. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Jul 23, 2010 at 4:38 PM, HARI NAIR hari.shrin...@gmail.com wrote: I want to fill the basic rate column automatically from the rate column(Please refer the attached file, which considers all three columns factors, like, PO NO, Thickness. Width, Quality. Not a single column factor. Please Help, Any how, thanks to prajapatiji for sending me the solution which I earlier sent, in which only single colunm factor is looking (i.e. Quality) Regards, Hari -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe DATA - Vlookup with multiple criteria - by DILIpandey.xls 91KViewDownload -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Excel - Macros training in Excel 2003
Thanks a Ton.. Nikhil That's a great Help.. On Jul 10, 10:02 pm, Nikhil Shah nikhil201...@gmail.com wrote: Dear Friends Here i am sending One URL For Excel - Macro Training in excel 2003. http://www.familycomputerclub.com/excel/excel2003_macros.html( With Video ) In English Hindi also I think , it gives some knowledge about how to write macro.. Regards Nikhil Shah -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Dear Group Help Me Regarding Conditional Formating
Please press Alt + O + D over there you can create a new rule for Conditional Formatting. Regards, Rahul Gandhi On Jun 4, 12:40 pm, Jai jaihumtu...@gmail.com wrote: Pleaese Check the Attachment -- Thanks For Mail. CONDITIONAL FORMATING.xlsx 10KViewDownload -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ How to insert sheets name in cells
Mahesh, To Insert a Workbook Name, the Formula below formula will work =MID(CELL(filename),FIND([,CELL(filename)) +1,FIND(],CELL(filename))-FIND([,CELL(filename))-1) To insert the Sheet Name, the below formula will work: =MID(CELL(filename),FIND(],CELL(filename))+1,255) To Pick the Path: =MID(CELL(filename),1,FIND([,CELL(filename))-1) Regards, Rahul Gandhi. +91-9711772297 On May 24, 3:13 pm, Mahesh mahender.bi...@gmail.com wrote: Dear All, I have around 200 xls files in a folder now i want to make an index of all these files into a new file(xls). Need ur hepl. -- With Love, Mahesh Bisht -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ need VB code for Excel Macro
I think when you are sending the mails it will ask you to press Yes to continew and no to cancel. You have to download Express Click yes Software to automate the program, it is easily available in Internet. Regards, Rahul Gandhi. +91-9711772297. On May 22, 11:54 pm, Prem Narayan premnarayan2...@gmail.com wrote: hi, I have made an excel macro for sending files through Outlook. When I run this macro then it asks for opting option of yes, no or cancel. I have to send the 90 files this way so I do not want to choose every time Yes. Please help me getting the vb code so that it do not asks again and again the above option. Please let me know if you need more detail Thanks in advance! Prem Narayan -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ URGENT Request
can you please share the example of your query On May 12, 2:33 pm, Azhar Rai azhar@gmail.com wrote: Hi Members I have an excel sheet with huge text data and at the beginning of each cell text string there are names (mostly single names) I want to count the number of letters in the first word (that is the name I referred to above). Please tell some excel function that does this work for me. Thanks and regards in advance for urgent replies. AZHAR RAI Cell: +92 333-552-7731 Skype: azhar.rai -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ VLookup on Data Table
can you please share the sample with us so that we can try on the above query. Regards, Rahul Gandhi On May 12, 12:03 pm, uu uugan...@gmail.com wrote: What I would like is under column D to be able to select one store number at a time from the data sort filter. What I would like to do is have a VLookUp in cell “I8” for the range of store numbers in column D and have the store name appear depending on what single store is shown while using the Data Sort Filter in cell “I8”. So if I use the Data Filter in column D and only shows store #7 I would like the vlookup to recognize that and show the name in cell “I8”. -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Fwd: Brackets Before after Words
Or you can use the Concatenate formula to work on the same. Regards Rahul Gandhi. On May 10, 6:20 pm, big smile bigsmile...@gmail.com wrote: Hellow Friends. Can it is possible to do the following [ =C1 ] I am taking the name from the C1 I want Bracket [ ] before after word so that i can change adjust the cell size. Ex. --[Mr. Guru Datt ] the word Guru Datt had taken from C1 cell Thanks Have a nice time. Mother Teresa:- If we cannot love the person whom we see, how can we love god, whom we cannot see ? -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ CC in Mail Merge
Guys, I wanted to add CC or Multiple Receipients in a Mail Merge. Is there be any Possiblity then please let me know. Regards Rahul Gandhi. -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell
Guys I am very Sorry for turning up very late and giving you an alarm with respect to that all the above formula will not work if we found any alphanumeric string Lets take an example if we have appended string then the above formula will not work. Hello my 9711 no is in 77 alpha numeric 2297 string, and my 14 home address is 49 Sorry Dave and Harmeet ! Regards, Rahul Gandhi +91-9711772297 On Apr 1, 4:15 pm, Dipika Mallya blraspirants...@gmail.com wrote: Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links.http://j.mp/gate2010csithttp://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DMhttp://anonomi.com/inamehttp://anonomi.com/DM On Wed, Mar 31, 2010 at 2:24 AM, paulwillekens paul.johan.willek...@gmail.com wrote: Hi Abhidha, Please specify what the result is you look for... is it jdsdnc versus 2123 versus asdd ... or only extraction of the number 2123 ? is it iofruif versus 68732 versus fnw ... or simply 68732 ? do digits appear separated by alphabetical characters on some occasions or never? As soon as I get that cleared out, I'll send you the routine you need... Greetings, Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using remove me as the subject. -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Please help me
Can you please give me the example so that we can atleast try to help you out with query. On May 2, 6:58 pm, sidhantha suchit s.suc...@gmail.com wrote: hi sir I m new to this group right now i m doing a project on stock market and i have to do lot of calculation ,I know its my duty but can if any one help me its reduce my task because i have to apply in 1000 BSE listed company . what i have to calculate Volatility (daily) Jump in script Mean Return with sensex co relation I download all the data of 1000 company for 248 days trading . please if any one help me -- Sidhantha Suchit (248592) BBM “Dream the impossible dream, Fight the unbeatable foe, Strive with your last once of courage To reach the unreachable star.” -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Kndly Solve my Problem
Hey if in case you don't have the excel 2007 and you have to work on xl 2003 then you may use the concatenate or function to work on the above fove formula. On May 2, 8:17 am, Asheesh Arora asheeshinsura...@gmail.com wrote: Dear All, Please help, In column A:A dates are there In column B:B Condition are there In column C:C Clubbing of the two is there Now I want to countif() who had cleared jumpstart =01-04-2010 Asheesh Arora -- -- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group athttp://groups.google.com/group/excel-macros/subscribe Book1.xlsx 17KViewDownload -- -- 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-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Median in Pivot Table
Guys, Can anyone help me to Get the Median Value in Pivot Table. Actually I am working on huge data and I have to send the any types of analysis which is based on Median Values. Please try it your end. Regards Rahul Gandhi. 9711772297 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://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 HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to Extract Data from a Line written in a cell.
Guys, I am facing some problem to Extract the A/c no. from Line written in Particular Cell. There is only 2 Unique things 1. A/c No. should be starts from 9. 2. Length of A/c no. is 10 digits. Example. A1 = EMI of Rs. 800 From A/c No. 9089655463 A2 = From A/c No. 9826438564 Debt EMI 300 A3 = Ac No 9658489652 EMI Amt 200 Friends I have 8 Files Consisting 200 Sheets Each and Each Sheet Consists around 2 to 3 Rows of Data with the same type of Entry. Can any one please help me out to extract the data. Regards Rahul Gandhi. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe