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
assist ?
Please help us on following id:
aligah...@gmail.com
Rgds,
Aligahk06
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
--
Some important links
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
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
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
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
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
, 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
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
value may be text or number anything but result should be
reversed.
Regards
Sandeep
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
--
Some important links
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
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
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
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
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
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
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
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
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
19 matches
Mail list logo