$$Excel-Macros$$ Re: Compare two text columns by last name
Hi Nitin, I found an error when I applied it on my database where there is no space between last name and first name. I am attaching the sheet to make u understand. Please let me know if there is any solution. Satya On Sunday, 24 February 2013 19:47:18 UTC+5:30, satyas wrote: > > Thanks Nitin. > > On Saturday, February 23, 2013 4:40:33 PM UTC+5:30, Nitin Gupta wrote: >> >> Pls see the solution in attached sheet >> >> Nitin >> >> On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote: >>> >>> >>> Hi Experts, >>> >>> Just need to compare two columns by last name . Will appreciate if you >>> can help me for this. >>> >>> Satya. >>> >> -- 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, 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 may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Satya.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ hyperlink issue
isn't my solution enough?
On Sat, Mar 2, 2013 at 11:22 AM, xlstime wrote:
> try this
>
> =HYPERLINK("#"&ADDRESS(7,5,1,1,"sheet2"),"lik")
>
>
> On Fri, Mar 1, 2013 at 10:36 AM, amar takale wrote:
>
>> Dear All Friends
>> Thanks a lot everybody who give time for my solution.
>> Regards
>> Amar
>>
>>
>> On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote:
>>
>>> I don't understand Mr.Bé Trần Văn
>>>
>>>
>>> On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn >> > wrote:
>>>
Learn test.
2013/2/28 The Viper
> can't get throuh formula?
>
> pfa
>
>
>
> On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey
> wrote:
>
>> solved .
>>
>>
>> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
>>
>>> Dear All,
>>>
>>> I have facing some hyperlink issue in sheet,I attached sheet in
>>> detailed information,Pls tell me It is possible?
>>>
>>> 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 page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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 may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>> and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at
>>> http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>> --
>> 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, 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 may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>> .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> 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, 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 may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiv
Re: $$Excel-Macros$$ hyperlink issue
try this
=HYPERLINK("#"&ADDRESS(7,5,1,1,"sheet2"),"lik")
On Fri, Mar 1, 2013 at 10:36 AM, amar takale wrote:
> Dear All Friends
> Thanks a lot everybody who give time for my solution.
> Regards
> Amar
>
>
> On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote:
>
>> I don't understand Mr.Bé Trần Văn
>>
>>
>> On Thu, Feb 28, 2013 at 10:18 PM, Bé Trần Văn
>> wrote:
>>
>>> Learn test.
>>>
>>>
>>> 2013/2/28 The Viper
>>>
can't get throuh formula?
pfa
On Thu, Feb 28, 2013 at 5:30 PM, Divaker Pandey wrote:
> solved .
>
>
> On Thu, Feb 28, 2013 at 3:41 PM, amar takale wrote:
>
>> Dear All,
>>
>> I have facing some hyperlink issue in sheet,I attached sheet in
>> detailed information,Pls tell me It is possible?
>>
>> 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 page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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 may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en
>> .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
> --
> 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, 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 may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners
> and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google
> Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
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, 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 may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners
and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?h
RE: $$Excel-Macros$$ Re: Assignment
Dear All,
Macros is like sea and I'm sitting in seashore just watching code like a water
waves
Not able to understand but still trying to learn some thing from it.
Can some one please provide spreadsheet on the below so that I can see that and
practices
Thanks
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ali Abbas
Sent: 01 March 2013 12:36
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Assignment
Good job
On Mar 1, 2013 6:25 AM, "Prince"
mailto:prince141...@gmail.com>> wrote:
Hi,
Check this May be if it can help you.
Function GetNumberS(strData As String) As String
Dim objRge As Object, REMatches As Object
Set objRge = CreateObject("vbscript.regexp")
With objRge
'.Pattern = "[0-9][0-9][0-9][0-9]"
.Pattern = "(\d+)"
End With
Set REMatches = objRge.Execute(strData)
GetNumberS = REMatches(0)
End Function
Regards
Prince
On Saturday, February 23, 2013 11:44:01 AM UTC+5:30, Harkesh Kumar wrote:
Please solve this Problem
Please Seperate Special character and number
num
Ans
@1234
#1239
$1244
%1249
^1254
&1259
*1264
@1234
#1239
$1244
%1249
^1254
&1259
*1264
@1234
#1239
$1244
%1249
^1254
&1259
*1264
--
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, 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 may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to
excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
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, 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 may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL
For Aon's standard conditions associated with this e-mail please visit
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp
Aon UK Limited
Registered Office: 8 Devonshire Square, London EC2M 4PL
Registered in London No. 210725 . VAT Registration No. 480 8401 48
Aon UK Limited is authorised and regulated by the Financial Services Authority
in respect of insurance mediation activities only.
--
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, 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 may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs
$$Excel-Macros$$ Type mismatch error found in Sumproduct
Hello team, Please find the attached and suggest as "I am having the TYPE MISMATCH error at sumproduct line... Thanks Pankaj Sangotra -- 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, 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 may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. sumpro12(1).xlsm Description: Binary data
$$Excel-Macros$$ Extract Data from single cell
-- 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, 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 may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Example.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Assignment
HI,
Try it,
Function ValidateString(strInput As String) As String
Dim strInvalidChars As String
Dim i As Long
strInvalidChars = "*,?~@#$%^&()_+{}[]:;<>" & "'" &
For i = 1 To Len(strInvalidChars)
strInput = Replace$(strInput, Mid$(strInvalidChars, i, 1), "")
Next
ValidateString = strInput
End Function
On Fri, Mar 1, 2013 at 10:25 AM, Prince wrote:
> Hi,
>
> Check this May be if it can help you.
>
>
> Function GetNumberS(strData As String) As String
>
> Dim objRge As Object, REMatches As Object
>
> Set objRge = CreateObject("vbscript.regexp")
> With objRge
> '.Pattern = "[0-9][0-9][0-9][0-9]"
> .Pattern = "(\d+)"
> End With
> Set REMatches = objRge.Execute(strData)
> GetNumberS = REMatches(0)
>
> End Function
>
>
> Regards
> Prince
>
> On Saturday, February 23, 2013 11:44:01 AM UTC+5:30, Harkesh Kumar wrote:
>>
>>
>>
>>
>> Please solve this Problem
>>
>>
>>
>> Please Seperate Special character and number
>>
>> num
>>
>> Ans
>>
>> @1234
>>
>>
>>
>> #1239
>>
>>
>>
>> $1244
>>
>>
>>
>> %1249
>>
>>
>>
>> ^1254
>>
>>
>>
>> &1259
>>
>>
>>
>> *1264
>>
>>
>>
>> @1234
>>
>>
>>
>> #1239
>>
>>
>>
>> $1244
>>
>>
>>
>> %1249
>>
>>
>>
>> ^1254
>>
>>
>>
>> &1259
>>
>>
>>
>> *1264
>>
>>
>>
>> @1234
>>
>>
>>
>> #1239
>>
>>
>>
>> $1244
>>
>>
>>
>> %1249
>>
>>
>>
>> ^1254
>>
>>
>>
>> &1259
>>
>>
>>
>> *1264
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
> 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, 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 may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
*
*
* MARIES*
Excel Inspiration
