Re: $$Excel-Macros$$ Re: Count of Text
Attaching the solution of this problem. using COUNTIF formula. Regards, Lavprasad On Sun, Nov 22, 2009 at 12:30 AM, Mahavir Bhardwaj virbhardwaj...@gmail.com wrote: Dear All please find enclosed herwith a file with my problem. Pls help Mahavir 2009/11/21 Aindril De aind...@gmail.com Attach a file in reply to this email.. On Fri, Nov 20, 2009 at 3:55 PM, mahavir virbhardwaj...@gmail.comwrote: i dont know how to attached file. pls tell me the procedure Mahavir On Nov 19, 10:50 pm, mahavir virbhardwaj...@gmail.com wrote: Pls help -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- - -- (¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´ Best regards, Veer -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Problem(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Concatenate, including blank fields
attached herewith the solution of your question. Regards, Lavprasad On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying to concatenate 8 columns, all of which containe either a single character or a blank. When I use the concatenate funciton it leaves out the blank spaces and runs all the letters together (without spaces). Is there a way that a blank cell can be concatenated as a blank space? Can I put something in the blank field that will show up as a space (I can't use a character that will show up). Thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Concatenate Solution.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Count of Colored Cells
Hi Pooja, Its possible in MS Excel 2007. There u can filter by colour count the coloured cells. Regards, Lavprasad On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma vatspoojav...@gmail.comwrote: Hi Friends, I have a query regarding counting of Colored cells. I want to know, is it possible to count the no. of cells filled with a particular color with the help of a formula. If yes then please guide me and help me in resolving this. Attached is a file which has an example, how I want to count the cells. -- Best Regards Pooja Sharma -- ___ Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Need Help regarding split Emp. Name Emp. ID
Dear Friends, I am downloading the employee data from our portal. In, there is employee name Emp. ID both are in the same column. I want to split Emp. Name Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No..xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need Urgent Help regarding Text to column
Dear All, Please help me. Attaching herewith the downloaded data. I want to do just text to column. But when I do this, the data after special character (Square) has been deleted. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Text to column.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Settings in Excel - Calculation - Manual/Automatic
Hi Rajesh, For the Calcuation Setting you have to go to *Tools - Options - Calculation* ** In calculation pane there is options of : *Automatic* *Automatic except table* *Manual* ** I hope this is useful to You. Regards, Lavprasad Kori MIS Executive Hindustan Unilever Limited Mob : 9867931351 On Thu, Feb 26, 2009 at 12:00 PM, Rajesh Srinivasaraghavan taur...@gmail.com wrote: Hi, I have come across instances where the calculation settings have got modified from Calculation to Manual. I found this issue when my colleagues ask me why there are not able to see results of a formula (when they drag the formula down). My colleagues had no clue about this settings so i am sure they did not change the settings!! Anyone with an explaination? Regards Rajesh -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help need to count values
Dear Ashish, Thanks for the reply. When I go to below mentioned site. There is macro program. I had gone by step by step. but I am not getting the answer. There is an #Name error has occured. Please help me attached the same file. Thanks Regards, Lavprasad Kori MIS Executive - Water Hindustan Unilever Limited Tel. 022 - 39833428 On Sat, Feb 21, 2009 at 1:43 PM, Ashish Jain 26may.1...@gmail.com wrote: -- Hi LavPrasad, Here is the solution to your query: http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html Regards Ashish Jain Analyst and Demand-Co-ordinator, CSC Australia Microsoft Office Specialist Technical Trainer - Excel and VBA 0-40-48-43 -- On Sat, Feb 21, 2009 at 11:12 AM, Lavprasad Kori lavprasa...@gmail.comwrote: Dear All, I want an urgent help for the below metioned data. Attaching hererwith the data file. I want a help to count the zero value if it comes continues 5 times or more than 5 times then count as 1 time If it comes continue less than 5 times then ignore it. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Hindustan Unilever Limited Tel. 022 - 39833428 -- Regards Ashish Jain -- --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help for filter
Hi Ajay, This is Lavprasad. The horizontal filter is very good. But I want to know that when I copy the data filtered data then hidden data is also coppied. For that what we have to do. Regards, Lavprasad On 2/18/09, Ajay Varshney ajayvarshney21...@gmail.com wrote: The attached file can give you an idea to solve your problem. On Mon, Feb 16, 2009 at 4:49 PM, ram bhagath rb.worldw...@gmail.comwrote: Hello Group members, If I have a data in a row wise, will use auto filter option. But If I have data in coloum wise if I need to filter (horizental), how do this. suppose if have column no. 1,2,3..100, if I want to see only 2,4,8 like this.. If I go on hiding the col. ll tak more time. Is there any way to do this..?? Please help me. Can we do this without VBA. Thanks Ram. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Urgent Help need to count values
Dear All, I want an urgent help for the below metioned data. Attaching hererwith the data file. I want a help to count the zero value if it comes continues 5 times or more than 5 times then count as 1 time If it comes continue less than 5 times then ignore it. -- Thanks Regards, Lavprasad Kori MIS Executive - Water Hindustan Unilever Limited Tel. 022 - 39833428 --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~--- Count Help.xls Description: MS-Excel spreadsheet