$$Excel-Macros$$ just a wild thought regarding table in one cell
Dear all, Is there any possibility to create a small table where data can be put to clarify the reason of the amount of one certain cell instead of inserting a comment box? I mean if we can insert a table instead of only text like in insert box. If it is possible then it will help me on my work as I need to comment on the budget spend in particular head. Thank you, Sunita -- 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
Re: $$Excel-Macros$$ just a wild thought regarding table in one cell
I have tried to explain what I want it to be in comment box. I hope I am able to explain. Thanx On Fri, Aug 3, 2012 at 12:09 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: pl share a data with groups. Regards, Gawli Anil On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, Is there any possibility to create a small table where data can be put to clarify the reason of the amount of one certain cell instead of inserting a comment box? I mean if we can insert a table instead of only text like in insert box. If it is possible then it will help me on my work as I need to comment on the budget spend in particular head. Thank you, Sunita -- 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 -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need to consolidate data in one sheet
Thank you very much Don. On Mon, Jul 23, 2012 at 5:26 PM, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Hi Don, kindly explain how did you do that. Regards CK On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 dguille...@gmail.com wrote: See attached file that automatically makes a drop down in range d9 when you activate the sheet and when you select the date from the drop down will populate the cells. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* सुनिता पौडेल tosune...@gmail.com *Sent:* Friday, July 20, 2012 4:11 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ need to consolidate data in one sheet Dear all, In this attached file there is data in one sheet 1, I want the same account head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried manually but takin time so if you all could help me on this. Thank you very much for the cooperation. Regards, Sunita -- -- 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 -- B.N Chetan kumar -- -- 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
Re: $$Excel-Macros$$ regarding ratio
thank you Noorain ji !! On Fri, Jul 20, 2012 at 8:45 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, Try this one *=SUBSTITUTE(TEXT(A1/B1,?/?),/,:)* or *=ROUND(A1/B1, 2) : ROUND(B1/A1,2)* -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.com On Thu, Jul 19, 2012 at 3:08 PM, सुनिता पौडेल tosune...@gmail.com wrote: it shows 1:0 thnx On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Please try it.. Hope it will help to you. =(LEFT(TEXT(A1/B1,/),FIND(/,TEXT(A1/B1,/))-1): RIGHT(TEXT(A1/B1,/),LEN(TEXT(A1/B1,/)) -FIND(/,TEXT(A1/B1,/ On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल tosune...@gmail.comwrote: not working .is it because add-ins blah.. thnx On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/ ** ** ** ** Regards, ** ** Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.comhttps://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com| *The leader in innovative claims and productivity management solutions * ** ** Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. *[image: http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png] **Please consider the environment before printing this message*** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *?? ? *Sent:* Thursday, July 19, 2012 1:35 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ regarding ratio ** ** Dear all, Please do me one favor. I tried to find out the ratio between two numbers but seems the formula isn't working. So can you please help me. Thank you Sunita -- -- 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 CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- -- 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
$$Excel-Macros$$ need to consolidate data in one sheet
Dear all, In this attached file there is data in one sheet 1, I want the same account head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried manually but takin time so if you all could help me on this. Thank you very much for the cooperation. Regards, Sunita -- -- 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 17 july 2011 to 15 July 2012.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need to consolidate data in one sheet
Thank you soo much I will try it have a nice weekend Sunita On Fri, Jul 20, 2012 at 5:16 PM, Deba Ranjan drdeva...@gmail.com wrote: Hi Sunita Ji, PFA... might help you out your Query. Thanks Regards, *Deba Ranjan P* On Fri, Jul 20, 2012 at 2:41 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, In this attached file there is data in one sheet 1, I want the same account head amount from the sheet 1 to appear in sheet 2. Is it possible?. I tried manually but takin time so if you all could help me on this. Thank you very much for the cooperation. Regards, Sunita -- -- 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$$ regarding ratio
Dear all, Please do me one favor. I tried to find out the ratio between two numbers but seems the formula isn't working. So can you please help me. Thank you Sunita -- -- 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 ratio.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ regarding ratio
not working .is it because add-ins blah.. thnx On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/* *** ** ** ** ** Regards, ** ** Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.comhttps://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com| *The leader in innovative claims and productivity management solutions* ** ** Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. *[image: http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png] **Please consider the environment before printing this message*** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *?? ? *Sent:* Thursday, July 19, 2012 1:35 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ regarding ratio ** ** Dear all, Please do me one favor. I tried to find out the ratio between two numbers but seems the formula isn't working. So can you please help me. Thank you Sunita -- -- 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 CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- -- 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 image001.png
Re: $$Excel-Macros$$ regarding ratio
it shows 1:0 thnx On Thu, Jul 19, 2012 at 2:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Please try it.. Hope it will help to you. =(LEFT(TEXT(A1/B1,/),FIND(/,TEXT(A1/B1,/))-1): RIGHT(TEXT(A1/B1,/),LEN(TEXT(A1/B1,/)) -FIND(/,TEXT(A1/B1,/ On Thu, Jul 19, 2012 at 2:07 PM, सुनिता पौडेल tosune...@gmail.com wrote: not working .is it because add-ins blah.. thnx On Thu, Jul 19, 2012 at 1:58 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/ ** ** ** ** Regards, ** ** Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.comhttps://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com| *The leader in innovative claims and productivity management solutions* ** ** Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. *[image: http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png] **Please consider the environment before printing this message*** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *?? ? *Sent:* Thursday, July 19, 2012 1:35 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ regarding ratio ** ** Dear all, Please do me one favor. I tried to find out the ratio between two numbers but seems the formula isn't working. So can you please help me.* *** Thank you Sunita -- -- 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 CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- -- 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
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Incase of 2003 You can also use.. *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sunita, Please Try it.. =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, however this is not working out , can you please solve this where i went wrong/ thnx On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल tosune...@gmail.comwrote: wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong. Anyway thanks heaps. Sunita On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also be privileged. If you are not the intended recipient of this e-mail you may not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you are not the intended recipient please telephone or e-mail the sender and delete this message and any attachment from your system. -- 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
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
Hi Noorain, Its working perfectly. I have tried this formulae for other sheets too. Thanx alot...I need it for my report... Have a wonderful weekend. Sunita On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, Please confirm.. Is it not working.. paste in Cell *E2* *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल tosune...@gmail.com wrote: Hi, Still not working :( its 2010 On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Incase of 2003 You can also use.. *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))* On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sunita, Please Try it.. =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2) On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, however this is not working out , can you please solve this where i went wrong/ thnx On Thu, Jul 12, 2012 at 3:36 PM, सुनिता पौडेल tosune...@gmail.comwrote: wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com
$$Excel-Macros$$ Need formula to take out total number of boy and girl
Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 BGA.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl
wohoo so may options thnx guys ..it really worked out thank you so much Sunita On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: You Can also use.. *=DCOUNTA($E$9:$E$49,E9,G1:G2)* See attached sheet. On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, You can also *try.. =SUMPRODUCT(--($E$10:E49=GIRL))* On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, Can you please help me to find out the total number of boy and girl ? I used countif for their grade and it worked. However, for girl and boy seggregation it isnot working. Thank you very much for the support you all have been providing. sunita -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
Re: $$Excel-Macros$$ no of sheets in a workbook
Dear all, This is very useful information and I have been trying to use it at my work. Since, I am in beginner phase can you please teach me as to how to do it from the scratch? Thank you all, Sunita On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.com wrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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
Re: $$Excel-Macros$$ no of sheets in a workbook
Thank you Noorain. I hope can look at you if stuck in there. Thank you once again. Sunita On Tue, Jul 10, 2012 at 5:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, Please find below link, hope it will you to explain How can use Hotkey In VBA http://www.excely.com/excel-vba/assign-hotkey-to-smartdel-macro.shtml http://www.mrexcel.com/archive/VBA/3401b.html On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, This is very useful information and I have been trying to use it at my work. Since, I am in beginner phase can you please teach me as to how to do it from the scratch? Thank you all, Sunita On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.comwrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
Wow congratulations to both experts !! :) On Mon, Jul 2, 2012 at 1:40 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: congratulation both of you Regards, Sanjib On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- 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$$ need help on maximum value and thier name
Dear all, It has always been previlege to query on this group whenever needed and thanks from heart. I need one help regarding finding out maximum number and their name in one cell ? Have a wonderful day !! Thank you!! Sunita P.S: in case if file not attached(having probs) name amount* Bijay Barma * 11640* Binod Barma * 10983* Manoj Barma * 10983* Jitendra Barma * 16215* Birbal Sunar * 15207* Dinesh Rokaya * 28742*Nisha Basnet* 10041*Daman Raj Aidi * 11356*Nara Rawat* 32130*Surya Buda* 10001*Binita Bam* 9699*RajKumar Rawat* 29512*Shiva Thapa* 28393*Rajesh Singh* 10365*Can we find maximum number and their name in one cell or different?* *Can we find 2nd maximum number and their name/* *Likewise from greates to least number?* -- -- 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 max.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need help on maximum value and thier name
Thanx :) On Mon, Jun 25, 2012 at 1:08 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi Sunita, In my case, I have used filters since it becomes more easier On Mon, Jun 25, 2012 at 12:49 PM, सुनिता पौडेल tosune...@gmail.comwrote: did you filtre the column? thank you On Mon, Jun 25, 2012 at 12:47 PM, Shaik Waheed waheedb...@gmail.comwrote: PFA On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल tosune...@gmail.comwrote: Dear all, It has always been previlege to query on this group whenever needed and thanks from heart. I need one help regarding finding out maximum number and their name in one cell ? Have a wonderful day !! Thank you!! Sunita P.S: in case if file not attached(having probs) name amount * Bijay Barma * 11640 * Binod Barma * 10983 * Manoj Barma * 10983 * Jitendra Barma * 16215 * Birbal Sunar * 15207 * Dinesh Rokaya * 28742 *Nisha Basnet* 10041 *Daman Raj Aidi * 11356 *Nara Rawat* 32130 *Surya Buda* 10001 *Binita Bam* 9699 *RajKumar Rawat * 29512 *Shiva Thapa* 28393 *Rajesh Singh* 10365 *Can we find maximum number and their name in one cell or different?* *Can we find 2nd maximum number and their name/* *Likewise from greates to least number?* -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Thank you very much for the prompt action. It works as per my requirement. Have a wonderful day! On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly find the attached file Hope this is as per your req 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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 -- 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 -- 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 -- 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 -- 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
$$Excel-Macros$$ Need help on Resigned staffs statistic
Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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 Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need help on Resigned staffs statistic
Dear Priyanka, Thank you for the interest shown. Please find attached the example of what I required. On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa p.dhamsa...@gmail.com wrote: Dear Sunita Kindly give one example of what u want in your sheet as to study the data and analyse the same and preparing format as per your requirement takes a lot time So kindly provide one output example in output format 2012/1/20 सुनिता पौडेल tosune...@gmail.com Dear all, Can you please help me on resigned staffs statistic? I need the information as below: the number of resigned staffs in 2006 and ratio of resigned staffs male:female Like wise till 2012 Your help will be highly effective for my work. Regards, Sunita -- 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 -- 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 -- 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 Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet