xcel-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
>
> <><><><><><><><><>
> Please assist ?
>
> Please help us on following id:
> aligah...@gmail.com
>
> Rgds,
>
> Aligahk06
>
>
>
> >
>
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
--
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
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@googlegroup
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
>>
xed 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
>
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
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
>
> > 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
> &
t; The entered value may be text or number anything but result should be
> reversed.
>
> Regards
> Sandeep
>
> >
>
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
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!
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
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
( C
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
>
NA
> 3001
>
>
> >
>
i attched a solution
--
Warm Regard
Prashant Bhawar
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VB
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
>> &#x
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:* Pr
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
--
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 prote
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 i
20 matches
Mail list logo
