Re: $$Excel-Macros$$ Re: Two columns and three criteria

2011-09-18 Thread Prashant Bhawar
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

$$Excel-Macros$$ Re: Helprequire to unprotect word doc .

2009-11-03 Thread Prashant Bhawar
assist ? Please help us on following id: aligah...@gmail.com Rgds, Aligahk06 -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links

$$Excel-Macros$$ Re: Need Help for top 10 sorting

2009-11-02 Thread Prashant Bhawar
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

$$Excel-Macros$$ Re: Need Help for top 10 sorting

2009-10-30 Thread Prashant Bhawar
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

Re: Fw: $$Excel-Macros$$ PUZZLE Use functions only!!!!SOLUTION!!!!

2009-10-14 Thread Prashant Bhawar
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

$$Excel-Macros$$ Plz Help

2009-10-11 Thread Prashant Bhawar
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-Macros$$ Re: Plz Help

2009-10-11 Thread Prashant Bhawar
thanks harmeet its working On Sun, Oct 11, 2009 at 4:27 PM, prashant bhawar bhawar.prs...@gmail.comwrote: thanks harmeet its working On Sun, Oct 11, 2009 at 2:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *Tried to solve the issue in one column, i hope this helps :)**see attached

$$Excel-Macros$$ Re: Cap Gains calculation on shares, on FIFO basis

2009-10-09 Thread Prashant Bhawar
, 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

$$Excel-Macros$$ Re: Enable V Look up Option on the Excel Sheet.

2009-10-04 Thread Prashant Bhawar
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 bhawar.prs...@gmail.comwrote: hi Dilip, u use formula =VLOOKUP($A:$A,Portfolio

$$Excel-Macros$$ Re: PUZZLE Use functions only

2009-10-04 Thread Prashant Bhawar
value may be text or number anything but result should be reversed. Regards Sandeep -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -- Some important links

$$Excel-Macros$$ Re: Help plz

2009-09-13 Thread Prashant Bhawar
Thanks Dilip its really useful to me On Sun, Sep 13, 2009 at 11:57 AM, prashant bhawar bhawar.prs...@gmail.comwrote: Thanks Dilip its really useful to me On Sun, Sep 13, 2009 at 10:07 AM, poojari sreevijay psreevi...@gmail.comwrote: Hi Prashant, Please find the attached Excel sheet

$$Excel-Macros$$ Help plz

2009-09-12 Thread 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

$$Excel-Macros$$ Re: Urgent - Unprotected sheet

2009-08-28 Thread Prashant Bhawar
On Fri, Aug 28, 2009 at 8:28 PM, prashant bhawar bhawar.prs...@gmail.comwrote: On Fri, Aug 28, 2009 at 4:11 PM, amresh kumar amreshkushw...@gmail.comwrote: 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

$$Excel-Macros$$ Re: Need help on formula

2009-08-25 Thread Prashant Bhawar
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

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread Prashant Bhawar
On Mon, Aug 24, 2009 at 8:02 PM, prashant bhawar bhawar.prs...@gmail.comwrote: On Mon, Aug 24, 2009 at 10:49 AM, Sandeep sandymau...@gmail.com 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

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-23 Thread Prashant Bhawar
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

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-23 Thread Prashant Bhawar
On Sun, Aug 23, 2009 at 7:47 PM, Sandeep sandymau...@gmail.com 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

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

2009-08-22 Thread Prashant Bhawar
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

$$Excel-Macros$$ Re: Protect particular cells of sheet

2009-08-22 Thread Prashant Bhawar
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