Mule Soft Developer Indianapolis, IN
*Ankit Mendiratta*
*Sr. Technical Recruiter*
T: + 877-884-8834 EXT:2055
ankit.mendira...@mastechdigital.com
www.mastechdigital.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook
Informatica Admin Paige, Texas
Thanks and Regards,
Ankit Mendiratta
Sr. Technical Recruiter
T: + 877-884-8834 EXT:2055
ankit.mendira...@mastechdigital.com
Mastech Digital
1305 Cherrington Parkway
Building 210, Suite 400
Moon Township PA 15108 www.mastechdigital.com
--
Are you
Pls add my number 9560718272
On Sep 3, 2016 7:19 AM, "Suhas" wrote:
> Hi, Please add me to the whatsapp excel group. My Nbr +91 9791760609
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> http
Hi Madhu,
Myself Ankit Mehra and I am a non IT individual. I am looking for a non IT
related job in US. If you could assist me in contacting the concerned
individual, I will appreciate that.
Thanks,
Ankit Mehra
On 12 Nov 2015 12:57 am, "MADHU-GenuineItLlc"
wrote:
> Hi Partner,
>
Dear Experts i want a formula that fulfill my both conditions pls solve
this.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accura
Hi,
I want to record the macro's through which i can automate the data base
that ways i want to enter details in main sheet and data should get
accumulate in compile sheet once i save it.
Please help me out in recording the macro's.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Hi,
I want to record the macro's through which i can automate the data base that
ways i want to enter details in main sheet and data should get accumulate in
compile sheet once i save it.
Please help me out in recording the macro's.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
HI,
Email on tyagi@gmail.com.. for what macros u r looking for... i can
help u.
On Sunday, January 26, 2014 8:31:10 AM UTC+5:30, Frank Friedland wrote:
>
> Hi I need someone to write macros for me, please email me.
> Best
> Frank
>
> On Saturday, February 19, 2011 2:17:51 AM UTC-5, rashid
Hi Joe,
In order to do so, an user form needs to be created which will ask for a
user name and password. Once the individual specifies the credentials, user
will be able to work on this.
If you could share the file, this can be done.
Thanks,
Ankit Mehra
On 8 Feb 2014 13:32, "Joe Rainone&qu
that those mails
information is not copied again in the file.
Please suggest.
Thanks,
Ankit Mehra
On 7 Feb 2014 00:01, wrote:
> Hi Ankit
>
> Save the outlook mail as word document and then open the document and copy
> content and paste it in excel
>
> You need to automate above
*US015*
20566848
165,797.27
10-Jan-14
14-Jan-14
*US023*
20566852
$120,297.86
10-Jan-14
20-Jan-14
*US077*
20566850
$266,247.26
10-Jan-14
10-Jan-14
Thanks & Regards
Ankit Mehra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,D
this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
Thanks & Regards
Ankit Mehra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear Expert
Please tell me how can i link 3-4 workbooks and spreadsheets
Thanks & Regards
ANKIT JAIN
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
F
Hi all,
Need help on this.
Regards,
Ankit
On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal
wrote:
> Hi Haseeb,
>
> Thanks for your mail. this is really help me. but I have some point which
> can make it more effective and efficient.
>
>
>- Department code will be
write it twice and more time.
Except above point sheet and process is really good and helpful to me
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
wrote:
> Dear All,
>
> I have a salary sheets where there are three column i.e. Name, Department
> and salary. I need dep
Hi All,
Can it be possible or I have to do same process which I am doing.
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
wrote:
> Dear All,
>
> I have a salary sheets where there are three column i.e. Name, Department
> and salary. I need department wise salary she
attached sheet.kindly give me better way to prepare it.
Regards,
Ankit
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Hi,
I need some budget template. Please share some budget template.
Regards,
Ankit
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
HI,
My name is Ankit Agrawal, I'm from New Delhi. Working as Asst A/c manager
with a SS Kothari Mehta & Co.
Apart from my work, I like to travel, music.
Excel plays major supportive role in accounting and reporting.
I am really happy to be a part of this forum.
Thank you Ayush Ji.
Deal All,
I need your help on the same.
Any Confusion plz let me know.
Regards,
Ankit
On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal wrote:
> Dear all,
>
> I have some data in one sheet and I have to generate report which format
> is also on second sheet. How can we generate it
Congratulation Rajan and other excel's mentors.
Regards,
Ankit
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> April'2012
> He has posted 185 posts in April 2012
Thank you sir,
Regards,
Ankit
On Thu, Feb 23, 2012 at 7:15 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please attached sheet with solution..
>
> --
> Thanks & regards,
> Noorain Ansari
> ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
>
Dear Sirs,
I have query, plz solve it.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
HI Ayush,
I think, Mr. Noorain has already achieved this. I do not sure about the
month but indeed, he has achieved it
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175
[?][?][?][?]Congratulation [?] Sir[?][?][?][?]
On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He
Thank you sir,
Regards,
Ankit
On Tue, Jan 17, 2012 at 7:08 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please download PDF file for financial Analysis tools and techniques..
>
> http://www.caclubindia.com/share_files/financial-analysis-tools-and-techniques-a-guide-pdf-5677.asp
&g
Dear All,
I need financial analysis tools file & plz send me.
Regards,
Ankit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
Dear All,
Please suggest me any Business & Financial analyst or related group.
Thanks
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Thank you boss!!
On Tue, Dec 20, 2011 at 11:53 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Ankit,
>
> Another way. See the attached.
>
> ___
> HTH, Haseeb
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
>
thank you sir,
But how could I use it in another sheet.
Regards,
Ankit
On Tue, Dec 20, 2011 at 3:25 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please find attached Sheet, I hope it will help to you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://exce
Dear All,
Could we use drop down function using "if" condition.
Example is attached
Regards.
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pr
Dear All,
I need financial excel tool for analysis of different situation.
You are requested to send me this kind of sheet.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Dear Dguilett
I dont know to apply it in excel.Plz apply it in file.
Regards,
Ankit
On Tue, Dec 13, 2011 at 7:46 PM, dguillett1 wrote:
> What happened to this code that I had offered? You can certainly add a
> provision to automatically mark your column.
>
>
> Private Sub W
Dear Sir,
I need manual input.
Regards,
Ankit
On Mon, Dec 12, 2011 at 9:21 PM, Maries wrote:
> Hi Ankit,
>
> Please confirm whether you want it by Auto number or manual input.
>
> Regards,
>
> MARIES.
>
>
> On Sun, Dec 11, 2011 at 8:15 AM, Ankit Agrawal > w
(TODAY) function it change on daily basis
Suppose I put this formula =IF(I17="","",TODAY()) then it will change
on daily basis.
Regards,
Ankit
On Sun, Dec 11, 2011 at 9:24 AM, Ankit Agrawal
wrote:
> Dear Sir,
>
> I had some confusion regarding my sheet now it has been c
Dear experts,
I Need finance related MIS & its tutorial.Also need your valeable
suggestion,How we improve our Finance MIS & reports.
Please send me who ever having it.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titl
hould be in DD/MM/ format & the
separator already mentioned
for example
As we enter 23 then corson automatically come in month section after
entering the month section cursor should come in year section
Regards,
Ankit
On 12/10/11, Maries wrote:
> Dear Ankit,
>
> Find the attached f
proval.& in case amount is
lower then column F then put the value in column "M".& again when we enter
in same cell it will add in old amount.
Looking for you response..
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread
Deal All,
PFA as per your query.
Regards,
Ankit
On Fri, Dec 9, 2011 at 8:19 PM, dguillett1 wrote:
> You need to give examples
> col b. could/should be from data validation list
> col a. incremented automatically when you enter col B. Example of next
> number
> col c. same as
Dear Expert,
Please help me to solve out query in attached excel.
Here one excel file where I want to do some column automatically.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Congratulations Sam... Keep impetus on...!!!
On Mon, Dec 5, 2011 at 4:35 AM, Haseeb Avarakkan wrote:
>
> Congratulations Sam... Keep up the excellency!
>
> Hello Lali,
>
> FYI: Please read the forum rules. Rule# 2 says, "*Don't post a question
> in the thread of another member -- start your own.
uments.
- *Disabled Application Add-ins* Lists add-ins that were
automatically disabled because they are causing Office programs to crash.
how to use SureshAddin.xla
syntax:-
=rswords(cell no.)
Example:
suppose we have a num value in cell 'B2'
we will write
=rswords(b2)
Regards,
Ank
I am in Delhi(Near Laxmi Nagar & Noida)
On Thu, Nov 24, 2011 at 12:22 PM, wrote:
> **
> Where are you located??
>
> Sent on my BlackBerry® from Vodafone
> ------
> *From: * Ankit Agrawal
> *Sender: * excel-macros@googlegroups.com
> *Date
Dear All,
Plz tell me any good institute for excel where I can learn advance excel.
Regards,
Ankit
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Noorain Sir,
I tried to understand it by example also but failed to understand.I know
this is my fault but please make me understand in easy word, I can not
understand in technical language.
I will oblige you.
Regards,
Ankit
On Fri, Nov 18, 2011 at 2:45 PM, NOORAIN ANSARI wrote:
> Dear An
Hi,
Plz tell me what is the use of indirect function & what it can do?
Regards,
Ankit
On Tue, Nov 15, 2011 at 2:49 PM, NOORAIN ANSARI wrote:
> Dear Smitha,
>
> Please find & see attached sheet with example of below formula.
>
>
> --
> Thanks & r
HI,
If both string are same then 1 or anything else like true otherwise false o
anything else/
Regards,
Ankit
On Thu, Nov 3, 2011 at 5:56 PM, dguillett1 wrote:
> If?? I understand your question then
> =if(a1<>b1,”diff”,””)
>
> Don Guillett
> SalesAid Software
&
Hi Expert,
Plz give me any formula for diff in string
example-
If cell A1 contain Ashish & B1 contain Ashish
& we want to diff in A1 & B1 then how we can formulate it
Thanks & Regards,
Ankit
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accura
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Dear Sirs,
Please provide me sumproduct functions sheet which having different example
in it.
@Noorain Ansari sir, Looking your help also.
Thanks & Regards,
Ankit
--
--
Some important links for excel user
Hi Noorain,
Could you plz make me understand how has it been done?
Thanks
Regards,
Ankit
On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI wrote:
> Dear Surya,
>
> Please see attached sheet
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http
Congrats Noorain. You deserved it..
On Fri, Oct 14, 2011 at 11:40 AM, Subhash Yadav wrote:
> Congratulations Noorain...
>
>
> Thanks for your helps provided..
>
> Regards,
>
>
> Subhash Yadav
>
> On Thu, Oct 13, 2011 at 8:51 PM, Dilip Pandey wrote:
>
>> Congratulations NOORAIN.
>>
>> sorry for l
Dear All,
could anyone have formula sheet with its illustration. I need it
Thanks
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutor
Now its working...
Thanks...
On 10/13/11, Dilip Pandey wrote:
> Nice collection Noorain...
>
> Regards,
> DILIPandey
>
> On 10/12/11, NOORAIN ANSARI wrote:
>> Dear Ankit,
>>
>> Please find below Short Cut keys,I hope it will help to you.
>>
>>
Dear All,
I am trying but it is not doing.Plz help me to solve out it.
Regards,
Ankit
On 10/12/11, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please find below Short Cut keys,I hope it will help to you.
>
> 1. *Apply* an outline border
> *[Ctrl]+[Shift]+[&] *
>
>
I need it in 2007.
Regards,
Ankit
On Wed, Oct 12, 2011 at 3:34 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please Click on the first worksheet tab, and while holding down shift,
> click on the
> last worksheet tab to group the sheets.
>
> Then click *FILE* in the menu,
Thanks but it is not working.
Regards,
Ankit
On Wed, Oct 12, 2011 at 2:55 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please find below Short Cut keys,I hope it will help to you.
>
> 1. *Apply* an outline border
> *[Ctrl]+[Shift]+[&] *
>
> 2. Remove the out
Hi,
How can I insert one Header & footer for entire workbook.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Dear All,
I need shortcut key for all border.plz help me.
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Thanks to all.
Ankit
On Fri, Sep 23, 2011 at 4:46 PM, NOORAIN ANSARI wrote:
> Dear Ankit,
>
> Please see attached sheet with solution.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.b
Dear Sir,
This is not working & plz tell me how we can do it another files.
Regards,
Ankit
On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ wrote:
> of course
>
> pfa
>
>
> --
> *Great day,*
> *viper
>
> *
> On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal
Dear Sir,
It is not working.and plz tell how we can apply it on other sheet too.
Regards,
Ankit
On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ wrote:
> of course
>
> pfa
>
>
> --
> *Great day,*
> *viper
>
> *
> On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agraw
Dear All,
I want to show a messge when we enter value which is more than 50k.As we
type 6 at that time a message show approval need.
Could it possible?
Regards,
Ankit
--
--
Some important links for excel users
Dear Sir,
Please give me any update.
Regards,
Ankit
On Wed, Apr 27, 2011 at 6:07 PM, Ankit Agrawal
wrote:
> Dear All,
>
> I really appriciate your valuable help.you all are really ameging peson.
>
> I have two different sheets.First is used for giving the PO/SOW(Statement
> o
Guys pls help!!!
On Mar 13, 1:30 pm, Ankit wrote:
> Guys need help in editing links of a worksheet with more than 100
> links like this -
>
> Now excel file is in March'11 folder with below link-
>
> D:\F&F\Feb 11 - Circle\AA\GA - AA_F&F_FEB_2010-11.xlsx
> D
It's working... thanks alot ashish... you are rocking
On Mar 11, 8:13 am, ashish koul wrote:
> hi'
>
> see if it helps
>
> first click on get file names then type the new names manually in col d and
> run the rename macro
>
>
>
>
>
> On Tue, M
Guys need help in editing links of a worksheet with more than 100
links like this -
Now excel file is in March'11 folder with below link-
D:\F&F\Feb 11 - Circle\AA\GA - AA_F&F_FEB_2010-11.xlsx
D:\F&F\Feb 11 - Circle\AB\GA - AB_F&F_FEB_2010-11.xlsx
D:\F&F\Feb 11 - Circle\AA\Other Cost - AA_F&F_FEB
the Filenames of a
> Directory<http://www.excelitems.com/2010/12/replace-characters-filenames-vba.html>
>
> Hi Ankit,
>
> This is such a simple problem and hence the solution, that I don't need to
> provide long texts explaining that what it does. Simply, see the figure
CASE- lest say there are 500 files in 10 diff sub folder & I want to
rename
all files with specific name..
FEB'11> 10 Files > Each file> 10 files like HR & Establishment Cost -
ANP_F&F_FEB_2010-11
And I want
Mar'11> 10 Files > Each file> 10 files like HR & Establishment Cost -
ANP_F&F_MAR_2010-1
Please Help
How to Protect a Excel sheet with password in MS 2007, so that no one
can open the file without password.
Thanks
--
Ankit Varshney
9716588239
--
--
Some important links for excel users:
1. Follow us
Again a recommendation, if it is transfer in to the PDF with password.can it
possible.
Regards,
Ankit
On Mon, Nov 29, 2010 at 11:19 AM, Ankit Agrawal
wrote:
> thank you sir,
>
> Its done dana done.
>
>
> On Sun, Nov 28, 2010 at 11:12 AM, wrote:
>
>> Dear A
thank you sir,
Its done dana done.
On Sun, Nov 28, 2010 at 11:12 AM, wrote:
> Dear Ankit,
>
> Thanks for your appreciation, Is your query solved. If not then what type
> of error is occurring.
>
> You need to create payslips folder in C drive. And all files are stored in
>
Namste Vaibhav ji,
*Unbelievable task. *how I tell you what you are? but sir after clicking it,
it add sheet and creating the file as well. but not saving it and occurring
a error. so please implement it also.
Thanks & Regards
Ankit
On Fri, Nov 26, 2010 at 8:37 PM, in.
need the
separate files for every employee in particular months.
Thanks for your effort and really its mind blowing.
Thanks & Regards,
Ankit
On Thu, Nov 25, 2010 at 11:05 PM, wrote:
> Dear Ankit,
>
> I have made one macro this will send payslip as in-line to email.
>
> Follow th
Thank you Vaibhav.
Your help is really appreciable. if any one do help via your phone that is
mind blowing help.
On Mon, Nov 22, 2010 at 8:08 PM, wrote:
> Dear Ankit,
>
> For sending email through excel following is basic requirement:
>
> If you want to send email directly with
Dear All,
I did not get any solution from your side so it mean it does not have
solution or no body knows about it.
at least any body can give any suggestion on it
On Tue, Nov 16, 2010 at 6:53 PM, Ankit Agrawal
wrote:
> Hello Sir,
>
> I have a problem related to mail through excel. ba
so please illustrate it because I am new
in the excel and don't know much more about other computer software & tools
Thanks & regards
Ankit
--
--
Some important links for excel users:
1. Follow us on TWI
Hi all,
Please send me shortcut keys file of excel. I need it
Thanks & regards
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldail
so please illustrate it because I am new
in the excel and don't know much more about other computer software & tools
Thanks & regards
Ankit
--
--
Some important links for excel users:
1. Follow us on TWI
DE IS KEY )
>
> WRITE ONLY EMP. CODE THE WHOLE DETAIL U CAN EXTRACT.
>
> On Tue, Oct 5, 2010 at 12:40 PM, P.VIJAYKUMAR wrote:
>
>> Hello Ankit,
>>
>> I did not understand you question properly. Why do use mail merge .You can
>> create single sheet work book as you
Thank you for your help
But Sir I am using 2003 excel & i m working on networking PC thus I think
the add-in did not install properly.
On Tue, Oct 5, 2010 at 12:35 PM, P.VIJAYKUMAR wrote:
> Dear Ankit,
>
> To use the add-in select the number you want to convert into text.the
Thank you sir for deteil knowledge but again same problem *how we can use
add-in? plz tell me *
**
Thnanks & Regards
Ankit
On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR wrote:
> Dear Ankit,
>
> There is no Direct formula to convert numbers into text.But there are some
> add-
But how
Thanks & regards
Ankit
On Mon, Oct 4, 2010 at 9:15 PM, krishna mummina wrote:
> You may use of macro.
> I am not sure about Password for the file, but You can send
> automatically to the Con
But sir how it add in to excel.
Thanks & Regards
On Mon, Oct 4, 2010 at 1:35 PM, Mahesh wrote:
> Hi ankit,
>
> Attached herewith is the add in.
> hope this will solve the issue.
>
> On Mon, Oct 4, 2010 at 12:04 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com>
one.
Question
1- Is any way that we can make saperately file autometically and send to it
mail autometically to each employee.
2- is any way that every file haveing its own password and its password
would be employee DOB or any other key
I wish it has solution.
Thanks & regards
A
I have add it But How to use it.
thanks & regards,
ankit
On Mon, Oct 4, 2010 at 4:40 PM, Ankit Agrawal wrote:
> But sir how it add in to excel.
>
> Thanks & Regards
>
> On Mon, Oct 4, 2010 at 1:35 PM, Mahesh wrote:
>
>> Hi ankit,
>>
>> Attached her
Thank you sir but it happen in only one file if we want to def ult it means
in every excel sheet it implement automatically.
Thanks & regards
Ankit
On Mon, Oct 4, 2010 at 10:18 AM, C.G.Kumar wrote:
>
> See http://support.microsoft.com/kb/213360
>
>
> <http://support.m
Hello Sir,
Plz tell me any formula that convert number to text like
1500/-
one thousand five hundered only
Thanks & Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hello siti,
thanks for your solution. but i did not get it how it has happened. please
can you brief it.and tell me any solution which may forever in excel.
with regard,
Ankit
--
--
Some important links for excel
thank you sir,
but again it is not easy to me yet, But I m trying to understand it.
On Sun, Aug 29, 2010 at 7:17 PM, Maries wrote:
> Dear Friend,
>
> Pls. find the attached file.. it will help you to know HLOOKUP and VLOOKUP.
>
> Regards,
>
> Maries
>
>
> On Sun,
I did not get it what does it means? i m newly in excel, so plz decribe it
thanks & regards
ankit
On Sun, Aug 29, 2010 at 10:14 AM, Dave Bonallack
wrote:
> Hi,
> You have custom formatting in the both of your main data columns, which
> means that only the numeric value is entered
Hello Sir,
I need help in separate the num & alpha value in the one cell into another
two cells.so i am attaching a sample file in it, in sample file I have two
column and having the num and alpha value like 14.300kg or 23.30/kg so on...
and I have to separate these value in two column like 14.300
e my domain in excel.
Thanks & regards
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN grou
like 14.300 in one column
and kg in second column.
Plz help me in this criteria.
thanks & regards
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
I am attaching a sample file, in this file, there are two column one for qty
& second one for the rate. I have to separate the qty column in qty & its
unit & again in rate column.I have written in attach copy what format i
required in the sheet.
thanks & regards
Ankit Agrawal
separate in unit
name and the price.
plz consider it and tell me.
Thanks to you all.
Ankit Agrawal
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Thanks you sir, i will try to do it
On Mon, Jul 12, 2010 at 12:45 PM, George wrote:
> Hi Ankit,
>
> You can run this code and enjoy.
>
> Sub Macro1()
>Columns("A:A").Select
>Selection.Copy
>Windows("as.xls").Activate
>Columns(&q
' of a.xls will go on column 'F' of the as.xls
Please consider my problem and give me a solution of it.In my opinion it may
solve by macros but i do not know how to use the macros so please suggest me
thank you for your consideration.
with warm regards
Ankit Agrawal
--
Dear,
Can u plz tell me exact procedure.i do hv ASAP utilities.
--- On Tue, 6/7/10, Mahesh wrote:
From: Mahesh
Subject: Re: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Date: Tuesday, 6 July, 2010, 9:50 AM
Hi Ankit,
Use ASAP utilities, it will solve your problem.
On Tue, Jul
1 - 100 of 117 matches
Mail list logo
