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
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
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, Dhananjay Pinjan wrote:
Hi Friends,
I need
Hertiest Congrats Noorain Ansari. Do continue. Best Luck
On 9/12/12, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote:
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon da...@grugeon.com.au
wrote:
Loveufe2001
I suggest you post
File for revised query). Pl. help.
Regards,
Dhananjay
On 9/10/12, Dhananjay Pinjan dppin...@gmail.com wrote:
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon da...@grugeon.com.au
wrote:
See attached
On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon da...@grugeon.com.au wrote:
See attached
On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification
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)
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,
Thanks Ashish.
-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
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 dppin
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
figure
/07/05/masterchef-style-clock-in-excel/
On Sat, Aug 4, 2012 at 11:23 PM, Dhananjay Pinjan
dppin...@gmail.comwrote:
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
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
Sorry. I would like to thanks to Ayush. Ashish Kaul as well.
On 8/4/12, Dhananjay Pinjan dppin...@gmail.com 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 people
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
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
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
/sumifs-function-HA010047504.aspx
On Sat, Apr 9, 2011 at 7:19 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
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 koul.ash
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 koul.ash...@gmail.com wrote:
see if it helps
On Fri, Apr 8, 2011 at 7:04 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Please reply.
--
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 bhanu...@gmail.com wrote:
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell.
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 how quickly
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
Instead of SIMPLEEXCEL??
Simplicity of Excel is suited more .
On Tue, Mar 1, 2011 at 11:23 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
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
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 that I get
the number starting
link is not working
On Sat, May 8, 2010 at 4:21 PM, João Matoso jcmat...@gmail.com wrote:
http://www.tudosobrexcel.com/ o link correto
2010/5/8 Harpreet Singh Gujral harpreetguj...@gmail.com
Jaao Matoso,
The link doesnt work
Harry
On May 7, 2:35 am, João Matoso jcmat...@gmail.com
Thank you very much!!1
On 2/11/10, Harmeet Singh harmeet.hew...@gmail.com 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
**overwhelmed with your response*
*
*
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sat, Feb 13, 2010 at 10:00 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Thank you very much!!1
On 2/11/10, Harmeet Singh harmeet.hew...@gmail.com
Please send me the Excel File
Thanks Regards,
Dhananjay
On Thu, Dec 31, 2009 at 12:41 AM, Vishal Parihar vish.pari...@gmail.comwrote:
Hi Friends
The below code are to use:-
Application.Speech.Speak (vishal parihar)
Regards
Vishal Parihar
I hope you will like it.
--
Hi Dilip,
Please find enclosed herewith the Query file which is revised on your
solution to vijay Kumar vijaykumar...@gmail.com
On 9/1/09, Dilip Pandey dilipan...@gmail.com wrote:
Hi Vidyut,
Attached workbook has the solution for your query. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B
Pl. find attached excel sheet for query.
Thanks Regards,
Dhananjay
On 8/28/09, Dilip Pandey dilipan...@gmail.com 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
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. 9922255533)
--
Web IM has arrived! Use Windows Live Messenger from your Hotmail
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),
Dear All,
Can anyone provide me the solution as per the requirement in the
attachment.
Thanks in advance Regards,
Dhananjay Pinjan
(Mob. No. 9922255533
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. 9922255533
]##\,##\,##\,###.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 dppin...@gmail.comwrote:
Dear All,
Can anyone provide me the formulas as per the requirement in the
attachment.
Thanks in advance Regards,
Dhananjay
Dear All,
Can anyone provide me the formulas as per the requirement in the
attachment.
Thanks in advance Regards,
Dhananjay Pinjan
(Mob. No. 9922255533
Is there anything to crack password for msword or msexcel?
Pl. assist me.
Thanks Regards,
Dhananjay
On 7/28/09, Harmeet Singh harmeet.hew...@gmail.com 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
Thanks for reply.
On 7/28/09, Chris Spicer chris.spi...@technicana.com 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
Thanks for this great program.
On 7/28/09, Harmeet Singh harmeet.hew...@gmail.com 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
Hi Shafique,
Where is the program?
On 7/28/09, shafiq online shafiq_onl...@hotmail.com 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
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
On Mon, Jul 27, 2009 at 7:25 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
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
Hello Roman,
Please provide sample file with the data the desired output.
Thanks.
Dhananjay
On 7/24/09, Roman romangurov...@gmail.com wrote:
I need a formula that picks up what filter condition is used on a
column of values.
For example:
Column A
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. No. 9922255533)
On 7/24/09
Hello Mr. Anil Panchal,
This is the better solution on your query.
Thanks Regards,
Dhananjay
On 7/24/09, anil panchal anil.kan...@gmail.com 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
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 hitesh.ta...@gmail.com wrote:
Hello Everyone,
I have newly joined this group
45 matches
Mail list logo
