$$Excel-Macros$$ Re: excel help me
On Saturday, January 6, 2018 at 7:55:55 AM UTC-8, Deepu Raj wrote: > > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > It has already been suggested to use the RIGHT function, but also use the VALUE function. Assuming the number is in A1 the formula =VALUE(RIGHT(A1,2)) in B1 should work. Thanks, David -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Excel Help
Hi David, let me know the fields and how would you want it to be created. Umesh On Mon, Jan 24, 2011 at 12:32 AM, DavidG goldstone.da...@googlemail.comwrote: how do i add a file? On Jan 21, 8:57 pm, DavidG goldstone.da...@googlemail.com wrote: Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any ideas or help will be greatly appreciated. Thanks -- -- 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$$ Re: Excel Help
how do i add a file? On Jan 21, 8:57 pm, DavidG goldstone.da...@googlemail.com wrote: Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any ideas or help will be greatly appreciated. Thanks -- -- 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: excel help
col_index_num is mandatory for vlookup function, range_lookup is optional. If range_lookup is not given it will take it as TRUE. One important point for using Vlookup is that the table array should be sorted on the first column. On Jul 21, 8:31 pm, preeti vora preeti86v...@gmail.com wrote: Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: excel help
Hi Preeti Pls let us know what you want to do, or if possible please attach a sample sheet. Regards Rajender Soni ! 750 322 55 50 On Jul 21, 8:31 pm, preeti vora preeti86v...@gmail.com wrote: Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Excel Help
Hi Karthik, Try below options:- 1. Go to this link:- http://www.meadinkent.co.uk/excel-color-calcs.htm Now using help given there, you can insert a new column and then you can filter out the colored cells based on this column. 2. Go to this group web discussion page and try looking some older post(s), I believe some members have given solutions to this type of query in the past one month or so. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/25/09, karthikeyan karthikeyansankar...@gmail.com wrote: HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- 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$$ Re: Excel Help
Hi Karthik, Try below options:- 1. Go to this link:- http://www.meadinkent.co.uk/excel-color-calcs.htm Now using help given there, you can insert a new column and then you can filter out the colored cells based on this column. 2. Go to this group web discussion page and try looking some older post(s), I believe some members have given solutions to this type of query in the past one month or so. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/7/09, karthikeyan karthikeyansankar...@gmail.com wrote: HI, How can i fillter the colored cells in excel. Except 2007 Txs karthik --~--~-~--~~~---~--~~ -- 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$$ Re: Excel-Help
Hi Paul, Appreciated your reply, I have downloaded a cvs file (from an online tool in my office and also from MS Access) and I try to view in Excel. It saturates number of row.. On 4/24/09, Paul Schreiner schreiner_p...@att.net wrote: You're WAY to frugal with your info... I have a data ... What FORMAT is the data in? Where are you getting it from? is more than the capacity of excel 2002. Is it because if there is too many rows? or too many columns? I mean, the answer if your file is: a) a text file b) that is sent from someone else (you don't have control of the source) and c) it has a million lines that are broken into 1,000 columns is a COMPLETELY different answer than if the data is coming from MicroSoft Access and your QUERY is returning the same million rows. Paul From: raafi barey raafiba...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, April 24, 2009 6:22:42 AM Subject: $$Excel-Macros$$ Excel-Help Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~ - 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: Excel-Help
You're WAY to frugal with your info... I have a data ... What FORMAT is the data in? Where are you getting it from? is more than the capacity of excel 2002. Is it because if there is too many rows? or too many columns? I mean, the answer if your file is: a) a text file b) that is sent from someone else (you don't have control of the source) and c) it has a million lines that are broken into 1,000 columns is a COMPLETELY different answer than if the data is coming from MicroSoft Access and your QUERY is returning the same million rows. Paul From: raafi barey raafiba...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, April 24, 2009 6:22:42 AM Subject: $$Excel-Macros$$ Excel-Help Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~ - 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: Excel-Help
U can download the Compatibility pack and u can retrieve the data http://office.microsoft.com/en-us/products/HA101686761033.aspx Regards Sathish Jalendran -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of raafi barey Sent: 24 April 2009 03:53 pm To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel-Help Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~-~--~~~---~--~~ - 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: Excel Help...
Hi Ashish, Thanks Alot. This is great. I am able to open the desired link. However now I need to copy the value of each cell in a column to the search field of this site and then click. I know that I can run a loop to copy value from each cell and then paste it in the search field. I then need to capture message on the screen and copy it to the adjascent cell. Can you please. Unfortunately I cannot tell you the site. Thanks Regards Ashkaran Badlani On Sun, Mar 15, 2009 at 12:47 PM, Ashish Jain 26may.1...@gmail.com wrote: Hi Ashkaran, Please mention the site where you want to do this. Please try this possible solution too. Possible Solution - http://www.excelitems.com/2009/03/access-search-engines-on-browser.html For more tips, tricks, downloads and problem solutions: visit -- http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (Excel) Specialist Technical Trainer - Excel and VBA Author - www.excelitems.com +91--40-48-43 On Mar 14, 4:36 am, Ashkaran Badlani ashkaran.badl...@gmail.com wrote: Hi Team, I have a list of numbers in an excel columns. I need to open a site and enter the numbers one by one in the search field of Open site and hit enter. I also need to capture the some information from the screen after clickling enter and then get back to the search page. Can anyone please help me with this. I also need to know about some good books which will help me to learn advanced VBA language. Can anyone suggest me any books. -- Thanks Regards Ashkaran Badlani -- Thanks Regards Ashkaran Badlani --~--~-~--~~~---~--~~ - 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: Excel Help
I'm not sure if his would help you? Download Personnel Timesheet 08-12-07.xls at http://normay.741.com/ Norman May On Sat, Jan 10, 2009 at 1:44 PM, How Do you? mydreambas...@hotmail.comwrote: I'm using excel to do weekly time sheet and I created another page/tab with in the same workbook and I'm trying to post job numbers between the two sheets. If I post a new Job number and it's not already on the control sheet I want to add, not + but include it in the job numbers. Anybody? --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---