Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns
Dear green go through the attachment. it may help. -- *Great day,* *viper* On Fri, Aug 26, 2011 at 10:42 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Please provide sample sheet. On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar impedimenta.st...@gmail.comwrote: I have a series of spreadsheets that have data in them that needs to be formatted into 3 columns instead of one column. The data in Row 1 needs to go in row 1, column 1 Row 2 needs to go in row 1, column 2 Row 3 = Row 1, Col 3 Row 4 = Row 2, Col 1 Row 5 = Row 2, Col 2 Row 6 = Row 2 Col 3 Row 7 = Row 3, Col 1, etc to the end of the file. What would be the macro that I need to use? I have been tasked with loading this data into a program but am unsure how to get it into the correct format. Any help would be greatly appreciated. -- -- 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 -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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 -- -- 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 sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Multiple sorts on one Sheet
Hi Guys Wow, they work like magic. Thanks Ashish and Rajan. Some more new knowlege for me. Great work and thanks Charlie Harris On Aug 26, 5:58 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Try this: Sub SortList() On Error Resume Next Dim Record As Integer Record = ActiveSheet.UsedRange.Rows.Count For i = 1 To Record If Range(D i).Value = HD Then Range(D i + 1).Select ActiveCell.Resize(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column).Sort Range(F i) End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Friday, August 26, 2011 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Multiple sorts on one Sheet Hi On attached workbook there is a sheet tha has multiple lists with empty rows in between. No of empty rows can vary. What I am trying to do is sort each list on the list into say into col F ascending order. Once the first list sorted vba takes it onto the next list, until all lists have been sorted. The empty rows still remain. Each list is always started with a heading row which with a ' HD' ref in the same row D. Is this the best reference for finding each list. In plain English go to first entry of HD xldown to last entry in that list data sort by col F next list Your help would be appreciated. Thanks Charlie Harris -- ---- -- 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 linkhttp://www.facebook.com/discussexcel -- -- 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
Re: $$Excel-Macros$$ Need formula
Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. ** ** For Ex: I have two columns ** ** Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds *1* *2* ** ** Nw i would like to sort column 2 in such a way that There should be different list in column 2 **1. **The values found in column 1 **2. **The values not available in column 1 ** ** Please help me out of the problem -- -- 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 -- -- 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 sample2.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Pivot Table Percent of Column...
I have solve your worksheet but you must changed the presentation of your data. You must present your data like this Invoice#YearCat Dollar 123456 2006Cat15 234567 2006Cat15 345678 2006Cat15 123456 2006Cat24 234567 2006Cat24 345678 2006Cat24 123456 2006Cat33 234567 2006Cat33 345678 2006Cat33 987654 2007Cat13 876543 2007Cat13 765432 2007Cat13 987654 2007Cat24 876543 2007Cat24 765432 2007Cat24 987654 2007Cat35 876543 2007Cat35 765432 2007Cat35 And then, you put the Year in column, the Cat in Row and Dollar in the field Sum in your pivot table And you finish by changing the value setting of the Dollar item and you select % of Row total in the tab 'Show values as' On 25 août, 16:34, Robert Jacobs robertjacob...@gmail.com wrote: Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice# Year Cat1 Cat2 Cat3 123456 2006 $5.00 $4.00 $3.00 234567 2006 $5.00 $4.00 $3.00 345678 2006 $5.00 $4.00 $3.00 987654 2007 $3.00 $4.00 $5.00 876543 2007 $3.00 $4.00 $5.00 765432 2007 $3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values 2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values 2006 2007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- 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$$ Daily Interest calculator
HI Team , I am Trying to made the Daily Interest calculator, Please see the attached sheet and help me for the same. Looking forward your Co-operation Regards -- -- 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 Daly Intrest Calculator.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Job
-- Original message -- From:Source One Management Services Pvt.Ltd indira...@msourceone.com Date: 25 Aug 11 17:44:45 Subject: Urgent Requirement with Top MNC For : :Reporting Architecture To: The sender of this email is registered with Naukri.com as Source One Management Services Pvt.Ltd *Experience required for the Job:* 1 - 3 years *Annual Salary of the Job:* 1.0 - 3.0 Lacs *Job Location:* Bengaluru/Bangalore, Kolkata, Gurgaon *Dear Candidate,* Hi ! Hope you are doing well !! Our Client is a global management consulting, technology services and outsourcing company, with more than 190,000 people serving clients in more than 120 countries. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world’s most successful companies, Our client collaborates with clients to help them become high-performance businesses and governments. The company generated net revenues of US$21.58 billion for the fiscal year ended Aug. 31, 2010 We are looking for many candidates Infrastructure domain in the area of Reporting Architecture, please refer below in this mail for permanent roll. Roles available: 1.Reporting Architecture(Exp- 1 yrs to 3 Yrs) (Position is in Bangalore/Kolkata/Gurgaon) Role Description: Key Responsibilities: • Design, develop, generate, analyze and distribute data and reports. • Work with customer representatives on defining requirements and implementing changes • Responsible for generation and distribution of scheduled and ad-hoc reports . • Provide analysis of reports and reporting tools. • Streamline existing reports for process and functional effectiveness • Analyze data to ensure completeness and accuracy of reports. • Monthly upload of reports to the intranet / sharepoint sites. Qualifications: Education: • Bachelor’s degree (any) in Business Management, Commerce, Business Analysis or Statistics; or relevant experience in one of these fields. Work Experience: • Prior experience in reporting and data analytical skills is preferred. Skills in customer relationship management are important while gathering requirements. Kindly send your latest updated cvs with below details asap so that we process it further: Full Name: Present Location: Willing to relocate Bangalore/Kolkata/Gurgaon(Y/N): Present Company Name: Total IT Exp: Relevant Exp: Primary skills: Primary Role/Job at present company: which role/requirement you would like to prefer (please refer above in roles available): Any Other skills: Any certifications: Qualifications (Any Full time 10+2/Diploma(10+2+3)/Graduation is required with college name): DOB: Contact No : Present Salary: Expected Salary: Total Team Size: Total Onsite Exp: Notice Period: Kindly send your cvs asap so that we process it further. Also refer us few of your colleague and friends who would be interested for this. - Regards, Indira Source One Management Services Pvt. Ltd. 55/A, First Floor, Nanjappa Road, Shanthi Nagar, Bangalore-27, Karnataka, India. email : indira...@msourceone.com url : www.sourceone.co.in Is this job relevant to you? Yeshttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=yesmid=3779043 Nohttp://jobsearch.naukri.com/mynaukri/jobs_feedback.php?response=nomid=3779043 Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as *Source One Management Services Pvt.Ltd* (nasa...@msourceone.com, *, BANGALORE, Karnataka - 560001) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may: 1. Report abuse by forwarding this email to: complia...@naukri.comcompliance@naukri.+com 2. You can also Block this Companyhttp://my.naukri.com/BlockCompany/edit/cid/35943from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.comfor advise. ** *To be on the top of Employer's Resume Search Update Your Resume Nowhttp://www.naukri.com/tieups/tieups.php?othersrcp=4794 * *Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts.http://resume.naukri.com/resume-writing-services?fftid=73 Call 1800-102-5557 now! (Toll-Free)* -- *Best Regards,* *Venkat * *Chennai* * * * * --
RE: $$Excel-Macros$$ Pivot Table Percent of Column...
Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#YearCat1Cat2Cat3 123456 2006$5.00 $4.00 $3.00 234567 2006$5.00 $4.00 $3.00 345678 2006$5.00 $4.00 $3.00 987654 2007$3.00 $4.00 $5.00 876543 2007$3.00 $4.00 $5.00 765432 2007$3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values20062007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- 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 -- -- 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$$ thanks to all
Thanks a lot to all experts who give me positive responce about my query. agains thanks sajid memon -- -- 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$$ Fill empty cells with zero
We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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
Re: $$Excel-Macros$$ Fill empty cells with zero
Enter the number 1 in an unused cell and copy that cell to the clipboard. Highlight the range of cells in which you want blanks replaced by zeros (Go to Blank Cells). Choose *Edit *| *Paste Special *from the menu. In the * Operation *section of the resulting dialog box, select the *Multiply *option and click on *OK.*You have just multiplied every cell in the range by 1. Numeric cells won't change. Cells containing text data will be ignored. But any cell that was blank will now contain a zero. You could, of course, accomplish the same thing by copying a cell containing 0 to the clipboard and using *Add *rather than *Multiply *in the *Paste Special *dialog. Cheers, AJ On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Daily Interest calculator
Hi, request all of you Help me on this _, Regards, On Fri, Aug 26, 2011 at 1:25 PM, jocky Beta jocky6...@gmail.com wrote: HI Team , I am Trying to make the Daily Interest (cumulative) calculator, Please see the attached sheet and help me for the same. Looking forward your Co-operation Regards -- -- 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 -- -- 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
RE: $$Excel-Macros$$ Fill empty cells with zero
Press CTRL+G Goto Special Choose Blanks , It will select all Blank cell then Press 0 and Ctrl + Enter From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: Friday, August 26, 2011 3:38 PM To: excel-macros@googlegroups.com; ushadhvin...@gmail.com Subject: Re: $$Excel-Macros$$ Fill empty cells with zero Enter the number 1 in an unused cell and copy that cell to the clipboard. Highlight the range of cells in which you want blanks replaced by zeros (Go to Blank Cells). Choose Edit | Paste Special from the menu. In the Operation section of the resulting dialog box, select the Multiply option and click on OK.You have just multiplied every cell in the range by 1. Numeric cells won't change. Cells containing text data will be ignored. But any cell that was blank will now contain a zero. You could, of course, accomplish the same thing by copying a cell containing 0 to the clipboard and using Add rather than Multiply in the Paste Special dialog. Cheers, AJ On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.com wrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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 -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Fill empty cells with zero
Try Find and replace Option. *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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 -- ** * * * * -- -- 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
Re: $$Excel-Macros$$ Need formula
Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.com wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. ** ** For Ex: I have two columns ** ** Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds *1* *2* ** ** Nw i would like to sort column 2 in such a way that There should be different list in column 2 **1. **The values found in column 1 **2. **The values not available in column 1 ** ** Please help me out of the problem -- -- 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 -- -- 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 -- -- 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 sample2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr wrote: Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#YearCat1Cat2Cat3 123456 2006$5.00 $4.00 $3.00 234567 2006$5.00 $4.00 $3.00 345678 2006$5.00 $4.00 $3.00 987654 2007$3.00 $4.00 $5.00 876543 2007$3.00 $4.00 $5.00 765432 2007$3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values20062007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- 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 -- -- 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 -- -- 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 sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need formula
why not? simply use =IF(COUNTIF($A$3:$A$15,C3)=0,Text not found,Text found) pfa -- *Great day,* *viper* On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote: Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.com wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. ** ** For Ex: I have two columns ** ** Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds *1* *2* ** ** Nw i would like to sort column 2 in such a way that There should be different list in column 2 **1. **The values found in column 1 **2. **The values not available in column 1 ** ** Please help me out of the problem -- -- 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 -- -- 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 -- -- 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 -- -- 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 sample2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need formula
Thank u i would like to know is there any other formula in lookup or statistical or information On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear nannu, See attached sheet, if it help -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote: Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.comwrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. ** ** For Ex: I have two columns ** ** Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds *1* *2* ** ** Nw i would like to sort column 2 in such a way that There should be different list in column 2 **1. **The values found in column 1 **2. **The values not available in column 1 ** ** Please help me out of the problem -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Fill empty cells with zero
Try it through Coding Sub replace_by_0() Dim s As Range For Each s In Selection If s.Value = Then s.Value = 0 End If Next s End Sub -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 4:21 PM, Venkat CV venkat1@gmail.com wrote: Try Find and replace Option. *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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 -- ** * ** * -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Need formula
thank u but plz refer to my previous mail i also wanted tht array to be sorted with d help of formula On Fri, Aug 26, 2011 at 5:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear naanu, try it through Lookup =IF(ISERROR(VLOOKUP(C3,$A$3:$A$15,1,0)),Text Not Found,Text Found) On Fri, Aug 26, 2011 at 5:11 PM, naanu v naanu2...@gmail.com wrote: Thank u i would like to know is there any other formula in lookup or statistical or information On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear nannu, See attached sheet, if it help -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote: Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.comwrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- *Great day,* *viper * On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. ** ** For Ex: I have two columns ** ** Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds *1* *2* ** ** Nw i would like to sort column 2 in such a way that There should be different list in column 2 **1. **The values found in column 1 **2. **The values not available in column 1 ** ** Please help me out of the problem -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- -- 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.
RE: $$Excel-Macros$$ Need formula
Try this : =IF(ISERROR(MATCH(C3,$A$3:$A$15,0)),Text Not found,Text Found) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 4:57 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.com wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- Great day, viper On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. For Ex: I have two columns Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds 1 2 Nw i would like to sort column 2 in such a way that There should be different list in column 2 1. The values found in column 1 2. The values not available in column 1 Please help me out of the problem -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 -- -- 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
RE: $$Excel-Macros$$ Need formula
Try this to sort list in Array Function : Option Base 1 Function SortedList(rng As Range) As Variant Dim arr() As Variant Dim rw, cl As Double r = rng.Rows.Count cl = 1 ReDim arr(r, cl) arr = rng For i = 1 To r For j = 1 To r - i If arr(j, 1) arr(j + 1, 1) Then temp = arr(j, 1) arr(j, 1) = arr(j + 1, 1) arr(j + 1, 1) = temp End If Next Next SortedList = arr End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 5:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula thank u but plz refer to my previous mail i also wanted tht array to be sorted with d help of formula On Fri, Aug 26, 2011 at 5:16 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear naanu, try it through Lookup =IF(ISERROR(VLOOKUP(C3,$A$3:$A$15,1,0)),Text Not Found,Text Found) On Fri, Aug 26, 2011 at 5:11 PM, naanu v naanu2...@gmail.com wrote: Thank u i would like to know is there any other formula in lookup or statistical or information On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear nannu, See attached sheet, if it help -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote: Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.com wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- Great day, viper On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. For Ex: I have two columns Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds 1 2 Nw i would like to sort column 2 in such a way that There should be different list in column 2 1. The values found in column 1 2. The values not available in column 1 Please help me out of the problem -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/
RE: $$Excel-Macros$$ Need formula
Also use OPTION COMPARE TEXT if you are sorting list of Alphabets From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Friday, August 26, 2011 5:56 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need formula Try this to sort list in Array Function : Option Base 1 Function SortedList(rng As Range) As Variant Dim arr() As Variant Dim rw, cl As Double r = rng.Rows.Count cl = 1 ReDim arr(r, cl) arr = rng For i = 1 To r For j = 1 To r - i If arr(j, 1) arr(j + 1, 1) Then temp = arr(j, 1) arr(j, 1) = arr(j + 1, 1) arr(j + 1, 1) = temp End If Next Next SortedList = arr End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naanu v Sent: Friday, August 26, 2011 5:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need formula thank u but plz refer to my previous mail i also wanted tht array to be sorted with d help of formula On Fri, Aug 26, 2011 at 5:16 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear naanu, try it through Lookup =IF(ISERROR(VLOOKUP(C3,$A$3:$A$15,1,0)),Text Not Found,Text Found) On Fri, Aug 26, 2011 at 5:11 PM, naanu v naanu2...@gmail.com wrote: Thank u i would like to know is there any other formula in lookup or statistical or information On Fri, Aug 26, 2011 at 5:09 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear nannu, See attached sheet, if it help -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 4:57 PM, naanu v naanu2...@gmail.com wrote: Thank u so much , but i want in below format Aru fddfs Text found ihcx zesr Text found dst fddfs Text found cfdf zesr Text found eder dfds Text found dfds dfds Text found yes err Text not found fddfs dfsf Text not found dfds dsdas Text not found zesr xzcxc Text not found vdfd wewq Text not found zdfdf zcvz Text not found drer sdfds Text not found On Fri, Aug 26, 2011 at 11:51 AM, §»VIPER«§ viper@gmail.com wrote: Dear naanu Go through the attachment. it may help. or please make it clear with sample file -- Great day, viper On Thu, Aug 25, 2011 at 8:51 PM, naanu naanu2...@gmail.com wrote: I want to know the formula to find out the solution. For Ex: I have two columns Aru fddfs eder dfds ihcx zesr yes err fddfs dfsf dfds dsdas zesr xzcxc vdfd wewq dst fddfs dfds dfds cfdf zesr zdfdf zcvz drer sdfds 1 2 Nw i would like to sort column 2 in such a way that There should be different list in column 2 1. The values found in column 1 2. The values not available in column 1 Please help me out of the problem -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- -- 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
Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns
Should do it assuming layout as described -Original Message- From: GreenBriar Sent: Thursday, August 25, 2011 10:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns I have a series of spreadsheets that have data in them that needs to be formatted into 3 columns instead of one column. The data in Row 1 needs to go in row 1, column 1 Row 2 needs to go in row 1, column 2 Row 3 = Row 1, Col 3 Row 4 = Row 2, Col 1 Row 5 = Row 2, Col 2 Row 6 = Row 2 Col 3 Row 7 = Row 3, Col 1, etc to the end of the file. What would be the macro that I need to use? I have been tasked with loading this data into a program but am unsure how to get it into the correct format. Any help would be greatly appreciated. -- -- 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 -- -- 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 TransposeRESIZE.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ How can i fix my heading
Dear friends, I want to know that How can i fix first row colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- 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
Re: $$Excel-Macros$$ Need formula
thanks for vb code but i m nt much familiar with vb code if u give in formula it would be better so i can study the formula and can put in my work -- -- 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
Re: $$Excel-Macros$$ How can i fix my heading
use freeze pane http://www.techonthenet.com/excel/questions/freeze2_2011.php http://spreadsheets.about.com/od/excel101/ss/freeze_pane.htm On Fri, Aug 26, 2011 at 6:35 PM, anil kumar kmr7a...@gmail.com wrote: Dear friends, I want to know that How can i fix first row colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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: Cut Data from Rows and Paste into Columns
Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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
Re: $$Excel-Macros$$ Need a Formula or Macro
Just found this again. I still do NOT understand your need. Please explain in detail with examples. Please use proper definitions a file is called a workbook. NOT a sheet a worksheet within a file is called a worksheet. -Original Message- From: Baby Patel Sent: Wednesday, August 24, 2011 9:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro thanks for your assistance. Please take a look. Earlier did not work. Thanks, Smriti On 8/24/11, dguillett1 dguille...@gmail.com wrote: If you didn't solve this, I'll take a look? -Original Message- From: Baby Patel Sent: Thursday, August 18, 2011 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All these data are here in the zipped file. You can use price list to find the details. Thanks and regards, Smriti On 8/18/11, dguillett1 dguille...@gmail.com wrote: It would be very helpful if your data could result in an actual case with a real example. You ask to search for data that does NOT exist. -Original Message- From: Baby Patel Sent: Wednesday, August 17, 2011 8:08 AM To: excel-macros Subject: $$Excel-Macros$$ Need a Formula or Macro Hi Guys, I need an urgent help . Attached is the excel file for your reference. Issue : I want the result in the F coulmn of Sheet1. the Sku #from Coulmn B of Sheet 1 will be searched in A column of sheet2. If the SKU was found then it will check the Currency and Margin (B C column of Sheet 1) with Currency and Price Level ( B C column of Sheet2). If it matches then , it will take the respective value from column G of sheet 2 and will pop in column F of sheet1. Anyhelp will be highly appreciated. Thanks and regards, Smriti -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- -- Some important links for
Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns
Sub test() Dim i, interval, j As Long interval = 3 j = 2 For i = 1 To Sheets(1).Range(a1).End(xlDown).Row Sheets(1).Range(A i :A i + interval - 1).Copy Range(D j).Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True i = i + interval - 1 j = j + 1 Next End Sub On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar impedimenta.st...@gmail.comwrote: Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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$$ Reorder last and first names
I have a column that has the data formatted like this: (This is a different column than previous post) Smith, John M Smith, Alex Jones, Mary Jackson Harris, Greg P Diaz-Garcia, Brenda Maria T etc I want it to look like this (Note these are separate columns and those having two last names have no spaces instead of a space of hyphen, I can fix this in find and replace if needed) John Smith M Alex Smith Mary Jones Greg JacksonHarris P Brenda DiazGarcia Maria T Thanks you for any help. -- -- 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
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
Thanks to everybody for their suggestions. Fred - I couldn't layout my data the way you suggested, just due to the sheer number of rows it would have created. The data I provided was a joke compared to what is actually listed, and the number of categories is much, much more than the 3 I gave in my example. But I did keep your example in my resources for 'just in case' future spreadsheets. Daniel - I had found that page a while ago. As I mentioned in my post, it wasn't calculating the percent of the column that I wanted - it always gave me 100%. Thanks for the reply though. Viper - It took me a little digging (because your sample was EXACTLY what I needed) before I figured out how you accomplished what you accomplished. I did, however, figure it out, and it your methods work perfectly for what I needed. 5000 points to you, and thank you very much for your help. All of your suggestions are appreciated. Thank you for serving us little guys. You're awesome! On Aug 26, 6:31 am, §»VIPER«§ viper@gmail.com wrote: Hi please find the attachment it may help -- *Great day,* *viper * On Fri, Aug 26, 2011 at 2:13 PM, Daniel dcolarde...@free.fr wrote: Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Pivot Table Percent of Column... Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice# Year Cat1 Cat2 Cat3 123456 2006 $5.00 $4.00 $3.00 234567 2006 $5.00 $4.00 $3.00 345678 2006 $5.00 $4.00 $3.00 987654 2007 $3.00 $4.00 $5.00 876543 2007 $3.00 $4.00 $5.00 765432 2007 $3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values 2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values 2006 2007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip2. 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.com5. 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/discussexcel -- --- --- 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/discussexcel sample.xls 14KViewDownload -- -- 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
Re: $$Excel-Macros$$ Text to Numbers
Hi, It's in Text only just Copy and paste and change Format cells as a Number... *Best Regards,* *Venkat * *Chennai* On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know how to convert them in numbers.** ** *Cost by Activity* * * * * *Total Cost * *PM* *RR* *AR* *TYRES* *BATTERY* *Towing* 1,01,602.00 93,85,047.00 22,41,109.00 1,17,27,758.00 3,80,161.00 5,33,958.00 92,364.00 10,06,483.00 2,42,051.10 4,56,682.90 1,08,103.00 8,06,837.00 2,59,323.60 3,88,985.40 6,48,309.00 1,356,175.00 1,356,175.00 3,000.00 3,000.00 1,63,000.00 1,63,000.00 860,969.00 860,969.00 558,177.00 558,177.00 2,75,676.00 4,13,514.00 6,89,190.00 5,20,683.00 13,01,019.00 22,280.00 18,43,982.00 2,52,851.60 3,79,277.40 6,32,129.00 2,26,000.00 2,26,000.00 * 20,32,348.30 * * 1,32,50,483.70 * * 24,63,856.00 * * 1,356,175.00 * * 860,969.00 * *558,177.00 * * 20,522,008 * ** ** ** ** Best Regards, Amit Desai ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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 -- * * * * * * -- -- 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$$ Hi
I'd like to learn how ti use MACRO -- -- 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
Re: $$Excel-Macros$$ Text to Numbers
Hi, Remove the spaces and comma by Search and Replace (Ctrl+H) option. Then try converting to numbers. With Regards, Karthi On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know how to convert them in numbers.** ** *Cost by Activity* * * * * *Total Cost * *PM* *RR* *AR* *TYRES* *BATTERY* *Towing* 1,01,602.00 93,85,047.00 22,41,109.00 1,17,27,758.00 3,80,161.00 5,33,958.00 92,364.00 10,06,483.00 2,42,051.10 4,56,682.90 1,08,103.00 8,06,837.00 2,59,323.60 3,88,985.40 6,48,309.00 1,356,175.00 1,356,175.00 3,000.00 3,000.00 1,63,000.00 1,63,000.00 860,969.00 860,969.00 558,177.00 558,177.00 2,75,676.00 4,13,514.00 6,89,190.00 5,20,683.00 13,01,019.00 22,280.00 18,43,982.00 2,52,851.60 3,79,277.40 6,32,129.00 2,26,000.00 2,26,000.00 * 20,32,348.30 * * 1,32,50,483.70 * * 24,63,856.00 * * 1,356,175.00 * * 860,969.00 * *558,177.00 * * 20,522,008 * ** ** ** ** Best Regards, Amit Desai ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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 -- KARTHI KUMAR. N -- -- 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
Re: $$Excel-Macros$$ MIS Opening
for which location.. On Thu, Aug 25, 2011 at 10:16 PM, Rahul Gandhi myname.ra...@gmail.comwrote: 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 -- . -- -- 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
Re: $$Excel-Macros$$ Fill empty cells with zero
hey Usha, if blank cell come thru by formula then use if condition other wise use find and replace function On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote: We have some blank cells in excel (2007), which we want to fill with zero. what is the formula for the same? With regards, Usha -- -- 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 -- . -- -- 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
Re: $$Excel-Macros$$ Cut Data from Rows and Paste into Columns
Use pastespecial and transpose or try below link http://www.vbaexpress.com/kb/getarticle.php?kb_id=144 On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar impedimenta.st...@gmail.comwrote: I have a series of spreadsheets that have data in them that needs to be formatted into 3 columns instead of one column. The data in Row 1 needs to go in row 1, column 1 Row 2 needs to go in row 1, column 2 Row 3 = Row 1, Col 3 Row 4 = Row 2, Col 1 Row 5 = Row 2, Col 2 Row 6 = Row 2 Col 3 Row 7 = Row 3, Col 1, etc to the end of the file. What would be the macro that I need to use? I have been tasked with loading this data into a program but am unsure how to get it into the correct format. Any help would be greatly appreciated. -- -- 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 -- . -- -- 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
Re: $$Excel-Macros$$ Need formula
Just paste it in a Module and use this function in worksheet by Function Name : its a instant solution for your query : On Fri, Aug 26, 2011 at 6:38 PM, naanu v naanu2...@gmail.com wrote: thanks for vb code but i m nt much familiar with vb code if u give in formula it would be better so i can study the formula and can put in my work -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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
Re: $$Excel-Macros$$ How can i fix my heading
select A2 and Press Alt+ F F On Fri, Aug 26, 2011 at 6:48 PM, ashish koul koul.ash...@gmail.com wrote: use freeze pane http://www.techonthenet.com/excel/questions/freeze2_2011.php http://spreadsheets.about.com/od/excel101/ss/freeze_pane.htm On Fri, Aug 26, 2011 at 6:35 PM, anil kumar kmr7a...@gmail.com wrote: Dear friends, I want to know that How can i fix first row colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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
Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns
alos try this link http://www.vbaexpress.com/kb/getarticle.php?kb_id=144 On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar impedimenta.st...@gmail.comwrote: Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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 -- . -- -- 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
Re: $$Excel-Macros$$ How can i fix my heading
Use freeze window command of your excel to get rid of that problem. Sent on my BlackBerry® from Vodafone -Original Message- From: rajan verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 26 Aug 2011 21:43:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How can i fix my heading select A2 and Press Alt+ F F On Fri, Aug 26, 2011 at 6:48 PM, ashish koul koul.ash...@gmail.com wrote: use freeze pane http://www.techonthenet.com/excel/questions/freeze2_2011.php http://spreadsheets.about.com/od/excel101/ss/freeze_pane.htm On Fri, Aug 26, 2011 at 6:35 PM, anil kumar kmr7a...@gmail.com wrote: Dear friends, I want to know that How can i fix first row colam whenever we go down but heading in first row should be not moved. Thanks Anil -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Pivot Table Percent of Column...
try formula please find attachment... On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs robertjacob...@gmail.comwrote: Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#YearCat1Cat2Cat3 123456 2006$5.00 $4.00 $3.00 234567 2006$5.00 $4.00 $3.00 345678 2006$5.00 $4.00 $3.00 987654 2007$3.00 $4.00 $5.00 876543 2007$3.00 $4.00 $5.00 765432 2007$3.00 $4.00 $5.00 I need a pivot table that will sum all values for each category by year, then tell me what percent of that year's sales belonged to that category. I can get a pivot table to show each category by year with total sales like this: Values2006 2007 Cat1 $15.00 $9.00 Cat2 $12.00 $12.00 Cat3 $9.00 $15.00 BUT, I really need the percent of each category for that column. For instance, 2006 and 2007 both have $36.00 total sales. So I would want to know what percent of that $36.00 was for Cat1, Cat2, and Cat3. Something like this: Values20062007 Cat1 42% 25% Cat2 33% 33% Cat3 25% 42% Does anybody have any recommendations? I have tried Show Value As Percent of Column, but it always shows 100%. If I Show Value As Percent of Row, it shows what percentage of the total sales of Cat1 was sold for each year. i.e. - Cat1 would show 62% for 2006 and 38% for 2007. Any help would be GREATLY appreciated!!! Thank you! -- -- 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 -- . -- -- 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 multipal sum.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Text to Numbers
Hey Amit, open this e-mail in internet explores and then copy past On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends, ** ** I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know how to convert them in numbers.** ** *Cost by Activity* * * * * *Total Cost * *PM* *RR* *AR* *TYRES* *BATTERY* *Towing* 1,01,602.00 93,85,047.00 22,41,109.00 1,17,27,758.00 3,80,161.00 5,33,958.00 92,364.00 10,06,483.00 2,42,051.10 4,56,682.90 1,08,103.00 8,06,837.00 2,59,323.60 3,88,985.40 6,48,309.00 1,356,175.00 1,356,175.00 3,000.00 3,000.00 1,63,000.00 1,63,000.00 860,969.00 860,969.00 558,177.00 558,177.00 2,75,676.00 4,13,514.00 6,89,190.00 5,20,683.00 13,01,019.00 22,280.00 18,43,982.00 2,52,851.60 3,79,277.40 6,32,129.00 2,26,000.00 2,26,000.00 * 20,32,348.30 * * 1,32,50,483.70 * * 24,63,856.00 * * 1,356,175.00 * * 860,969.00 * *558,177.00 * * 20,522,008 * ** ** ** ** Best Regards, Amit Desai ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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 -- . -- -- 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
Re: $$Excel-Macros$$ Hi
http://chrisrae.com/vba/whatisvba.html http://www.excel-vba.com/ http://www.excel-vba-easy.com/ http://www.youtube.com/watch?v=t1vdt0FddsE On Fri, Aug 26, 2011 at 10:24 PM, Mohamed Youssouf youssouf.mohame...@gmail.com wrote: I'd like to learn how ti use MACRO -- -- 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
Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns
This worked like a charm. Thank you. On Aug 26, 6:53 am, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim i, interval, j As Long interval = 3 j = 2 For i = 1 To Sheets(1).Range(a1).End(xlDown).Row Sheets(1).Range(A i :A i + interval - 1).Copy Range(D j).Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True i = i + interval - 1 j = j + 1 Next End Sub On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar impedimenta.st...@gmail.comwrote: Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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$$ $$Reformatting First, Last and middle names$$
I have the following code which splits data from Column A so that column B has last name(s) and column C has first names and middle initial. How would I further code in excel to go only to Column C and put everything from the space on into a new column. Once done, I would want to delete all spaces and dashes in the worksheet and concatenate Columns B, C, and G. Smith,John A SmithJohn A Jones,Henry Peter JonesHenry Peter Jackson-Smith,Emily Marie Jackson-SmithEmily Marie Martinez Diaz,Juan Martinez DiazJuan Davies,David DaviesDavid Sub ReverseAndSplit3() Dim LastRow As Long Application.DisplayAlerts = False With Columns(1) LastRow = .Cells(65536, 1).End(xlUp).Row .TextToColumns Destination:=Range(B1), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _ Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1)) End With Application.DisplayAlerts = True End Sub Thanks for any and all help -- -- 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
Re: $$Excel-Macros$$ Help to create summary table count unique
Thx , I know all of the above my problem is to use all operations once Sum, Count, and Count unique !!! all, not separated 2011/8/26 NOORAIN ANSARI noorain.ans...@gmail.com Dear Sandeep, Please see attached sheet for Example... -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 10:51 AM, chhajersand...@gmail.com wrote: **Dear excelguru, Can u pls elaborate what is unique count? And how it helps? Sent on my BlackBerry® from Vodafone -- *From: *NOORAIN ANSARI noorain.ans...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 26 Aug 2011 10:49:39 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel chilexcel...@gmail.comwrote: hi all Please help to create summary table with unique count Summary table need: unique count (repeated) sum all count all file attachment -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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
Re: $$Excel-Macros$$ Help to create summary table count unique
in the example I use: 1 advanced filter 2 Pivot table 3 and formula for count unique i need macro for all in summary table 2011/8/26 ChilExcel chilexcel...@gmail.com Thx , I know all of the above my problem is to use all operations once Sum, Count, and Count unique !!! all, not separated 2011/8/26 NOORAIN ANSARI noorain.ans...@gmail.com Dear Sandeep, Please see attached sheet for Example... -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 10:51 AM, chhajersand...@gmail.com wrote: **Dear excelguru, Can u pls elaborate what is unique count? And how it helps? Sent on my BlackBerry® from Vodafone -- *From: *NOORAIN ANSARI noorain.ans...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 26 Aug 2011 10:49:39 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique Dear ChilExcel, For Unique Count... Use below function..with Ctrl+shift+Enter.. *=SUM(1/COUNTIF(I1:I28,I1:I28))* -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel chilexcel...@gmail.comwrote: hi all Please help to create summary table with unique count Summary table need: unique count (repeated) sum all count all file attachment -- -- 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 -- -- 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 -- -- 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 -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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
Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns
Could have been more efficient without selections or incrementing i as in my offering I previously sent Option Explicit Sub transposerows() Dim i As Long For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row Step 3 Cells(i, 1).Resize(3).Copy Cells(i, 2).PasteSpecial Transpose:=True Next i Columns(2).SpecialCells(xlCellTypeBlanks).EntireRow.Delete Columns(1).Delete End Sub -Original Message- From: GreenBriar Sent: Friday, August 26, 2011 12:59 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns This worked like a charm. Thank you. On Aug 26, 6:53 am, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim i, interval, j As Long interval = 3 j = 2 For i = 1 To Sheets(1).Range(a1).End(xlDown).Row Sheets(1).Range(A i :A i + interval - 1).Copy Range(D j).Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True i = i + interval - 1 j = j + 1 Next End Sub On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar impedimenta.st...@gmail.comwrote: Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- -- 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$$ Job:Senior Database Analyst
http://jobsearch.naukri.com/mynaukri/mn_newsmartsearch.php?xz=8_0_4qc=96679id=Senior Database AnalystPride Technologies ** ** *New User? Register Now*http://naukri.com/tieups/tieups.php?othersrcp=11497 Summary *Experience:* 2 - 6 Years *Location:* Chennai *Compensation:* Rupees 2,00,000 - 3,00,000 *Education:* UG - Any Graduate - Any SpecializationPG - Any PG Course - Any Specialization *Industry Type:* BPO/ITES *Role:* Business Analyst *Functional Area:* Corporate Planning, Consulting *Posted Date:* 24 Aug Job Description Write and understand Microsoft SQL. Be able to write SQL statements, stored procedures and views using industry best practices for security and efficiency Database and code management, review and documentation Work with application developers to know how applications work and testing results Work with implementation team to build, customize and roll new ERP solution to organization Work with consultants to design and built database structure. Knowledge in VB Macros to do some automation in Excel. *Keywords:* MIS, Data Analyst, Excel, Access, Desired Candidate Profile - The candidate should have good comunication skills - The candidate should have good knowledge in EXcel, Access and SQL Queires. - The candidate should be able to work in work in night shift. Company Profile Pride Technologies, LLC is a leading information technology and business process solutions firm that offers highly customized solutions at cost-effective prices. Headquartered in New York, NY - Pride Technologies offers a broad geographic reach with offices throughout the U.S., India and Brazil. Leveraging more than 20 years of experience Pride has enhanced its core competency of IT staffing services by creating client-centric, cost-effective IT and business process solutions. Pride Technologies serves Fortune 1000 clients in the financial services, retail, healthcare, and insurance industries offering contingent Staff Augmentation of IT professionals, Vendor Management, IT Hardware Procurement Services and Business Processing Outsourcing.Contact Details *Company Name:* Pride Technologies *Website:* http://www.pridetech.com *Executive Name:* MADHU *Address:* Pride Technologies Module No: 1108, D- South, 11th Floor, No:4, Rajiv Gandhi Salai, Tidel Park, Taramani,Chennai - 113 CHENNAI,Tamilnadu,India 62 *Telephone:* 91-44-39191400 -- * * * * * * -- -- 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
Re: $$Excel-Macros$$ Hi
Hi, See below links.. http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://excelvbatutor.com/ *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 26, 2011 at 8:54 PM, Mohamed Youssouf youssouf.mohame...@gmail.com wrote: I'd like to learn how ti use MACRO -- -- 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 -- * * * * -- -- 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$$ JOB
** javascript:void(0) *Experience:* 3 - 5 Years *Location:* Pune *Education:* UG - B.Com,B.Sc - Any Specialization,B.Tech/B.E. PG - Post Graduation Not Required *Industry Type:* BPO/ITES *Role:* Business Analyst *Functional Area:* DBA, Datawarehousing *Posted Date:* 24 Aug Job Description Senior Business Analysts are required to demonstrate strong analytical skills, efficiently process and deliver large volumes of regular reports and work on many discreet pieces of ongoing and project work. Equally important is the ability to prioritise their own work producing required deliverables effectively, accurately and on time. Team work skills are essential, with the ability to support and take directions. Senior BAs will also have team lead responsibilities for a growing team of BAs. This role is primarily to support our rapidly growing client base with both reporting and analytical support. This will be for our many monthly reporting and project needs. *This position is based in Pune and will support clients in APAC time zone beginning at 7:30 a.m. * *Role Activities * •Follow and managed the deliverable schedule for the team and ensure delivery of output within client timeframes and quality •Communicate proactively and effectively with the International Head Office operations •Create and update documentation on month end reporting process flows •Obtain data from various sources and check for quality and completeness prior to commencing the processing •Provide lean capabilities for process improvements in a BPO environment •Proactively raise any source data issues early in the process •Look at ways to overcome any deviations to the normal data formats and processes •Create and run business rules to classify data in set schema and commodity classes •Provide feedback to the schema to develop and refine the output to become more useful to sourcing and category management needs •Run business rules to cleanse data in preparation for upload into desired format/tool •Refresh monthly spend cubes and dashboards with cleansed data and check output quality •Run control total checks to ensure reconciliation of spend numbers •Be accountable for separate work streams and a wide range of client deliverables •Be able to interpret requests and determine what is required to achieve the desired goal •Learn the Client nominated tools (Spend Analysis and Reporting Tools), and use them to their full effect to deliver the desired outcomes •Proactively propose improvement suggestions to 1) processes, 2) data or 3) report layout design, for improvements to the end delivered product •Support the Client Operations, Category Management, Consulting Client Engagement Managers in delivering projects *Keywords:* BI, Business Intelligence, Analytics,MIS, Reporting, Excel, VBA, MS Access, BIQ, Tableau, Spend, Procurement, Sourcing Desired Candidate Profile *Education *Demonstrated academic achievement with qualifications in Information Technology, Engineering, Business, Economics, Mathematics, Law or Science. Bachelors Degree and equivalent work experience is preferred *Experience Competence necessary *•Strong leadership skills, including ability to motivate and manage people •A *minimum 3 – 5 years *of work experience in operational, procurement, sourcing, analysis or reporting •Ideally some experience in either a BPO, corporate or professional services environment •Strong analytical skills •Interest and capability in working on operational issues •Confident ability to prioritise own work often within tight deadlines •Ability to work in teams and take direction •Strong and proficient in MS Excel (essential) including working knowledge of filters, sorting, pivot tables, basic formulas, vlookups, advanced formatting techniques and advance data manipulation techniques •Highly valued skills include MS Access (additional), VBA Macros (additional), Tableau (additional), BIQ (additional) *Behaviours Attributes *• Strong customer service orientation ; Results outcome oriented • Able to interpret and follow process document guidelines • Enthusiastic and able to drive own activities • Good concise English verbal and written skills (with clients, suppliers and internally) • Able to communicate to the point in a quick and effective manner • Proactively manage time and communication with stakeholders from Head Office • Entrepreneurial spirit Company Profile Since 1996 Denali Group has helped supply chain and sourcing professionals at Fortune 1000 companies transform their organizations’ capabilities, mitigate risk, increase efficiencies, and drive cost savings. Our complementary blend of consulting, market intelligence, talent staffing, and on-demand sourcing execution services provide integrated solutions for procurement, logistics, and sourcing professionals. Because Denali Group is dedicated solely to sourcing and supply chain improvements, we understand our clients’
RE: $$Excel-Macros$$ Text to Numbers
Dear Amit Select the Range and Run This Code : It will Convert your Text data to Number Sub MakeNumbers() Dim n As Double Dim cell As Range For Each cell In Selection.Cells n = cell.Value cell.Value = n Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Friday, August 26, 2011 7:18 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Text to Numbers Dear Friends, I have recd the following data in email body itself wants to convert them in number to have sum of it. Let me know how to convert them in numbers. Cost by Activity Total Cost PM RR AR TYRES BATTERY Towing 1,01,602.00 93,85,047.00 22,41,109.00 1,17,27,758.00 3,80,161.00 5,33,958.00 92,364.00 10,06,483.00 2,42,051.10 4,56,682.90 1,08,103.00 8,06,837.00 2,59,323.60 3,88,985.40 6,48,309.00 1,356,175.00 1,356,175.00 3,000.00 3,000.00 1,63,000.00 1,63,000.00 860,969.00 860,969.00 558,177.00 558,177.00 2,75,676.00 4,13,514.00 6,89,190.00 5,20,683.00 13,01,019.00 22,280.00 18,43,982.00 2,52,851.60 3,79,277.40 6,32,129.00 2,26,000.00 2,26,000.00 20,32,348.30 1,32,50,483.70 24,63,856.00 1,356,175.00 860,969.00 558,177.00 20,522,008 Best Regards, Amit Desai _ Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- 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 -- -- 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
RE: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns
Try this Option Base 1 Sub DoSomething() Dim SrcRng As Range Dim OptRng As Range Dim arr() As Variant Dim r As Integer Dim c As Integer Dim k As Integer Set SrcRng = Application.InputBox(Please Select the Source Range, , , , , , , 8) Set OptRng = Application.InputBox(Please Select the OutPut Cell, , , , , , , 8) r = (SrcRng.Rows.Count / 3) + 1 c = 3 ReDim arr(r, c) k = 1 For i = 1 To r For j = 1 To c arr(i, j) = SrcRng.Cells(k, 1).Value k = k + 1 Next Next OptRng.Resize(r, c).Select Selection.Value = arr End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of GreenBriar Sent: Friday, August 26, 2011 7:16 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 -- -- 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 -- -- 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
RE: $$Excel-Macros$$ Hi
You can Visit these sites : www.ozgrid.com www.cpearson.com http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ www.akoul.blogspot.com www.excelpoweruser.com www.ozgrid.com akoul.posterous.com www.mrexcel.com www.contextures.com www.rondebruin.nl peltiertech.com chandoo.org www.mvps.org/links.html www.vbaexpress.com www.functionx.com www.freevbcode.com www.excelforum.com https://www.facebook.com/ExcelLover https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897 https://www.facebook.com/microsoftexcel https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2Fh=014d2; ref=ts http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o nline/ Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohamed Youssouf Sent: Friday, August 26, 2011 8:54 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Hi I'd like to learn how ti use MACRO -- -- 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 -- -- 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