Thanks..
Nikhil
On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Frndz,
Use full link to learn Excel. please find attached link!!!
http://www.excel-pratique.com/en/index.php
Thanks
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Hi
Thanks for sending excellent file,
(1). Prince Formula Bible (Updated Version)
(2). Updated Lets Learn Together ( Macro Bible )
Can you send all files in excel 2003..
Nikhil
On Sat, Oct 13, 2012 at 10:02 PM, Prince Sethi prince.seth...@gmail.comwrote:
--
Regards
[image:
Dear Members,
Congratulations Rajan
Nikhil
On Sat, Oct 13, 2012 at 8:55 PM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
Many Congratulations RajanOnce Again...bhai
On Tuesday, 2 October 2012 21:04:33 UTC+5:30, Ayush Jain wrote:
Dear members,
Rajan Verma has been selected
Hi Noorain ,
Thanks for sending excellent Chart File..
Nikhil
On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find attached Clock Chart.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
--
Congratulation Rajan
Nikhil Shah
On Mon, Jun 4, 2012 at 11:02 AM, Maries talk2mar...@gmail.com wrote:
*Congrats Brother.*
On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.comwrote:
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI
Hi Haseeb,
Nice Formula..
Thanks
Nikhil
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A haseeb.avarak...@gmail.comwrote:
Nikhil, One way:
Assume date is in A2. So
In B2 for the Curr Quarter.
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,)
Then in C2
=TEXT((1B2)+99,)
Copy across to E2.
Hi Haseeb,
Sorry , answer is wrong.
i.e. Dt.01/05/2010 ( DD/MM/ ) ,then Next Quarter should be July , here
it's display april..
Nikhil
On Sun, Apr 15, 2012 at 2:57 PM, Haseeb A haseeb.avarak...@gmail.comwrote:
Hello Nikhil,
This will give the current quarter.
Hi sam,
super Idea
Nikhil Shah
On Sun, Apr 15, 2012 at 7:01 PM, Sam Mathai Chacko samde...@gmail.comwrote:
A shorter one
=CHOOSE(CEILING(MONTH(A1)/3,1),April,July,October,January)
Regards,
Sam
On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi Maries
Hi Hasseb,
Now answer is right ,
i.e. Date 01/05/2010 ( DD/MM/ ) Format ,
Currently it's showing Curr.Qtr = April ; Next Qtr = July ..it is ok
After July , Now I want Next Qtr = October ; Next Qtr = January
Nikhil
On Sun, Apr 15, 2012 at 11:07 PM, Haseeb A
) Quarter will be - October and
the print will be January, April,July and october
I am using Excel 2003. I do want any Macro , I want Only Formula
Awaiting Reply
Nikhil Shah
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Hi Maries,
Thanks for solving my problem.
Nikhil
On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 dguille...@gmail.com wrote:
You need to provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Nikhil Shah nikhil201...@gmail.com
*Sent:* Saturday
Dear Maries,
Thanks for sending excel links , it will very useful to me..
Nikhil Shah
On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote:
Dear Friends,
I have accumulate the my collection for Excel. Please update, If you
anything more.
I hope these links are very useful
Hi Maries,
Thanks..Excellent Tools..
Regards
Nikhil Shah
On Tue, Feb 7, 2012 at 4:08 PM, Maries talk2mar...@gmail.com wrote:
*Find the attached Excel File
*
On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
PFA
On Tue, Feb 7, 2012 at 12:42 PM, Amit
Hi sam,
Can you post in Excel 2003 ? ..I am using excel 2003
Regards
Nikhil Shah
On Sat, Jan 21, 2012 at 10:56 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),)
Regards,
Sam Mathai Chacko
On Sat
Dear Noorain
Excellent Tips..
Thanks
Nikhil Shah
On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Updated Sheet
On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Noorain
It converts with Rupees and i want only for words
E.g. I
Hi Kris,
you right..it is very complex with formula..I have to use Pivot
table.itwill very easy..
Thanks
Nikhil Shah
On Fri, Dec 30, 2011 at 1:18 PM, Kris krishnak...@gmail.com wrote:
Hi,
With the help of a helper column, a Pivot table would do the trick.
PFA.
Kris
--
FORUM RULES
-macros@googlegroups.com] *On Behalf Of *Maries
*Sent:* Dec/Thu/2011 12:14
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Find the attachment
On Wed, Dec 28, 2011 at 9:23 PM, Nikhil Shah nikhil201...@gmail.com
wrote:
Dear Friend
] *On Behalf Of *Nikhil Shah
*Sent:* Dec/Fri/2011 12:37
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Dear Rajan
** **
Opps..Sorry..Answer is wrong..
** **
Again I am sending fresh excel sheet..
** **
Pl help
** **
Nikhil
Dear Friend,
I want to find out Consecutive Negative Return (%) in Times Number Years :
Answer is : 2 Times 2 Years
Now i want EXCEL Formula..Pl help me ..
*Year*
*Return*
*Year*
*Return*
1980
28.86%
1996
4.24%
1981
49.56%
1997
13.31%
1982
3.56%
1998
-17.17%
1983
7.20%
Dear Friend,
I want to find out Consecutive Negative Return (%) in Times Number Years :
Answer is : 2 Times 2 Years
Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me
..
*Year*
*Return*
*Year*
*Return*
1980
28.86%
1996
4.24%
1981
49.56%
1997
13.31%
:
What if three Consecutive year have negative % then what output you want..?
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Nikhil Shah
*Sent:* Dec/Wed/2011 10:14
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Help
Dear Jitendra,
Pl visit following URL
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Regards
Nikhil Shah
On Tue, Dec 13, 2011 at 11:55 PM, Jitendra singh jeete2...@gmail.comwrote:
Dear all expert,
Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce
Hi Maries,
Can you tell me how you select Term_Code ?
Nikhil
On Sat, Dec 10, 2011 at 11:05 PM, Maries talk2mar...@gmail.com wrote:
Dear Ankit,
Find the attached file. i hope this will help you.
Regards,
MARIES.
On Sat, Dec 10, 2011 at 1:15 PM, Ankit Agrawal ankit.agrawal...@gmail.com
Wow.. Wonderfull Sheet Mahesh..
Thanks
Nikhil Shah
On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab mahes...@gmail.com wrote:
its really Amazing!
check this link
http://www.xcelfiles.com/ImageToXL.html
HTH
Mahesh
--
FORUM RULES (934+ members already BANNED for violation)
1) Use
Dear Amit
Please Try this formula
=DATEDIF(B2,TODAY(),M)..
Nikhil Shah
On Wed, Nov 16, 2011 at 5:30 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Noorain,
** **
I am still getting the same error, see the sample data point..What I want
is to calculate age of vehicle
wrote:
That example is using an external file so the defined name shows ref
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Nikhil Shah nikhil201...@gmail.com
*Sent:* Monday, November 14, 2011 12:43 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ 10
Hi Noorain
Excellent work Noorain.
Regards
Nikhil
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts in sept 2011 and helped many people
Hi Noorain
This is another excellent tools you send our group..
Thanks Regards
Nikhil Shah
On Fri, Sep 23, 2011 at 8:32 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sandeep,
Please try it,
Sub convert_txtfile()
On Error GoTo abc
Dim txtifile
txtifile
Dear all,
I want Help for creating the VBA Codes for Repeating of Text in my Excel
sheet..
*Problem :*
I have made excel sheet in Columns.In which I have some texts which are
likely to repeat in my sheet frequently. So please help me to make proper
Hot Keys to make my work fast and easy.
Ex
/
On Tue, Sep 13, 2011 at 11:32 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Dear all,
I want Help for creating the VBA Codes for Repeating of Text in my Excel
sheet..
*Problem :*
I have made excel sheet in Columns.In which I have some texts which are
likely to repeat in my sheet frequently
to select the item(
tied to a CHANGE_EVENT macro. Send me your file with a clear explanation and
before/after examples
*From:* Nikhil Shah nikhil201...@gmail.com
*Sent:* Tuesday, September 13, 2011 9:02 AM
*To:* excel-macros@googlegroups.com
*Cc:* noorain.ans...@gmail.com
*Subject:* Re
Dear all
I have recd answer..
*
http://www.contextures.com/excel-videos-data-validation-basics.html#dropdown
*
Excellent trick..How to Use Conditional formula with data-validation..
Thanks..Give me Idea..
Nikhil Shah
On Tue, Sep 13, 2011 at 11:29 PM, Nikhil Shah nikhil201...@gmail.comwrote
cannot use ALT
Regards,
Sam Mathai Chacko (GL)
On Tue, Sep 13, 2011 at 10:50 PM, Nikhil Shah nikhil201...@gmail.comwrote:
Dear All,
As per your E-mail I am sending here with an Excel Sheet Attachment in
which I have shown what exactly I want.
( see column No ' O ')..
Thanks
Dear all
Today I have recd Two Tricks for Retyping of Text..
( 1 ). With help of Data validation
( 2 ). VBA Code
Thanks
Nikhil
On Wed, Sep 14, 2011 at 1:42 AM, Nikhil Shah nikhil201...@gmail.com wrote:
Dear Friend,
Wow..Super..Excellent Code..This is very very helpful me..it 's save my
Hi Daniel
Thanks for solving my problem.
Nikhil Shah
On Tue, Jul 26, 2011 at 5:01 PM, Daniel dcolarde...@free.fr wrote:
Hello,
** **
Have a look at the attached workbook.
** **
Regards.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel
days.
I want Formula Only I Do Not Want VBA Code...And I am using Office
Professional Edition 2003 Version...
Thanks
Nikhil Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Dear Ayush,
Excellent ToolsThanks
Nikhil Shah
On Fri, Jun 10, 2011 at 10:13 PM, Ayush jainayus...@gmail.com wrote:
Well, he's done it again. My good friend John Franco just uploaded these free
lookup syntax mastery
downloadshttp://www.1shoppingcart.com/app/?Clk=4338508for you
Chilexcel
Hi..Excellent Tools..it save my time..
Great Utility
Regards
Nikhil
On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel chilexcel...@gmail.com wrote:
yes
yes, download this application .
http://www.todoexcel.com/office-tabs/
also you can do with Navigator Toolbar for Workbook
Hi Ashish,
Thanks For sending Sheetnames excel sheet..Great help..
Regards
nikhil
On Sun, Dec 5, 2010 at 11:16 AM, ashish koul koul.ash...@gmail.com wrote:
try this addin save it on your dektop and double click it.
On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel chilexcel...@gmail.com wrote:
Dear All Members,
Here I am postin excel sheet..
*Problem :
*
*when I select the NAME I want the POLICY NOS. of that perticular
NAME only in the Drop List menu.*
For Ex. If I selet the name as Nikhil then all the policy Nos. of NIKHIL
only.
Pl help me out to solve my problem..I DO Not Want
Dear Daniel
Thanks for FormulaYou have solve my problem..
Regards
Nikhil Shah
On Thu, Dec 2, 2010 at 5:20 PM, Daniel dcolarde...@free.fr wrote:
Is it possible that the names list were sorted ?
Then you may use :
=OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3
Deal All Members,
http://www.powerutilsnet.com/default.htm
Pl go to above mentioned web site and download Powerful utilities for excel
..it is Totally FREE..
Thanks
Nikhil Shah..
--
--
Some important links
,FIND(
,A1,1)+1)+1,1)
Regards,
Mithlesh Sharma
On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi Friends,
In Column A .. I have written --- Vishal Pravinchandra Shah .
Now I want
In Column B should be VPSautomatically..I want Formula
I want First
Hi Friends,
I have written In Column A ...January ...
Now I want in Column B should be ..Jan ...only...I want formula..( No
Macro )
Awaiting Reply
Thanks
Nikhil
--
--
Some important links for excel users:
1.
Hi Friends,
In Column A .. I have written --- Vishal Pravinchandra Shah .
Now I want
In Column B should be VPSautomatically..I want Formula
I want First Letter Of First Name ; First Letter Of Middle Name ; First
Letter Of Last Name in one column..
Awaiting Reply..
Thanks
Nikhil
menu..
Regards,
Nikhil
On Wed, Aug 4, 2010 at 4:49 PM, Maries talk2mar...@gmail.com wrote:
Dear Mr.Nikhil,
Find the attached file... I hope that, this file will fulfill your
requirements...
Regards,
Marieswaran
On Wed, Aug 4, 2010 at 11:15 AM, Nikhil Shah nikhil201...@gmail.comwrote
Dear Neeraj
Excellent Work Sheet.
Yes this result I want..
Thanks
Regards
Nikhil Shah
On Tue, Aug 3, 2010 at 6:18 PM, Neeraj Lamba neeraj96...@gmail.com wrote:
Hi Nikhil,
Its done however i am not getting the option to upload a file into
discussion. I have uploaded the file in
http
Hi Rajendra Soni,
Wow Great Help for sending Excel URL
Nikhil Shah
On Mon, Jul 12, 2010 at 10:04 AM, Soni.Rajender soni.rajen...@gmail.comwrote:
Hi
Please find below the link for MS Excel resources.
http://www.google.co.in/search?tbs=bks%3A1tbo=1q=ms+excelbtnG=Search+Books
Starting Dt *OR* above of ending dt , then
it should display Error Massage.
Awaiting Reply
Nikhil Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Dear Friend
Thanks For Help.I have Found Data Validation Function.
My Excel Sheet is now working find..
against Thanks
Regards
Nikhil Shah
On Sat, Jul 10, 2010 at 4:51 PM, saggi realsa...@gmail.com wrote:
Dear Nikhil,
Use Data Validation for reflect the error
Dear Friends
Here i am sending One URL For Excel - Macro Training in excel 2003.
http://www.familycomputerclub.com/excel/excel2003_macros.html ( With Video )
In English Hindi also
I think , it gives some knowledge about how to write macro..
Regards
Nikhil Shah
, Jul 10, 2010 at 10:32 PM, Nikhil Shah nikhil201...@gmail.comwrote:
Dear Friends
Here i am sending One URL For Excel - Macro Training in excel 2003.
http://www.familycomputerclub.com/excel/excel2003_macros.html ( With
Video ) In English Hindi also
I think , it gives some knowledge about
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is dd/mm/ )
Deduct : 6 ( Months )
Answer Should be : 30/09/2010
Thanks
Nikhil Shah
--
--
Some important links
Hi Friends
Query :
I have a drop-down list that displays at about a size 6 (or smaller) font
when the worksheet is displayed at 75-100%. I can make it readable by
changing the magnification of the sheet to 150-200%, but that takes the rest
of the sheet out of view, interferes with functionality,
only enter the Policy number.
Awaiting Reply.
Nikhil Shah
On Thu, Jun 17, 2010 at 5:28 PM, vidyut more vidyutm...@gmail.com wrote:
Dear Nikhil
I have modified ur data and tried mybest.look at attachment
Dear Sumit,
Thanks For Help
Regards
Nikhil Shah
On Sat, Jun 19, 2010 at 2:22 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Hello Dear
Find Check
On Thu, Jun 17, 2010 at 5:28 PM, vidyut more vidyutm...@gmail.com wrote:
Dear Nikhil
I have modified ur data and tried mybest.look at attachment
opens in the
master sheet and shows all the details of that particular selected policy
number like, name of the person,premium amount , bank details and all other
details without going into the data sheet.
Awaiting Reply
Nikhil Shah
Hi
Thanks for sending Excel formula
Can you explain me how to display formula n yellow box as u done in this
sheet?
Regards
Nikhil Shah
On Mon, Jun 14, 2010 at 12:04 PM, vidyut more vidyutm...@gmail.com wrote:
hi
it can be done by using sumif and counif formula.plz see attchment
will prepare a pivot for you.
Best regards,
Ayush Jain
On Fri, Jun 11, 2010 at 9:31 AM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi Ayush,
Recd you e-mail.But I do not have any knowledge how to use pivot table.
can you help out in this query..
Best regards
Nikhil Shah
On Fri, Jun 11
Hi Friends,
Here I am posting Query, pl help.
Name Amt
Bill1,000
Gopal1,500
Bill3,000
Ashok 4,500
Bill2,000
Gopal 500
Now I want the Answer : Bill 6,000 3
Gopal 2,000 2.
Thanks
Nikhil
--
Wow..Great Tools
Thanks
Nikhil
On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
*Hi Guyzzz*
*
*
*I found a great tool on internet.*
*You can control Window Media Player using this Excel based tool.*
*If you have tools like these, kindly share with the
61 matches
Mail list logo