$$Excel-Macros$$ Query on lookup with more than 1 lookup values
-- Hi All, I am trying to apply lookup in 2 dimensions wherein I have to get the value as per 2 lookup values (1 is there in the row and another in the column). I am attaching the workbook in which I am looking for the desired result. Please let me know if someone can help on this. [image: image.png] From the Table Array [image: image.png] *Best RegardsPooja Sharma* *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/CAKDmkFf7LgrBsx4m5d58SdP-vFCqUpFWnW_vkPz5fHzLeJim7w%40mail.gmail.com. Aging_of_Stock Table.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together
Thanks AshishI was making mistake while freezing the cells. Thanks for the support. Regards, Pooja On 21 Mar 2016 19:58, "Ashish Koul" <koul.ash...@gmail.com> wrote: > see attachment > > On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma <vatspoojav...@gmail.com> > wrote: > >> Hi Ashish, >> >> This is not working.It is giving 0 value. >> >> Regards, >> Pooja Sharma >> On 21 Mar 2016 19:30, "Ashish Koul" <koul.ash...@gmail.com> wrote: >> >>> =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) >>> >>> On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma <vatspoojav...@gmail.com> >>> wrote: >>> >>>> Hi All, >>>> >>>> Hi All, >>>> >>>> I have a query, if there is any possibility to apply Vlookup and >>>> Hlookup together to achieve results as required in the attached sheet. >>>> >>>> Regards, >>>> Pooja Sharma >>>> >>>> -- >>>> 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. >>>> >>> >>> >>> >>> -- >>> *Regards* >>> >>> *Ashish Koul* >>> >>> >>> *Visit* >>> http://www.excelvbamacros.in >>> Like Us on Facebook <https://www.facebook.com/excelvbacodes> >>> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >>> >>> >>> P Before printing, think about the environment. >>> >>> >>> >>> -- >>> 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. >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together
Hi Ashish, This is not working.It is giving 0 value. Regards, Pooja Sharma On 21 Mar 2016 19:30, "Ashish Koul" <koul.ash...@gmail.com> wrote: > =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) > > On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma <vatspoojav...@gmail.com> > wrote: > >> Hi All, >> >> Hi All, >> >> I have a query, if there is any possibility to apply Vlookup and Hlookup >> together to achieve results as required in the attached sheet. >> >> Regards, >> Pooja Sharma >> >> -- >> 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. >> > > > > -- > *Regards* > > *Ashish Koul* > > > *Visit* > http://www.excelvbamacros.in > Like Us on Facebook <https://www.facebook.com/excelvbacodes> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > > -- > 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. > -- 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.
$$Excel-Macros$$ query on usage of Vlookup and Hlookup together
Hi All, Hi All, I have a query, if there is any possibility to apply Vlookup and Hlookup together to achieve results as required in the attached sheet. Regards, Pooja Sharma -- 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. Sample Query.xls Description: application/msexcel
Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...
Hi Dhananjay, Rather than using Hyperlink, try using Insert - Object-Create from file-Browse and then give the path of the file and insert the required file as an object on your ppt. Regards Pooja On Mon, Jul 15, 2013 at 1:19 PM, Dhananjay Pinjan dppin...@gmail.comwrote: Hi Friends, I need to insert Excel file in PowerPoint presentation. I used Hyperlink' option. It is working fine on my PC. But when I send the same powerpoint presentation to another user, he is not able to access Excel File. It showing error. Pl. advice. Regards, Dhananjay -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST
Hi Priti and Ashish! Thanks a lot for your. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * On Sat, Jul 7, 2012 at 7:10 PM, priti_verma pritiverma1...@gmail.comwrote: *Please see the attached file* * * *Good information on this site about IST and BST:* * * * * http://wwp.greenwichmeantime.com/to/ist/to-bst/index.htm ** ** ** ** *__* *Regards* *Priti Verma* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Pooja Sharma *Sent:* 07 July 2012 6:54 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST ** ** Hi All, Is there any way in excel, that we can make a standard spreadsheet, to convert time from IST to BST and BST to IST for Regular and Daylight Saving Time as well. Waiting for experts solution. -- *Best Regards Pooja Sharma* ** ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST
Hi All, Is there any way in excel, that we can make a standard spreadsheet, to convert time from IST to BST and BST to IST for Regular and Daylight Saving Time as well. Waiting for experts solution. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ I want to learn VBA
Hi All, I want to learn VBA, therefore, could anybody suggest with a good link where I can learn it. -- *Best Regards Pooja Sharma* -- -- 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$$ pdf. to Excel
Hi All, I have a query regarding .pdf to excel. Is there any way that, I can transfer the files that are in .pdf format into excel?? -- Best Regards Pooja Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
$$Excel-Macros$$ help on .pdf to excel
Hi All the Champs, I've a query, is there any way to convert a .pdf file into an excel format?? If there is any way, the please guide the way.. -- Best Regards Pooja Sharma -- -- 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
Re: $$Excel-Macros$$ Require help on a condition
Thanks Sandeep, This is simplest way and yes the assumption is correct...the assumption sustains as it is assumed. Best Regards Pooja Sharma On Fri, Nov 20, 2009 at 8:13 PM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Hi, Find the attached sheet with formula. Regards Sandeep On Fri, Nov 20, 2009 at 10:35 AM, Sivakumar E.S emm...@gmail.com wrote: pooja Sharma Find attached an excel file with vba macro. place ur cursor anywhere in reference column and run macro... u will see result in next sheet Hope this helps Regards sivakumar On Thu, Nov 19, 2009 at 1:35 PM, Pooja Sharma vatspoojav...@gmail.comwrote: Hi All, I've attached a file in which, a data is mentioned with the required solution. If any body can help me in this, it will be of great help. -- Best Regards Pooja Sharma -- -- 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 -- -- 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 -- Best Regards Pooja Sharma -- -- 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$$ Require help on a condition
Hi All, I've attached a file in which, a data is mentioned with the required solution. If any body can help me in this, it will be of great help. -- Best Regards Pooja Sharma -- -- 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 Conditional result.xls Description: MS-Excel spreadsheet
Fwd: $$Excel-Macros$$ Re: Need a function or formula
Hi Kumar, Thanks for your kind help and support. But still when I'm trying this function in my database it is not showing the accurate way as it should be. I'm attaching the complete sheet where I've tried it with more data. Hope you will again resolve this. Best Regards Pooja Sharma On Wed, Nov 4, 2009 at 1:05 AM, Pooja Sharma vatspoojav...@gmail.comwrote: -- Forwarded message -- From: Chandra Gupt Kumar kumar.bemlmum...@gmail.com Date: Tue, Nov 3, 2009 at 11:50 AM Subject: RE: $$Excel-Macros$$ Re: Need a function or formula To: excel-macros@googlegroups.com Cc: vatspoojav...@gmail.com Dear Pooja Jee, Let me first thank you for the confidence you have showered on me. Further, the solution is attached for your kind consideration. Regards, Kumar -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Pooja Sharma *Sent:* Monday, November 02, 2009 11:53 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Need a function or formula Hi Kumar, Thanks for the help, but still difficulties are there, which is mentioned in the sheet itself. I think you can and will resolve these problems too. Regards, Pooja On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde *Sent:* Sunday, November 01, 2009 11:49 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Need a function or formula Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma vatspoojav...@gmail.com Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Need help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need a function or formula
Hi Kumar, Thanks for the help, but still two difficulties are there, which is mentioned in the sheet itself. I think you can and will resolve these problems too. Regards, Pooja On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar -- *From:* excel-macros@googlegroups.com [mailto: excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde *Sent:* Sunday, November 01, 2009 11:49 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: Need a function or formula Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma vatspoojav...@gmail.com Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Copy of Solution on the Data_Kumar.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need a function or formula
Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Required Solution on the Data.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need help regarding entering date
Hi All, In excel 2003, I want to add time in HH:MM:SS format and I tried it by changing the format cell with Time in that format but whenever I use the shortcut for entering time in the Cells, it doesn't show the change of seconds. The shortcut I use for Time is Ctrl + Shift + ; keys. If there is any other possibility then please guide me the way. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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$$ Count of Colored Cells
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 --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- Count of Coloured Cells.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need Macros for Track Changes
Hi Ashish, Thanks! for the reply. But in this case, anyone can stop the Track Changes. This won't work as a hidden kind of thing for others. The purpose behind this is, that whenever anyone make changes on the worksheet(which is in shared mode) and save it, then the changes should be highlighted in a diff. worksheet or workbook. Regards Pooja *** On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello Pooja To track changes on a new work sheet kindly follow the steps given below. 1. Activate the Track Changes Feature. 2. Assume that the changes have been made and saved in the work book. After changes have been made to the workbook, you can automatically create a new worksheet that lists all the changes that have been tracked. 3. Open the workbook and select (Tools -- Track Changes -- Highlight Changes. 4. Change When tab to All 5. In the same Highlight Changes box, Select List Changes on new sheet and press OK. 6. Another worksheet called History will be automatically created in your workbook. This will be inserted AFTER the last worksheet in your workbook. 7. However, remember that if you want a history of all changes, specially after restarting the workbook, copy the History Sheet to another file. And pressing Save after you have created the History File will delete this sheet. You will have to repeat the process mentioned in Steps 3-5 above again. Important point is to make sure that you change the tab to All as mentioned in Step 4 above. (I keep forgetting that) Hope this helps. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi On 7/9/09, Pooja Sharma vatspoojav...@gmail.com wrote: Hi All, I want to know, if there is any other option, i.e., other than Track Changes. I want to know in my excel sheet, if someone does any changes in any column/Row/Cell for e.g., Adding one row in between of existing rows, changing the values of cells. There is a restriction in Track Changes, if someone has stop the Track Changes option, then it won't work. Therefore, I need to protect my data and find out if any invaluable changes are going on in a different workbook or in the different worksheet. -- Best Regards Pooja Sharma -- Best Regards Pooja Sharma -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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 5,000 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: Need Macros for Track Changes
Hi Ashish, Thanks! for the reply. But in this case, anyone can stop the Track Changes. This won't woks as a hidden kind of thing for others. Regards Pooja On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello Pooja To track changes on a new work sheet kindly follow the steps given below. 1. Activate the Track Changes Feature. 2. Assume that the changes have been made and saved in the work book. After changes have been made to the workbook, you can automatically create a new worksheet that lists all the changes that have been tracked. 3. Open the workbook and select (Tools -- Track Changes -- Highlight Changes. 4. Change When tab to All 5. In the same Highlight Changes box, Select List Changes on new sheet and press OK. 6. Another worksheet called History will be automatically created in your workbook. This will be inserted AFTER the last worksheet in your workbook. 7. However, remember that if you want a history of all changes, specially after restarting the workbook, copy the History Sheet to another file. And pressing Save after you have created the History File will delete this sheet. You will have to repeat the process mentioned in Steps 3-5 above again. Important point is to make sure that you change the tab to All as mentioned in Step 4 above. (I keep forgetting that) Hope this helps. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi On 7/9/09, Pooja Sharma vatspoojav...@gmail.com wrote: Hi All, I want to know, if there is any other option, i.e., other than Track Changes. I want to know in my excel sheet, if someone does any changes in any column/Row/Cell for e.g., Adding one row in between of existing rows, changing the values of cells. There is a restriction in Track Changes, if someone has stop the Track Changes option, then it won't work. Therefore, I need to protect my data and find out if any invaluable changes are going on in a different workbook or in the different worksheet. -- Best Regards Pooja Sharma -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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 5,000 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 Macros for Track Changes
Hi All, I want to know, if there is any other option, i.e., other than Track Changes. I want to know in my excel sheet, if someone does any changes in any column/Row/Cell for e.g., Adding one row in between of existing rows, changing the values of cells. There is a restriction in Track Changes, if someone has stop the Track Changes option, then it won't work. Therefore, I need to protect my data and find out if any invaluable changes are going on in a different workbook or in the different worksheet. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- 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 5,000 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: Counting duplicates once
for this you can create Pivot chart...If you don't know how to create then you can send a file..so that I can help you in this case. On 2/11/09, stuartjohnw...@googlemail.com stuartjohnw...@googlemail.com wrote: Hope you can help. In column B2:B265 I have a list of names, each name appears about 4 time each. In column H2:H265 there is a list containing either PC, Laptop or CAD corresponding to what type of computer each individual in column A is using. I'm looking for a formula or series of formulas that will tell me how many PC's, laptops's and CAD's are being used but only counting one per name once (hope that makes sense). -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ 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: How to filter , from data in cell.
Hi Sachin, In this you can use the CTRL.+H command, enter the Comma(,) in *find what*and keep the *replace with* as blank and now press the tab replace all. Regards Pooja On 2/5/09, Sachin N Harale sachin.har...@idbi.co.in wrote: Dear friends, Please help me out in filtering the , (comma) out from the data which is comma separated. Further I want to retain the . (dot) in data. The file is attached with this email. regards SACHIN -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---