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 wrote:
> Dear Friends,
>
> I have accumulate the my collection for Excel. Please update, If you
> anything more.
>
> I hope these links are ve
) 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 wrote:
> You need to provide a file.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Nikhil Shah
> *Sent:* Saturday, A
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 wrote:
> Hello Nikhil,
>
> This will give the current quarter.
>
> =TEXT(LOOKUP(MONTH(A1),{1,4,7,10})*29,"mmm
Hi sam,
super Idea
Nikhil Shah
On Sun, Apr 15, 2012 at 7:01 PM, Sam Mathai Chacko wrote:
> A shorter one
>
> =CHOOSE(CEILING(MONTH(A1)/3,1),"April","July","October","January")
>
> Regards,
> Sam
>
>
> On Sat, Apr 14, 2012 at 6
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 wrote:
> Nikhil,
>
> I got an
Hi Haseeb,
Nice Formula..
Thanks
Nikhil
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A wrote:
> 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((1&B2)+99,"")
>
> Copy across to E2.
>
>
> Se
Congratulation Rajan
Nikhil Shah
On Mon, Jun 4, 2012 at 11:02 AM, Maries wrote:
> *Congrats Brother.*
>
>
> On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli wrote:
>
>> congrats Mr Rajan.
>> Gawli Anil
>>
>> On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI
Hi Noorain ,
Thanks for sending excellent Chart File..
Nikhil
On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI wrote:
> Dear Group,
>
> Please find attached Clock Chart.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
> --
> FORUM R
Dear Ayush,
Excellent ToolsThanks
Nikhil Shah
On Fri, Jun 10, 2011 at 10:13 PM, Ayush wrote:
> Well, he's done it again. My good friend John Franco just uploaded these free
> lookup syntax mastery
> downloads<http://www.1shoppingcart.com/app/?Clk=4338508>for you.
&
y 5 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 tri
Hi Daniel
Thanks for solving my problem.
Nikhil Shah
On Tue, Jul 26, 2011 at 5:01 PM, Daniel wrote:
> Hello,
>
> ** **
>
> Have a look at the attached workbook.
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
>
Dear Haseeb
Thanks For Excellent Logic..
Your logic is difference from Daniel.
Can you tell why you are not using DATEDIF formula ? Your answer is also
right..
Nikhil
On Wed, Jul 27, 2011 at 12:13 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Nikhil,
>
> See the attach
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
://noorain-ansari.blogspot.com/>
>
> On Tue, Sep 13, 2011 at 11:32 AM, Nikhil Shah wrote:
>
>> Dear all,
>>
>> I want Help for creating the VBA Codes for Repeating of Text in my Excel
>> sheet..
>>
>> *Problem :*
>>
>> I have made excel sh
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 wrote:
>
>
> --
>
>
> Regards
>
> [image: Description: cid:image003.
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 b
Wow..Great Tools
Thanks
Nikhil
On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote:
> *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 group.*
> *
> *
> *
lect the item(
> tied to a CHANGE_EVENT macro. Send me your file with a clear explanation and
> before/after examples
>
>
> *From:* Nikhil Shah
> *Sent:* Tuesday, September 13, 2011 9:02 AM
> *To:* excel-macros@googlegroups.com
> *Cc:* noorain.ans...@gmail.com
> *Sub
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 wrote:
> Dear
>
>
Selection.Value = "Dividend"
> Case "g"
> Selection.Value = "Growth"
> Case "a"
> Selection.Value = "Additional"
> Case "f"
> Selection.Value = &qu
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 wrote:
> Dear Friend,
>
> Wow..Super..Excellent Code..This is very very helpful me..it 's save my
>
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 wrote:
> Dear Sandeep,
>
> Please try it,
>
> Sub convert_txtfile()
> On Error GoTo abc
> Dim txtifile
> txtifile = Appl
Hi Noorain
Excellent work Noorain.
Regards
Nikhil
On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain 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 through his
> expertise
Dear Noorain
Excellent Help.
Example 9 - Sheet is showing some error...Can you rectify ?
I am using Office Excel 2003.
Thanks in advance
Nikhil
On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI
wrote:
> Dear Group,
>
> Please find attached Sheet to use 10 Simple way to use Indirect Function
m/>
> On Tue, Nov 15, 2011 at 12:55 AM, dguillett1 wrote:
>
>> That example is using an external file so the defined name shows ref
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Nikhil Shah
>> *Sent:* Mond
Dear Amit
Please Try this formula
=DATEDIF(B2,TODAY(),"M")..
Nikhil Shah
On Wed, Nov 16, 2011 at 5:30 PM, Amit Desai (MERU)
wrote:
> Dear Noorain,
>
> ** **
>
> I am still getting the same error, see the sample data point..What I want
> is
Wow.. Wonderfull Sheet Mahesh..
Thanks
Nikhil Shah
On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab wrote:
> its really Amazing!
>
> check this link
>
> http://www.xcelfiles.com/ImageToXL.html
>
>
>
> HTH
> Mahesh
>
> --
> FORUM RULES (934+ members a
Hi Maries,
Can you tell me how you select Term_Code ?
Nikhil
On Sat, Dec 10, 2011 at 11:05 PM, Maries 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 > wrote:
>
>> Dear Expert,
>>
>> Here
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 wrote:
> Dear all expert,
>
> Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce t
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%
19
ree 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
> *S
roups.com [mailto:
> excel-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
o:
> excel-macros@googlegroups.com] *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
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 wrote:
> Hi,
>
> With the help of a helper column, a Pivot table would do the trick.
>
> PFA.
>
> Kris
>
Dear Noorain
Excellent Tips..
Thanks
Nikhil Shah
On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI wrote:
> Updated Sheet
>
>
> On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa wrote:
>
>> Dear Noorain
>>
>> It converts with Rupees and i want only for words
>>
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 wrote:
>
> =IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2),"")
>
> Rega
Hi Maries,
Thanks..Excellent Tools..
Regards
Nikhil Shah
On Tue, Feb 7, 2012 at 4:08 PM, Maries wrote:
> *Find the attached Excel File
> *
> On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI
> wrote:
>
>> PFA
>>
>>
>> On Tue, Feb 7, 2012 at 1
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
--
-
will prepare a pivot for you.
>
> Best regards,
> Ayush Jain
>
>
> On Fri, Jun 11, 2010 at 9:31 AM, Nikhil Shah wrote:
>
>> 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..
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 wrote:
> hi
> it can be done by using sumif and counif formula.p
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
can only enter the Policy number.
Awaiting Reply.
Nikhil Shah
On Thu, Jun 17, 2010 at 5:28 PM, vidyut more 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 wrote:
> Hello Dear
>
> Find & Check
>
> On Thu, Jun 17, 2010 at 5:28 PM, vidyut more wrote:
>
>> Dear Nikhil
>> I have modified ur data a
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 for
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, a
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 wrote:
>
> Dear Nikhil,
>
> Use Data Validation for refle
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
Jul 10, 2010 at 10:32 PM, Nikhil Shah wrote:
>
>> 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
>&g
Hi Rajendra Soni,
Wow Great Help for sending Excel URL
Nikhil Shah
On Mon, Jul 12, 2010 at 10:04 AM, Soni.Rajender wrote:
> Hi
>
> Please find below the link for MS Excel resources.
>
>
> http://www.google.co.in/search?tbs=bks%3A1&tbo=1&q=ms+excel&b
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 wrote:
> Hi Nikhil,
> Its done however i am not getting the option to upload a file into
> discussion. I have uploaded the file
filled.
For Pl see Main menu..
Regards,
Nikhil
On Wed, Aug 4, 2010 at 4:49 PM, Maries 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 A
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:
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
Nik
1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND("
> ",A1,1)+1)+1,1)
>
>
> Regards,
>
> Mithlesh Sharma
>
> On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah wrote:
>
>> Hi Friends,
>>
>> In Column " A " .. I have written --- > Vishal Pravin
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 for
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
Dear Daniel
Thanks for FormulaYou have solve my problem..
Regards
Nikhil Shah
On Thu, Dec 2, 2010 at 5:20 PM, Daniel 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))
&g
Chilexcel
Hi..Excellent Tools..it save my time..
Great Utility
Regards
Nikhil
On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote:
> yes
>
> yes, download this application .
> http://www.todoexcel.com/office-tabs/
>
>
> also you can do with "Navigator Toolbar for Workbook Sheets"
> http://ww
Hi Ashish,
Thanks For sending Sheetnames excel sheet..Great help..
Regards
nikhil
On Sun, Dec 5, 2010 at 11:16 AM, ashish koul wrote:
> try this addin save it on your dektop and double click it.
>
> On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote:
>
>> yes
>>
>> yes, download this applicatio
Hi Vasi,
Pl visit Follwoing web site for your query : Salary Calculator
http://www.caclubindia.com/
Regards
Nikhil Shah
On Fri, Dec 10, 2010 at 12:01 PM, vasisd wrote:
> Dear Experts,
>
> I am looking for a Salary Calculator for a Industrial Pvt Ltd Company based
> in MIDC
Thanks..
Nikhil
On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote:
> 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 do you wan
64 matches
Mail list logo
