$$Excel-Macros$$ Re: Need help for the below issue.
Hi Vijender, Its not working.. I have attached the XL file below pls look into the same. The right/left function wont work as date is not in a text formate. Regards, Vinu. 2008/11/5 vijender kumar [EMAIL PROTECTED] Hi.. This is very easy. Just use the left function/right function to get the data from one cell. like.. A1 B1 C1 11/4/2008 5:51:00 PM=left(a1,9) =right(a1,10) On 11/4/08, vinu [EMAIL PROTECTED] wrote: Hi All, I have a data like this in a single cell for eg A1 11/4/2008 5:51:00 PM. I need date in A2 cell and time in in A3 cell. How to do it. Plz help me. Thanks in advance. -- Vinu (¨`*.*´¨) Always `*.¸(¨`*.*´¨) Keep (¨`*.*´¨)¸.*´ Smiling! `*.¸.*´ --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- date.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Pls help me..
Chk attached file Regards Harish Upadhyay On 11/4/08, ram bhagath [EMAIL PROTECTED] wrote: Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- book1(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Pls help me..
Hi Ram, Solution is attached herewith in EXCEL. Use of Pivot table may give you this solution. Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ram bhagath Sent: Tuesday, November 04, 2008 6:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pls help me.. Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. Idea has dropped its roaming tariff for you to be in touch with your loved ones when away from home. Now outgoing and incoming calls at Re. 1/min and STD at Rs. 1.5/min while roaming. Happy Roaming! ideacellular.com E-Mail Domain is now idea.adityabirla.com E-Mail Domain An idea can change your life. ** LEGAL DISCLAIMER This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at [EMAIL PROTECTED] and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. IDEA Cellular Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail. --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- book1 (2).xls Description: book1 (2).xls
$$Excel-Macros$$ Re: How to lock the cells.
right click on cell and go to Format - Protection tab.. if locked box is checked, cell will locked after protecting the sheet. If hidden box is checked, cell formula will be hidden (i.e. will not show in formula bar) after protecting the sheet. To lock a range, select your range and then go to Right click - Format - Protection. _ There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. From: ram bhagath [EMAIL PROTECTED] To: excel-macros@googlegroups.com Sent: Tuesday, 4 November, 2008 6:18:31 PM Subject: $$Excel-Macros$$ How to lock the cells. Hello all, Could you pls explain me how to lock cells in the below scenario: - How to lock single cell - How to lock range of cells - how to hide the formula only for formula based cells. Regards, Ram. Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help for the below issue.
Use below functions: For date: =TEXT(A1,mm/dd/) For time: =TEXT(A1,hh:mm:ss AM/PM) A1 is the cell where the data (date and time) is stored. _ There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. From: vinu [EMAIL PROTECTED] To: MS Excel VBA Macros excel-macros@googlegroups.com Cc: [EMAIL PROTECTED] Sent: Tuesday, 4 November, 2008 5:54:12 PM Subject: $$Excel-Macros$$ Need help for the below issue. Hi All, I have a data like this in a single cell for eg A1 11/4/2008 5:51:00 PM. I need date in A2 cell and time in in A3 cell. How to do it. Plz help me. Thanks in advance. From Chandigarh to Chennai - find friends all over India. Go to http://in.promos.yahoo.com/groups/citygroups/ --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Pls help me..
Dear Ram Use Pivot Table, it is simpler then vlookup Regards On Tue, Nov 4, 2008 at 11:57 PM, ram bhagath [EMAIL PROTECTED] wrote: Hi all,, I have attached the file, and explained the proble there only. I wanted to pick amount from another table by formula. I tried with vlookup i didnt get answer. Pls help me. Regards, Ram. --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- Vlookup.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help for the below issue.
A2 =TEXT(A1,MM/DD/YY) -- u will find date 11/4/2008 A3 =TEXT(A1,HH:MM:SS AM/PM)-- u will find Time 5:51:00 PM Regards Harish Upadhyay On 11/4/08, vinu [EMAIL PROTECTED] wrote: Hi All, I have a data like this in a single cell for eg A1 11/4/2008 5:51:00 PM. I need date in A2 cell and time in in A3 cell. How to do it. Plz help me. Thanks in advance. --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Use of Array Formula or other method to create deduplicated list of text values?
Ladies Gents: I’m an experienced excel user (10+ years) and have encountered a problem that I cannot figure out. I’m creating a tool where there is a free text area where the users will input a list of locations (up to 60 values that can repeat and are in no particular order - some cells can be blank as well). Various analysis will be done on this data on a row by row basis and I need to create a list of these locations which is deduplicated and alphabetized on another sheet for summary calculations. I know that utilizing crystal reports one can utilize their array formulas to do a similar thing, but I cannot figure out how to do this in excel. Below is an example of the data: Washington, DC Arlington, VA Washington, DC Washington, DC Washington, DC Cary, NC Paris, FR London, UK Raleigh, NC Raleigh, NC Atlanta, GA Raleigh, NC The output I’m looking for is: Arlington, VA Atlanta, GA Cary, NC London, UK Paris, FR Raleigh, NC Washington, DC Ideally I’d like this to be formula driven rather than macro driven. I know that if I do my summary in a pivot table I can accomplish much the same thing but would like to avoid that as well. Any help would be greatly appreciated!! Thanks, Dave --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Excel Macros totaling like values
How do I create a macro in Excel that will count the number of like values in a cell? For Example: how many people live in each city in an excel spreadsheet of names and addresses --~--~-~--~~~---~--~~ 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 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---