Re: $$Excel-Macros$$ Re: Two columns and three criteria
plz check the attached file hope it will help you. I created these file using office 2003 On Fri, Sep 16, 2011 at 6:24 PM, ArtySin wrote: > Guys, > Thanks to all for your help. Problem now solved and working a > treat. :-) > ArtySin > > On Sep 15, 5:09 pm, ArtySin wrote: > > Hi > > I have two columns as below using Excel 2000 (unfortunately, corporate > > no spend policy): These columns have been exported from a database and > > appear as the example below. > >A B > > Status Date Run > > Passed 22/08/2011 > > Failed 22/08/2011 > > Failed 23/08/2011 > > Passed 22/08/2011 > > Passed 23/08/2011 > > N/A 22/08/2011 > > N/A 22/08/2011 > > Passed 22/08/2011 > > N/A 23/08/2011 > > Failed 23/08/2011 > > > > What I want to do is add up the number of times either passed or > > failed appears against a date but do not want to include the N/A. For > > example to count up the total of passed or failed for the 22/08/2011 > > would give a result of 4 > > > > I've tried =SUMPRODUCT(--($A$2:$A$11=A2)--($A$2:$A$11=A3)*--($B$2:$B > > $11=B2)) and various countifs with AND statements but I can't get > > this to work. > > > > Many thanksArtySin > > -- > > -- > 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 > -- Warm Regard ( Prashant Bhawar ) -- -- 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 Book1.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Helprequire to unprotect word doc .
can u plz attached that file so i try to break the password On Tue, Nov 3, 2009 at 6:19 PM, Aligahk06 wrote: > Dear All, > > I forget my word document 2007 password. > Can any body any idea or code that help us in removing the password so that > i can edit my documents. > Please assist ? > > Please help us on following id: > aligah...@gmail.com > > Rgds, > > Aligahk06 > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Me
use powerutils 1.9 On Tue, Nov 3, 2009 at 2:13 PM, sudhir kumar wrote: > Hi friends > > > Please find the attachement and help me. > > Thanking U > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help for top 10 sorting
Really thanks C.G.Kumar its really helpful to me. On Mon, Nov 2, 2009 at 3:42 PM, Chandra Gupt Kumar < kumar.bemlmum...@gmail.com> wrote: > Since you conveyed that you required the result only in specified area, I > have amended the solution to suit your requirement. > > Hope it serves the purpose. > > > > > > Regards, > > > > C.G.Kumar > > > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Chandra Gupt Kumar > *Sent:* Monday, November 02, 2009 12:08 PM > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Need Help for top 10 sorting > > > > > > > > Regards, > > > > C.G.Kumar > > > ------ > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Prashant Bhawar > *Sent:* Thursday, October 29, 2009 7:17 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Need Help for top 10 sorting > > > > i want top 10 performing learner from all the data( i want there names in > that column by Rank 1 to Rank 10 ). > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help for top 10 sorting
hi anish actually i dont want it to sort i want the name of the top 10 learner in top 10 learner column according to there rank (Rank 1 to Rank 10) can it be possible On Fri, Oct 30, 2009 at 1:47 PM, Anish Shrivastava wrote: > Hi Prashant, > > Why dont you use SORT the column which you want..It's juz very simple. > > Try it once :) > > Cheers!! > ANISH > > On Thu, Oct 29, 2009 at 7:16 PM, Prashant Bhawar < > prashant.aca...@gmail.com> wrote: > >> i want top 10 performing learner from all the data( i want there names in >> that column by Rank 1 to Rank 10 ). >> >> -- >> Warm Regard >> >> Prashant Bhawar >> >> ( CA Final ) >> >> > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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: Fw: $$Excel-Macros$$ PUZZLE Use functions only!!!!SOLUTION!!!!
gr8 On Sun, Oct 11, 2009 at 7:39 PM, Sandeep wrote: > Hello Everyone, > > Here is the solution of puzzle I asked on 3rd October. I used ITERATION for > its solution. > This may be new feature for many of members here so try to understand it. > It is a powerfull feature. > > Thanks & Regards > Sandeep > > - Original Message - > > *From:* Sandeep > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, October 03, 2009 10:41 PM > *Subject:* $$Excel-Macros$$ PUZZLE Use functions only > > Reverse a text or number or mixed value entered in a cell using functions > only not VBA. > > e.g. > Say A1 = ABC351D > > Then the answer in cell A2 should be D153BCA > > The entered value may be text or number anything but result should be > reversed. > > Regards > Sandeep > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Plz Help
thanks harmeet its working On Sun, Oct 11, 2009 at 4:27 PM, prashant bhawar wrote: > thanks harmeet its working > > > On Sun, Oct 11, 2009 at 2:25 PM, Harmeet Singh > wrote: > >> *Tried to solve the issue in one column, i hope this helps :)**see >> attached file* >> * >> * >> >> Thanks & Regards, >> >> Harmeet Singh >> >> Sent via BlackBerry Wireless >> >> >> On Sun, Oct 11, 2009 at 9:30 AM, Prashant Bhawar < >> prashant.aca...@gmail.com> wrote: >> >>> >>> Plz help here i attached a problem file with required ans. plz help me >>> -- >>> Warm Regard >>> >>> Prashant Bhawar >>> >>> ( CA Final ) >>> >>> >>> >> >> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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$$ Plz Help
Plz help here i attached a problem file with required ans. plz help me -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- PROBLEM.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Cap Gains calculation on shares, on FIFO basis
hi Chinmay here i attached a file hope that its help u. im working on it to make it more simple. On Fri, Oct 9, 2009 at 5:13 AM, RolfJ wrote: > > You are describing exactly what I had proposed. Should be > straightforward to implement. > > Have fun, > Rolf > > On Oct 8, 7:45 am, chinmay kamat wrote: > > Thank you sir, but unfortunately this does not solve the problem. > > > > The data is in the following format (example): > > > > For purchases: > > Date Quantity Amount Rate > > 01/04/08 150/- 85050/-567/- > > 05/04/08 100/- 61000/-610/- > > 09/04/0825/- 15125/-605/- > > 10/04/09 200/-13/-650/- > > > > For sales: > > Date QuantityAmount Rate > > 10/04/08 100/- 59000/- 590/- > > 07/04/09 175/-117250/- 670/- > > 10/04/09 200/-16/- 800/- > > > > > > > > Analysis of the data: > > > > the sale made of 10/04/08 is entirely short term. The cost of 100 > > shares sold are selected as follows: 100 out of purchases of 01/04/08. > > Profit is (100*590) - (100*567)= 2300/- > > > > > > > > The sale made on 02/04/09 is one year later, and the cost for the 175 > > shares sold is selected as follows: 50 out of purchases made on > > 01/04/08 and 100 out of purchases made on 05/04/08 and 25 out of > > purchases made on 06/04/08. > > > > Profit is (175*670) - ((50*567) + (100*610)+(25*605))= 12775/- > > > > out of which (150*670) - ((50*567)+(100*610))= 11150/- is long term > > > > and > > > > (25*670)-(25*605)=1625/- is short term. > > > > >>>>>>>>>>>>>>>>>>>>> > > > > The sale made on 10/04/09 is speculative because both the sale and > > purchased occurred on the same day for all the shares. (as all the > > earlier purchases were exhausted) > > > > > > > > so the program should not only calculate the profit by subtracting the > > cost of shares on FIFO basis (that is identify the earliest existing > > stock) but also tell if that was short term, long term or speculative. > > > > the second problem can easily be solved using the DATEIF function as > > explained by you. but since the data does not readily give me the > > correlation between the purchases and sales on FIFO basis, the first > > problem remains. > > > > Interesting problem, isnt it..?? > > > > <><><><><><><><><><><><><><><><> > > I have an idea of how to go about the problem, but i do not know how > > to implement it. > > > > See, the data is as follows: > > Date of each transaction, Quantity bought/sold in each transaction, > > total amount > > > > we convert that data into: > > Date of purchase/sale of each share, Quantity=1 (always), Rate per > > share. > > > > So we will end up with data spreading across many rows, as each > > transaction is split into several rows depending on the number of > > shares involved. > > > > We do this for both purchase data and sale data. > > > > then we place the data side by side, and voila.. just subtract the > > selling rate from purchase rate to get profit, then compare the dates > > to categorise the transaction. > > > > You think it may be possible in excel?? or would it be possible in any > > other manner??? > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- CG.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: PUZZLE Use functions only
hi i here attached solution hope this is right. On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote: > Reverse a text or number or mixed value entered in a cell using functions > only not VBA. > > e.g. > Say A1 = ABC351D > > Then the answer in cell A2 should be D153BCA > > The entered value may be text or number anything but result should be > reversed. > > Regards > Sandeep > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~--- puzzel solved-prashant.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Enable V Look up Option on the Excel Sheet.
hi Dilip, u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) then whts the problem ? On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar wrote: > hi Dilip, > > u use formula > =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0) > > if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0) > then whts the problem ? > > > On Sat, Oct 3, 2009 at 3:28 PM, wrote: > >> Thx a lot >> >> Sent from my BlackBerry® smartphone from Tata Indicom >> -- >> *From: * Dilip Pandey >> *Date: *Sat, 3 Oct 2009 15:04:03 +0530 >> *To: * >> *Subject: *$$Excel-Macros$$ Re: Enable V Look up Option on the Excel >> Sheet. >> >> Hi, >> >> As requested, v-lookup function is incorporated in the attached workbook. >> Note, you have to define something else instead of "fund Name" as a >> base data to be looked for because the same names are appearing more than >> once. For example, fund Id or fund number can work. Thanks, >> >> -- >> DILIP KUMAR PANDEY >>MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 10/3/09, Equity Monk wrote: >>> >>> Dear Friends, >>> >>> I am attaching a portfolio. It is a mf portfolio. >>> If you can pls attach a v look up function to it that would be great. >>> >>> The website from where the link can come is http://www.amfiindia.com/. >>> >>> Looking fwd to your help. >>> >>> >>> >> >> >> >> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help plz
Thanks Dilip its really useful to me On Sun, Sep 13, 2009 at 11:57 AM, prashant bhawar wrote: > Thanks Dilip its really useful to me > > > > On Sun, Sep 13, 2009 at 10:07 AM, poojari sreevijay > wrote: > >> Hi Prashant, >> >> Please find the attached Excel sheet. Hope this would solve your query. >> >> Thanks, >> Sreevijay >> >> >> >> >> >> 2009/9/12 Prashant Bhawar >> >>> >>> Hello Frnds I want some solution >>> >>> I want to separate First Name, Middle Name & Last Name >>> >>> means if I hav Full name in A1 then i want First name in B1, Middle Name >>> in C2 & Last name in C3 >>> -- >>> Warm Regard >>> >>> Prashant Bhawar >>> >>> ( CA Final ) >>> >>> >> >> >> -- >> psreevi...@gmail.com >> >> >> >> >> > > > -- > Warm Regard > > Prashant Bhawar > > ( CA Final ) > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- 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$$ Help plz
Hello Frnds I want some solution I want to separate First Name, Middle Name & Last Name means if I hav Full name in A1 then i want First name in B1, Middle Name in C2 & Last name in C3 -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent - Unprotected sheet
On Fri, Aug 28, 2009 at 8:28 PM, prashant bhawar wrote: > > > On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar wrote: > >> Hi My All Friend, >> >> I Forget password of excel file.can u any help in unprotected file. >> >> Regards >> Amresh >> >> On Fri, Aug 28, 2009 at 2:31 PM, Mahesh wrote: >> >>> thanx >>> >>> >>> On Fri, Aug 28, 2009 at 2:20 PM, Sandeep wrote: >>> >>>> Hi Mahesh, >>>> Find the attached solution >>>> >>>> Regards >>>> Sandeep >>>> >>>> - Original Message - >>>> *From:* Mahesh >>>> *To:* excel-macros@googlegroups.com >>>> *Sent:* Friday, August 28, 2009 12:07 PM >>>> *Subject:* $$Excel-Macros$$ Vlookup not working in 2007 >>>> >>>> Dear Friends, >>>> >>>> I m facing this problem in Excel 2007. >>>> >>>> attached is the excel sheet, kindly help. >>>> >>>> -- >>>> With Love, >>>> Mahesh Bisht >>>> >>>> >>> >>> >>> -- >>> With Love, >>> Mahesh Bisht >>> >>> >>> >> >> >> >> Hello my friend if u r using office 2003 or earlier then just download the > following which unprotect ur sheet > > http://www.straxx.com/excel/password.html > > > -- > Warm Regard > > Prashant Bhawar > -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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 help on formula
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > Hello Team, > > How do i rank only positive numbers. Plz help me on formula. > > Example > > Amount Rank > 200 2 > 100 3 > -50NA > 10 4 > -5 NA > 3001 > > > > > i attched a solution -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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 -~--~~~~--~~--~--~--- Solved.xls Description: MS-Excel spreadsheet
Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria
On Mon, Aug 24, 2009 at 8:02 PM, prashant bhawar wrote: > > > On Mon, Aug 24, 2009 at 10:49 AM, Sandeep wrote: > >> Hi Prashant, >> >> For changing path of file, the best way for you is to open both of your >> excel files then select >> 'C:\Documents and >> Settings\Sandeep\Desktop\[cm17AUG2009bhav.xls]cm17AUG2009bhav'!$B$2:$B$1256 >> >> with this keep selecting go to your data file and select the range you >> want . All the things will automaticlly done. >> >> Similarly you can do for the below link. >> >> 'C:\Documents and >> Settings\Sandeep\Desktop\[cm17AUG2009bhav.xls]cm17AUG2009bhav'!$A$2:$K$1256 >> >> But be careful for rows means 2 to 1256 or anything you want, should be >> same in both ranges. >> >> - Original Message - >> *From:* Prashant Bhawar >> *To:* excel-macros@googlegroups.com >> *Sent:* Monday, August 24, 2009 8:26 AM >> *Subject:* Re: Fw: $$Excel-Macros$$ V look within a specific range based >> on criteria >> >> >> >> On Sun, Aug 23, 2009 at 7:47 PM, Sandeep wrote: >> >>> Hi Prashant, >>> >>> I don't know any perticular way for any kind of formula. I just try to >>> use all related concepts I know, to solve problems. >>> >>> Regards >>> Sandeep >>> >>> - Original Message - >>> *From:* Prashant Bhawar >>> *To:* excel-macros@googlegroups.com >>> *Sent:* Sunday, August 23, 2009 7:16 PM >>> *Subject:* Re: Fw: $$Excel-Macros$$ V look within a specific range based >>> on criteria >>> >>> >>> >>> On Sat, Aug 22, 2009 at 11:40 PM, Sandeep wrote: >>> >>>> Hi Subu >>>> Sorry I forgot to attach file. >>>> >>>> Find the attach file which produce the result of VOOKUPIF ( ) function. >>>> Be careful about the conditions for the formula if you want correct result. >>>> >>>> Sandeep >>>> >>>> - Original Message - >>>> *From:* Subu S >>>> *To:* excel-macros@googlegroups.com >>>> *Sent:* Saturday, August 22, 2009 6:56 PM >>>> *Subject:* $$Excel-Macros$$ V look within a specific range based on >>>> criteria >>>> >>>> Dear Members >>>> >>>> I have the source data on a spread sheet that is approx 10 columns by >>>> 1300 rows. Sample sp sheet cm17JUN2009bhav.xls is enclosed >>>> >>>> I wish to Vlookup this to a result book called result book to group.xls, >>>> also enclosed >>>> >>>> On the result book, I wish to v lookup FROM the source sheet provided >>>> some criteria is met in the source book, .for e.g. V lookup range >>>> should be where the value in column B = EQ in the source book >>>> >>>> To state it differently, I wish to V ollokup for values in column A of >>>> result book, and fill with values only when column B in workbook >>>> cm17JUN2009bhav.xls = BE >>>> >>>> In the given sample I could give a formula >>>> =VLOOKUP(A3,cm17JUN2009bhav.xls!$A$2:$K$235,6,FALSE), i.e manually restrict >>>> the range to $A$2:$K$235 of source book >>>> >>>> Is there a way to do this automatically by using a function ? >>>> >>>> When I get the next source book, say CM18jun2009bhav.xls, I will get a >>>> diff. range and hence my question >>>> >>>> Any suggestions would be most appreciated >>>> >>>> Samples XL sheets are enclosed >>>> >>>> >>>> >>>> -- >>>> >>>> Regards >>>> Subu >>>> >>>> >>>> mail_to_s...@yahoo.com >>>> >>>> -- >>>> Get your preferred Email name! >>>> <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/> >>>> Now you can @ymail.com and @rocketmail.com. >>>> >>>> Hi Sandeep >>> >>> Can u tel me hw to write such type of formula ? >>> >>> >>> -- >>> Warm Regard >>> >>> Prashant Bhawar >>> >>> Hi sandeep means i want to know how u insert the location of the file >> means c:/documets.. etc. >> & how can it update. bcoz my file location is different from ur file >> location whts the logic behind it >> >> >> -- >> Warm Regard >> >> Prashant Bhawar >> >> >> > Thanks Sandeep. > > -- > Warm Regard > > Prashant Bhawar > -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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: Fw: $$Excel-Macros$$ V look within a specific range based on criteria
On Sun, Aug 23, 2009 at 7:47 PM, Sandeep wrote: > Hi Prashant, > > I don't know any perticular way for any kind of formula. I just try to > use all related concepts I know, to solve problems. > > Regards > Sandeep > > - Original Message - > *From:* Prashant Bhawar > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, August 23, 2009 7:16 PM > *Subject:* Re: Fw: $$Excel-Macros$$ V look within a specific range based > on criteria > > > > On Sat, Aug 22, 2009 at 11:40 PM, Sandeep wrote: > >> Hi Subu >> Sorry I forgot to attach file. >> >> Find the attach file which produce the result of VOOKUPIF ( ) function. Be >> careful about the conditions for the formula if you want correct result. >> >> Sandeep >> >> - Original Message - >> *From:* Subu S >> *To:* excel-macros@googlegroups.com >> *Sent:* Saturday, August 22, 2009 6:56 PM >> *Subject:* $$Excel-Macros$$ V look within a specific range based on >> criteria >> >> Dear Members >> >> I have the source data on a spread sheet that is approx 10 columns by 1300 >> rows. Sample sp sheet cm17JUN2009bhav.xls is enclosed >> >> I wish to Vlookup this to a result book called result book to group.xls, >> also enclosed >> >> On the result book, I wish to v lookup FROM the source sheet provided some >> criteria is met in the source book, .for e.g. V lookup range should be >> where the value in column B = EQ in the source book >> >> To state it differently, I wish to V ollokup for values in column A of >> result book, and fill with values only when column B in workbook >> cm17JUN2009bhav.xls = BE >> >> In the given sample I could give a formula >> =VLOOKUP(A3,cm17JUN2009bhav.xls!$A$2:$K$235,6,FALSE), i.e manually restrict >> the range to $A$2:$K$235 of source book >> >> Is there a way to do this automatically by using a function ? >> >> When I get the next source book, say CM18jun2009bhav.xls, I will get a >> diff. range and hence my question >> >> Any suggestions would be most appreciated >> >> Samples XL sheets are enclosed >> >> >> >> -- >> >> Regards >> Subu >> >> >> mail_to_s...@yahoo.com >> >> -- >> Get your preferred Email name! >> <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/> >> Now you can @ymail.com and @rocketmail.com. >> >> Hi Sandeep > > Can u tel me hw to write such type of formula ? > > > -- > Warm Regard > > Prashant Bhawar > > > Hi sandeep means i want to know how u insert the location of the file means c:/documets.. etc. & how can it update. bcoz my file location is different from ur file location whts the logic behind it -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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: Fw: $$Excel-Macros$$ V look within a specific range based on criteria
On Sat, Aug 22, 2009 at 11:40 PM, Sandeep wrote: > Hi Subu > Sorry I forgot to attach file. > > Find the attach file which produce the result of VOOKUPIF ( ) function. Be > careful about the conditions for the formula if you want correct result. > > Sandeep > > - Original Message - > *From:* Subu S > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, August 22, 2009 6:56 PM > *Subject:* $$Excel-Macros$$ V look within a specific range based on > criteria > > Dear Members > > I have the source data on a spread sheet that is approx 10 columns by 1300 > rows. Sample sp sheet cm17JUN2009bhav.xls is enclosed > > I wish to Vlookup this to a result book called result book to group.xls, > also enclosed > > On the result book, I wish to v lookup FROM the source sheet provided some > criteria is met in the source book, .for e.g. V lookup range should be > where the value in column B = EQ in the source book > > To state it differently, I wish to V ollokup for values in column A of > result book, and fill with values only when column B in workbook > cm17JUN2009bhav.xls = BE > > In the given sample I could give a formula > =VLOOKUP(A3,cm17JUN2009bhav.xls!$A$2:$K$235,6,FALSE), i.e manually restrict > the range to $A$2:$K$235 of source book > > Is there a way to do this automatically by using a function ? > > When I get the next source book, say CM18jun2009bhav.xls, I will get a > diff. range and hence my question > > Any suggestions would be most appreciated > > Samples XL sheets are enclosed > > > > -- > > Regards > Subu > > > mail_to_s...@yahoo.com > > -- > Get your preferred Email name! > <http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/> > Now you can @ymail.com and @rocketmail.com. > > > Hi Sandeep Can u tel me hw to write such type of formula ? -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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: Protect particular cells of sheet
On Sat, Aug 22, 2009 at 6:22 PM, mahesh parab wrote: > Dear All > > In attach sheet i want to protect particular cells of sheet, from protect > sheet option i can > protect whole sheet but i want to keep yellow colour cells in attach sheet > editable & green colour whole sheet protected. > for both 2003 or 2007 excel. > > > > > > select the cell which u want be editable. right click on them , select format cells option, go to protection tab & just untick the Locked option. now u protect ur sheet. -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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 Urgent help in finding formula.
On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote: > Hello Team, > > I have attached file in which i need a formula in the column E, instead of > the manual ranking in need a formula based on the item mentioned in the > column C. > > Please make a note, ranking is based on the largest value to the particular > item in C. ie Glass/Tiles/Bricks > Kindly assist asap. > Attached is the file for your review. > > Regards, > Vinod > > > > here i attached a soulution file. i think its helpful to u. -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- 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,200 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 -~--~~~~--~~--~--~--- Test- Prashant.xls Description: MS-Excel spreadsheet
