Dear Experts,
Please find attached file and as per written wuery in work sheet please
solve.
Thanks in advance
--
Rajeev Kumar
--
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 @
Dear Group,
Please responce my query.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Thu, Jun 13, 2013 at 12:05 PM, Prabhakar Thakur
prabhakarthak...@gmail.com wrote:
Dear Group,
I need complete information about MOS excel certificate cource how does
that if possible shere help
Dear Rajeev
Please find attached message, i've writen dirty UDF for concatenate a
word in range on that file
please note that my UDF writen without filtering duplicate value on
defined range
Thanks,
[dp]
On 15/06/2013 13:27, Rajeev Kumar wrote:
Dear Experts,
Please find attached file and
Hi all,
I have a query , I have made a formula for this but very long so I would like
some small formula to get email id only, pls help thanks in advance
abcd
billga...@microsoft.com xyz
12 xyz john_hay...@microsoft.com 34a bcd
billga...@yahoo.com 1234 abcd
abcd 1234
Dear All Experts
Here I required sum formula but as per time means sum near cell value after
every 5 minute.I attached sheet with all detailed Pls check it.
Regards
Amar
--
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
Function ExtractEmail(Sentence As String) As String
Dim Word
For Each Word In Split(Sentence, )
If InStr(1, Word, @) 0 Then ExtractEmail = Word
Next
End Function
Pada 15/06/2013 15:03, ravinder negi menulis:
Hi all,
I have a query , I have made a formula for this but
Try to use Average ifs if you are using Excel 2007 you shall get it.
Thanks,
Ahmed Bawazir
On Sat, Jun 15, 2013 at 1:34 AM, Dheeraj Bankoti dbank...@gmail.com wrote:
Hi Experts,
PFA a sample file, in which I need average quantity.
Appreciate any inputs.
Regards
--
Are you =EXP(E:RT)
I want this in excel formula..this one also very nice can you explain how split
is working.
--- On Sat, 6/15/13, De Premor d...@premor.net wrote:
From: De Premor d...@premor.net
Subject: Re: $$Excel-Macros$$ Cell Merge - Reg
To: excel-macros@googlegroups.com
Date: Saturday, June 15, 2013, 2:13
Function ExtractEmail(Sentence As String) As String
Dim Word
For Each Word In Split(Sentence, )
If InStr(1, Word, @) 0 Then ExtractEmail = Word
Next
End Function
For example: in case we have a sentence like *please send mail to
some...@example.com or futher info*
the split
now i Understood, nice one and thanks...by the way I got formula also, put
value in cell a1 and paste formula in b2
=TRIM(MID(SUBSTITUTE( A1, ,REPT( ,125)),SEARCH(@,SUBSTITUTE( A1,
,REPT( ,125)))-100,125))
--- On Sat, 6/15/13, De Premor d...@premor.net wrote:
From: De Premor d...@premor.net
in vba function split function is working is magic of instr:
Instr checks each word in sentence, if it contains @ then it is picked up
thrown as result..
its using right logic with right function to reach destination in fastest
way..
HTH
On Sat, Jun 15, 2013 at 3:21 PM, ravinder negi
Respected Prabhakar,
You can find information from the following links,
http://www.microsoft.com/learning/en/us/mos-certification.aspx#fbid=x8BGjYz2g2o
http://www.onlc.com/excel-certification-mos.html
http://www.excelprodigy.in/microsoft-certification.html#.UbxVsT4isRA
PFA
http://www.xl-central.com/list-files-dir.html
http://www.excelvbamacros.com/p/index_1.html
Thanks
On Sat, Jun 15, 2013 at 5:39 PM, Vijayendra Rao vijayendrar...@gmail.comwrote:
Dear All,
Is there any macros to create list names with subfolder and propertis from
any folder. Currently
hi all
can anybody suggest a vb code or a macro to a excel file the moment it is
opened it can check on the usage of the file or it can stop from further
use until it is being given permission by the creator of the file
basically it should not be copied and if copied from one computer to the
I want to unsubscribe it.
From: Mithlesh Sharma mtshar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, 15 June 2013 8:18 PM
Subject: Re: $$Excel-Macros$$ List File Names from Folder in Excel
PFA excel file.
On Sat, Jun 15, 2013 at 5:39
For do that, you need to know the unique value on each computer to
determine that the file was used on another computer.
Something that will unique on every computer is Hardisk SN
Private Sub Workbook_Open()
Dim MySN, CurrentSN As String
MySN = 1409978829 'Your Current Hardisk Serial
Hi,
You may refer:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=475
http://www.vbaexpress.com/kb/getarticle.php?kb_id=540
File with example is there for better understanding..
Best Luck
On Sun, Jun 16, 2013 at 12:03 AM, sunil lobo christl...@gmail.com wrote:
hi all
can anybody
Hi Deepak,
Please elaborate your requirement little more.
.
Enjoy
Team XLS
On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti dbank...@gmail.comwrote:
Dear Ahmed,
Thanks for your reply. avergeifs does not meet as per my requirement. It
is working for complete
Thanks
it is working.
Regards
On Sun, Jun 16, 2013 at 8:45 AM, xlstime xlst...@gmail.com wrote:
Hi Dheeraj,
Please find attach solution
.
Enjoy
Team XLS
On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti dbank...@gmail.comwrote:
Dear Ahmed,
Thanks for your
good:thanks its of great help
On Sun, Jun 16, 2013 at 7:37 AM, De Premor d...@premor.net wrote:
For do that, you need to know the unique value on each computer to
determine that the file was used on another computer.
Something that will unique on every computer is Hardisk SN
Private Sub
20 matches
Mail list logo
