Dear Friends,
Assume that following values are in A1,A2, A3 . Column.
I want to split the Alphabetic Name in B1, B2.. Column & Numbers in C
Column. Pl. help.
Alphanumeric Data Expected Answer A Column B Column C Column
Dhananjay420 Dhananjay 420 Ramesh007 Ramesh 7 Prashant786 Prash
> Did you put your excel in same directory with your current Power Point
> File ? If Not try to do that and then re-link it again.
> With hyperlink file creation in same folder, it will create hyperlink with
> dynamic link.
>
> Rgds,
> [dp]
>
>
> On 15/07/2013 14:49, Dh
Hi Friends,
I need to insert Excel file in PowerPoint presentation. I used "Hyperlink'
option. It is working fine on my PC. But when I send the same powerpoint
presentation to another user, he is not able to access Excel File. It
showing error. Pl. advice.
Regards,
Dhananjay
--
Are you =EXP(E:
(pl.
refer attached Excel File for revised query). Pl. help.
Regards,
Dhananjay
On 9/10/12, Dhananjay Pinjan wrote:
> Wow!!! Thanks.
>
> On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon
> wrote:
>
>> See attached
>>
>> On 10 September 2012 05:02, Dhananjay Pinjan
Hertiest Congrats Noorain Ansari. Do continue. Best Luck
On 9/12/12, SAGAR KASANGOTTUWAR wrote:
> Congratulations Noorain...
>
> Best Regards,
>
> sagar
>
> On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon
> wrote:
>
>> Loveufe2001
>>
>> I suggest you post your question in its own thread a
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon wrote:
> See attached
>
> On 10 September 2012 05:02, Dhananjay Pinjan wrote:
> > Dear Experts,
> >
> > I need a solution as per my query in attached file.
> >
> > Pl. revert in cas
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or any confusion.
Regards,
Dhananjay
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Hi Experts,
I need a countdown macro as per attched file. Pl. help.
Regards,
Dhananjay
--
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, lik
Thanks Ashish.
-- Forwarded message --
From: ashish koul
Date: Mon, 6 Aug 2012 20:07:56 +0530
Subject: Re: $$Excel-Macros$$ time counting macro
To: excel-macros@googlegroups.com
see if it helps
On Wed, Aug 1, 2012 at 6:39 PM, Dhananjay Pinjan wrote:
> Dear Expe
Dear Experts,
I need a macro which START counting from "ZERO" in
"hh:mm:ss: format. When I stop the STOP Macro Button, The counting
also should have to stop.
Ex - If I Start Macro, The cell should have to start counting
'00:00:00' & if I press 'STOP' Button after 5 Min. & 45 Sec.' the cell
figur
cpap.com.br/orlando/ExcelClockMore.asp?IdC=OMKtPlcG
> http://chandoo.org/wp/2012/07/05/masterchef-style-clock-in-excel/
>
>
>
> On Sat, Aug 4, 2012 at 11:23 PM, Dhananjay Pinjan
> wrote:
>
>> Dear Experts,
>>
>> I need a macro which started counting in any cel
Dear Experts,
I need a macro which started counting in any cell in "hh:mm:ss" format.
Also, another macro needs to stop that counting (stop time may be vary)
Thanks in advance.
Regards,
Dhananjay
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
Sorry. I would like to thanks to Ayush. Ashish Kaul as well.
On 8/4/12, Dhananjay Pinjan wrote:
> Hi Experts,
>
> I am Dhananjay Pinjan from Pune, Age- 28, working at TATA Motors Ltd.
> I always like to work with Excel Features. I become Excel addict. I
> also encourage pe
Hi Experts,
I am Dhananjay Pinjan from Pune, Age- 28, working at TATA Motors Ltd.
I always like to work with Excel Features. I become Excel addict. I
also encourage people to use the Excel’s maximum features which save
our time a lot.
And Ashish, you are fantastic. You are driving this forum so
Dear All,
I have used Rank Formula for ranking (pl. refer attachment). But if
Highest Column reflects 2 same value (in following example 104) it
should have to consider lower weight (Column A) & should have to give
first rank to him. The expected answer is as follows.
Weight NameHighest Ran
Dear Experts,
If I type *'523* (value with apostrophy) in a cell & when I press Enter
,the value should become Strikethrough like
523.
Pl. help is there any way? If macro is possible can also work.
Regards,,
Dhananjay
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concis
n-us/excel-help/sumifs-function-HA010047504.aspx
>
> On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan wrote:
>
>> Dear Ashish,
>>
>> Pl. explain what is *"=_xlfn."*
>> SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5)
>>
>>
>>
>> Regards,
&g
Dear Ashish,
Pl. explain what is *"=_xlfn."*SUMIFS($G:$G,$M:$M,$P6,$F:$F,$O6,$D:$D,Q$5)
Regards,
Dhananjay
On Sat, Apr 9, 2011 at 4:07 PM, ashish koul wrote:
> see if it helps
>
>
> On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi wrote:
>
>> Please reply.
>>
>> --
>> Nemi Gandhi
>> 98204 92963
Congrats Ashish. Go ahead.
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 4:08 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Congratulations Ashish….
>
>
>
> You are simply amazing… thanks for the tips and hats off to you for your
> excel knowledge….
>
>
>
> I really amazed with ho
u can use the following formula
=SUBSTITUTE(A1,0,"")
(where Cell A1 is target data)
Regards,
Dhananjay
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote:
> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhan
Thousand time Congratulation dear Ayush. This forum will definately played a
very vital role for whom those are very eager to know the Excel.
Thanks for your always support to the members of our various Excel Group.
Regards,
Dhananjay
On Sun, Mar 20, 2011 at 9:21 PM, Ayush Jain wrote:
> Dea
Instead of "SIMPLEEXCEL??"
"Simplicity of Excel" is suited more .
On Tue, Mar 1, 2011 at 11:23 PM, Dhananjay Pinjan wrote:
> Hi Ayush,
>
> First thanks for your always help and support to the group. This is the
> very good news for all the Excel Lovers of this G
Hi Ayush,
First thanks for your always help and support to the group. This is the very
good news for all the Excel Lovers of this Group. Here is some my addition:
"*Excel*lence in Excel"
“*G*et *S*et *T*o *B*e *A* *Excel A*ddict “
“*Excel A*ddict”
Regards,
Dhananjay
On Tue, Mar 1, 20
Hi Saurabh,
Attached is the solution.
Regards,
Dhananjay Pinjan
(Contact No. 08866078062)
On Wed, Sep 22, 2010 at 8:19 PM, Saurabh Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Dear All,
>
>
>
> I have attached a sheet wherein I want the result by a formula th
link is not working
On Sat, May 8, 2010 at 4:21 PM, João Matoso wrote:
> http://www.tudosobrexcel.com/ o link correto
>
>
> 2010/5/8 Harpreet Singh Gujral
>
> Jaao Matoso,
>>
>> The link doesnt work
>>
>> Harry
>>
>> On May 7, 2:35 am, João Matoso wrote:
>> > www.tudosobrexcell.com
>> >
>>
'
'
'
'
'
'
'
'
'
'
'
SORRY ! I'm just kidding@2
On 2/14/10, Harmeet Singh wrote:
>
> *Thank you guyz.*
> *
> *
> *I am **overwhelmed with your response*
> *
> *
>
> Th
Thank you very much!!1
On 2/11/10, 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.*
> *
> *
Please send me the Excel File
Thanks & Regards,
Dhananjay
On Thu, Dec 31, 2009 at 12:41 AM, Vishal Parihar wrote:
> Hi Friends
>
> The below code are to use:-
>
> Application.Speech.Speak ("vishal parihar")
>
> Regards
> Vishal Parihar
>
> I hope you will like it.
>
> --
>
> ---
Hi all Excel Users,
Wishing you a Very Happy & Prosperous New Year.
Regards,
Dhananjay Pinjan
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter
Hi Dilip,
Please find enclosed herewith the Query file which is revised on your
solution to vijay Kumar
On 9/1/09, Dilip Pandey wrote:
>
> Hi Vidyut,
>
> Attached workbook has the solution for your query. Thanks.
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
Pl. find attached excel sheet for query.
Thanks & Regards,
Dhananjay
On 8/28/09, Dilip Pandey wrote:
>
> Dear Suresh,
>
> Attachment has been solved and re-attached. Thanks.
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@ya
ug 2009 17:21:35 +0530
>> Subject: $$Excel-Macros$$ Fwd: about to remove "#VALUE!" error
>> From: dppin...@gmail.com
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear All,
>>
>> Please ignore the previous
Dear All,
Please ignore the previous mail sent by me because i forgot to attach the
excel file.
Can anyone provide me the solution as per the requirement in the
attachment.
Thanks in advance & Regards,
Dhananjay Pinjan
(Mob. No. 992225
Dear All,
Can anyone provide me the solution as per the requirement in the
attachment.
Thanks in advance & Regards,
Dhananjay Pinjan
(Mob. No. 992225
Wishing you all a very happy Independence Day.
Thanks & Regards,
Dhananjay
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Fre
> format :
> [>=1000]##\,##\,##\,###.00;[>=10]##\,##\,###.00;#,##0.00
>
> Please let me know if it helps.
>
> Regards,
> Andy
>
> On Sun, Aug 9, 2009 at 3:58 AM, Dhananjay Pinjan wrote:
>
>> Dear All,
>>
>> Can anyone prov
Dear All,
Can anyone provide me the formulas as per the requirement in the
attachment.
Thanks in advance & Regards,
Dhananjay Pinjan
(Mob. No. 992225
Is there anything to crack password for msword or msexcel?
Pl. assist me.
Thanks & Regards,
Dhananjay
On 7/28/09, Harmeet Singh wrote:
>
> use this code
>
>
>
> Sub PasswordBreaker()
>
>
> Dim i As Integer, j As Integer, k As Integer
> Dim l As Integer, m As Integer, n As Integer
> Dim
Hi Shafique,
Where is the program?
On 7/28/09, shafiq online wrote:
>
>
> Attached is password removal tool. You can you it by add-in. These is for
> removing password from Sheet.
>
> Regads,
>
>
>
> --
> With Windows Live, you can organize, edit, and share your
> p
Thanks for this great program.
On 7/28/09, Harmeet Singh wrote:
>
> use this code
>
>
>
> Sub PasswordBreaker()
>
>
> Dim i As Integer, j As Integer, k As Integer
> Dim l As Integer, m As Integer, n As Integer
> Dim i1 As Integer, i2 As Integer, i3 As Integer
> Dim i4 As Integer, i5 As In
Thanks for reply.
On 7/28/09, Chris Spicer wrote:
>
>
> Hi Dhananjay,
>
> Download the add-in from the files section of this site or from
> http://technicana.com/vbaSection/TechnicanaAddin.html.
>
> Then open Excel and go to the menu bar and click on Tools->Add-ins.
> The Add-ins dialog box will
;add-in". So please ... I am waiting for your reply
Thanks & Regards,
Dhananjay Pinjan
(Mob. No.9922255533)
On 7/28/09, Chris Spicer wrote:
>
>
> If like me you find resizing array formulas awkward, you will find the
> following code to a time-saver. It will automatically
energy-Save Earth
>
>
>
>
> On Mon, Jul 27, 2009 at 7:25 PM, Dhananjay Pinjan wrote:
>
>> Hello Mr. Vivek Agrawal,
>>
>> I cannot able to view the below addressed file.
>> "
>>
>> http://groups.google.com/group/excel-macros/web/Microsoft_Offic
Hello Mr. Vivek Agrawal,
I cannot able to view the below addressed file.
"
http://groups.google.com/group/excel-macros/web/Microsoft_Office_2007_eBooks_Collection_%5BPDF_CHM_-_ENG%5D.4573644.TPB.torrent
"
Pl. Can you assist me about how to view it?
Thanks & Regards,
Dhananjay
On 7/23/09, vivek
Hello Mr. Anil Panchal,
This is the better solution on your query.
Thanks & Regards,
Dhananjay
On 7/24/09, anil panchal wrote:
>
>
>
> Hi All Frnd & Sr.
>
> Please find attached file. there is a Full Name Like Anil Kumar Panchal I
> want saprate anil kumar panchal in 3 Columns with the help of
Hello Roman,
Please provide sample file with the data & the desired output.
Thanks.
Dhananjay
On 7/24/09, Roman wrote:
>
>
> I need a formula that picks up what filter condition is used on a
> column of values.
>
> For example:
>
>
>
> Column A Colu
Hello,
This is the solution (attachment files) as per the query I understood.
(Pl. append data in 'Main.xlsx' & the same will reflect in 'dupli.xlsx'.)
If not happened please mail me back. I will show you the another way.
Thanks & regards,
Dhananjay Pinjan
(Mob.
gt;
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Dhananjay Pinjan
> *Sent:* jeudi 23 juillet 2009 13:42
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: please help
>
>
>
> Hello Daniel,
>
Hi Gyanesh,
The attached file contained the answer which is desired by you.
Thanks & Regards,
Dhananjay
(Mob. No. 9922255533)
On 7/21/09, gyanesh jain wrote:
>
>
> Hi All,
>
> check the attachment.
>
>
> If you change the country, in the chart "chart Title" should be change
> automatically.
Hi Aamir,
Can you give me the example sheet?
Thanks & Regards,
Dhananjay
(Mob. No. 9922255533)
On 7/21/09, Aamir Shahzad wrote:
>
> Dear all,
>
> Can anyone tell me please "How to make unique key" for pick required data
> from one sheet to another. If there is no similarity. e.g. for use of
Hi Hitesh,
I also keen to teach VB (in excel). If you get appropriate sites or
information, don't forget to remind / send me.
Thanks in Advance.
Regards,
Dhananjay
On 7/21/09, Hitesh Taunk wrote:
>
> Hello Everyone,
> I have newly joined this group about a day before.
Hi Friends,
Hi Ruchi,
Hope following formula helped to you.
=VLOOKUP(B2,F:G,2,TRUE)
I also append that formula in your Excel File. So, please opened attached
(by me) file for result.
Thanks & Regards,
Dhananjay Pinjan
(Mob. No. 9922255533)
On 7/22/09, Ruchi Saxena wrote:
>
&
52 matches
Mail list logo
