Re: $$Excel-Macros$$ Re: Help required for Match DATA
in this attachment did you enabled this library in refrences go to vba editior enalble these library and then go to sheet1 and click the button send mails . microsoft outlook 14.0 object library ole auotmation microsoft excel 14.0 object library visual basic for applications microsoft forms 2.0 object library On Tuesday, 17 March 2015 11:49:13 UTC+5:30, Ashu k wrote: > > Dear Mandeep Sir, > > Now, Getting error. > > When i try to run code - Getting error (M-1) imageis attached > and > If i click on debug button - Getting Problem (M-2) image is attached > > I think think the macro is provided by you is recorded. that's why > it's not functing well. > > Please help. > > PFA, the error attachments. > > Regards > Ashu Kenith > -- 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. For more options, visit https://groups.google.com/d/optout. Sendmails_tomerchants.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hello, Can anyone help me to modify & save DBF files in Excel 2007. Pravin. On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I tried working on it but could not do the same. > > Could you please explain me how to do it or is there any other solution > for this. Please do share. > > Thank you > > Regards > Pravin Gunjal > > > On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: >> >> That usually is a problem with "References". >> >> try these steps: >> >> Stop execution of macro >> in VB Editor, select Tools-> References... >> >> you'll find several libraries selected. >> But you might see one that says "Missing" (or something like that). >> >> The problem is that once the compiler hits this missing library, it stops >> looking at the others. >> >> The string manipulation functions like Left() and Right() are in one of >> the object libraries and are not being found. >> >> You won't need all of the ones I have but the references I have selected >> in Excel 2010 are: >> >> Visual Basic for Applications >> Microsoft Excel 14.0 Object Library >> OLE Automation >> Microsoft Office 14.0 Object Library >> Microsoft Word 14.0 Object Library >> Microsoft Forms 2.0 Object LIbrary >> >> >> >> *Paul* >> - >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> - >> >>*From:* Pravin Gunjal >> *To:* Excel Macros >> *Sent:* Tuesday, February 3, 2015 8:33 AM >> *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 >> >> Hi >> >> I have downloaded the DBF save add-in but while saving got the attached >> error in VB. >> Could anyone please check and update me on this issue. >> >> Thank you >> Pravin Gunjal >> -- >> 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...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column
Hi, I have an excel format 2007 for daily data entry, as attached. I used to select Party Names through drop down list in column F and need to type the invoice numbers in cloumn E based on the letter in column D. Our invoice numbers start with C, D & F letters and it comes serially for different parties. So for next party next serial number would come...as per the letter mentioned in column D If I type any one these letters the next invoice number should come automatically in column E. For example: In cell F8 there is a party viz. The Ichalkaranji Sales Corp - Ichalkaranji for which I i would like to give next C serial then I would type C in cell D8 and then then next number 1327 must come in E8 automatically. Hope you understand the requirement. Please do the need. Thank you, Pravin Gunjal. -- 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. For more options, visit https://groups.google.com/d/optout. Curatio Invoice Register 2014-15.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
$$Excel-Macros$$ Re: Help required for Match DATA
remove option explicity statement which is in first line of your code, as this code working perfecctly on my pc , Please send me the line number of error. On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: > > Dear Seniors, > > I have data in sheet 1 > > Name Class Roll NO. Exam Date > > > and, > > I have data in Sheet 2 > > Name Class Roll No. Exam Date > > > But some Names are not in Name Column and Some Class are not in Class > Column, I want to get all Roll No. in Sheet 2 from Sheet 1. > > Example data attached. Please help me. > > Regards > Ashu Kenith > -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: vba recorded macro not working
Dear Mike,
Thank u so much for your Appreciation. It's a pleasure to help anyone
because it expands my knowledge about VBA , The thing is I am a beginner
and wish i will reach at a position where can i help everyone in anyway it
can be and want to reach at a higher Package in a firm.
wish you luck.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Monday, 16 March 2015 23:46:40 UTC+5:30, Mike B wrote:
>
> Hi Mandeep,
>
>
>
> Thank you, thank you again for your excellent help. Is there anything I
> can do for you to show my appreciation? I was really stuck and you bailed
> me out, I tried severl different ways and could not get it to work. Thank
> you, Again.
>
>
>
> The Best,
>
>
>
> Mike Barrett
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mandeep baluja
> *Sent:* Monday, March 16, 2015 4:48 AM
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: vba recorded macro not working
>
>
>
> Run this code in your data
>
> Sub Test()
> With Application
> .ScreenUpdating = False
> .DisplayAlerts = False
> End With
>
> Dim lr As Long
> lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
>
> Set Rng = Range("C1:C" & lr)
> Debug.Print Rng.Address
> For Each Cell In Rng
>
> If Left(Cell.Value, 5) = "Estab" Then
> estab = Cell
> ElseIf Left(Cell.Value, 2) <> "CG" Then
> temp = Cell
> Debug.Print temp
> Else
> Debug.Print Len(estab)
> Cell.Offset(0, -2).Value = Trim(Right(estab, Len(estab) - 14))
> Cell.Offset(0, -1).Value = Trim(Right(temp, Len(temp) - 31))
> End If
>
> Next
>
> ActiveSheet.Range("C3:C" & lr).AutoFilter field:=1, Criteria1:="<>*CG*"
> ActiveSheet.Range("C2:C" &
> lr).SpecialCells(xlCellTypeVisible).EntireRow.Delete
>
> End Sub
>
> --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/BxB4QfFrdl4/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
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.
For more options, visit https://groups.google.com/d/optout.
RE: $$Excel-Macros$$ Re: vba recorded macro not working
Hi Mandeep,
Thank you, thank you again for your excellent help. Is there anything I can do
for you to show my appreciation? I was really stuck and you bailed me out, I
tried severl different ways and could not get it to work. Thank you, Again.
The Best,
Mike Barrett
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep baluja
Sent: Monday, March 16, 2015 4:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: vba recorded macro not working
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
Set Rng = Range("C1:C" & lr)
Debug.Print Rng.Address
For Each Cell In Rng
If Left(Cell.Value, 5) = "Estab" Then
estab = Cell
ElseIf Left(Cell.Value, 2) <> "CG" Then
temp = Cell
Debug.Print temp
Else
Debug.Print Len(estab)
Cell.Offset(0, -2).Value = Trim(Right(estab, Len(estab) - 14))
Cell.Offset(0, -1).Value = Trim(Right(temp, Len(temp) - 31))
End If
Next
ActiveSheet.Range("C3:C" & lr).AutoFilter field:=1, Criteria1:="<>*CG*"
ActiveSheet.Range("C2:C" & lr).SpecialCells(xlCellTypeVisible).EntireRow.Delete
End Sub
--
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 a topic in the Google
Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/excel-macros/BxB4QfFrdl4/unsubscribe.
To unsubscribe from this group and all its topics, 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.
For more options, visit https://groups.google.com/d/optout.
--
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.
For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Help required for Match DATA
PFA !!! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: > > Dear Seniors, > > I have data in sheet 1 > > Name Class Roll NO. Exam Date > > > and, > > I have data in Sheet 2 > > Name Class Roll No. Exam Date > > > But some Names are not in Name Column and Some Class are not in Class > Column, I want to get all Roll No. in Sheet 2 from Sheet 1. > > Example data attached. Please help me. > > Regards > Ashu Kenith > -- 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. For more options, visit https://groups.google.com/d/optout. Sendmails_tomerchants.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Hiring-Qlikview Developer @Jersey City, NJ [Please send resumes to r...@technotalent.com]
Hi, Hope you are doing great... Please let me know your interest along with your updated resume (If you are not available please refer this Position) [Please send resumes to r...@technotalent.com] *Position* *Role : **Qlikview Developer* *Location : Jersey City, NJ* *Duration : 6+ Months* *Type: Corp to Corp* *GC and Citizens can apply for this position* *Banking experience Must* *Please reply me with below details along with your resume..* Candidate Full Name (First Last): Core Expertise: Total Years of Exp: Current Location (City, State): Relocation Preference: Availability: SSN (last 4 Digits): Candidate Contact #: Candidate Email ID : Candidate Skype ID : Visa Status (H1B / EAD / GC / Citz /...): If H1B / EAD then Validity (Mon, Year) : Candidate Date of Birth (Month, Year) : Education Course Name: University Name: City, State, Country: Year Completed: Project Reference 1: Project References 2: Regards, *Rene* TechnoTalent Software Solutions,707 Alexander Rd.208. Princeton, New Jersey 08540. *Email: **r...@technotalent.com* *D: 732-444-3663* URL: www.technotalent.com Note: This email is not intended to be a solicitation. It is targeted to recruiting and consulting professionals. If you have received this in error, please accept our apologies and to be removed from our mailing list reply with "UNSUBSCRIBE" in the subject heading and your email address in the body. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Formula based on some criteria
Hi Check col D for solution.. Cheers!! On Sun, Mar 15, 2015 at 10:23 AM, rameshwari shyam < rameshwarish...@gmail.com> wrote: > Dear Team, > > Can any one help on this. > > Thanks, > Rameshwari > -- Forwarded message -- > From: rameshwari shyam > Date: Fri, Mar 13, 2015 at 10:08 AM > Subject: Re: $$Excel-Macros$$ Formula based on some criteria > To: excel-macros@googlegroups.com > > > Dear gaurav, > > required some more modification. if you can check AED in question sheet is > 15 then in Master sheet, search for 15 SAR. Below than that there is a AED > 15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25, > > Base currency will be AED in question sheet and in master sheet base > currency will be SAR > > > In simple words, need to do vlook up that is find AED value in master > sheet from cell reference "B2:EC8" once the currency get change it need to > change the display value. > > Every 13 row it need to change the reference. > > > Thanks, > Rameshwari > > > > > On Thu, Mar 12, 2015 at 4:54 PM, Gaurav Devrani > wrote: > >> Hi Rameshwari , >> >> >> Please check the file. Let me know if it does not work for you. >> >> Regards >> Gaurav Devrani >> >> On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari >> wrote: >> >>> Hello team, >>> >>> I stuck with one formula, please help me on this. Formula based on some >>> criteria. >>> >>> >>> >>> Sheet “Question” having currency name with the prices, based on currency >>> name & prices need to update the value in answer filed. >>> >>> >>> >>> Master sheet will be a reference for the currency. Every 13 row need to >>> change the reference. >>> >>> What I am looking ;- if AED is 15 then need to search in master file SAR >>> 15 update the value of AED based on SAR, for KWD update the value of KWD >>> based on SAR, it means in question sheet AED will be base and in Master >>> sheet SAR will be the base. >>> >>> JOD, LBP, EGP, & IQD will be the same as mention. Please urgent help >>> required. >>> >>> Regards, >>> >>> Rameshwari >>> >>> -- >>> 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. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> >> *Thanks & Regards* >> *Gaurav Devrani* >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > 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 >
Re: $$Excel-Macros$$ Re: Help required for Match DATA
Dear Mandeep Sir, Query is still pending from last 2 months. Last time you said that, you will send the answer shortly. Revert awaited from your side. Please help. Regards Ashu kenith. On 1/15/15, Ashu k wrote: Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. Please help sir. Regards Ashu Kenith On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote: Dear Mandeep Sir, Please help. Regards Ashu Kenith. On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote: Dear Mandeep Sir, Thanks a lot for your help. one more help required. If the Merchant ID is same then paste the data (Order No., Item ID, Item Name, RTO Date) on mail body which was belongs to Same Merchant ID. Example : - Merchant ID is 12345 and 10 orders is placed by this merchant, then paste the all details on mail body which is belongs to the same merchant in the same format which was provided by you in previous mail. kindly help. Regards Ashu Kenith. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Help with combination formula
Dear Mandeep Sir, I am big fan of yours..! Regards Ashu Kenith -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Help in Vlook-up or any other formula
Cheers!! On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao wrote: > Dear Vaibhav, > > Thank you very much for your quick support. This is very helpful. > > Regards, > Vijayendra > > 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi : > >> PFA with #N/A handler... >> >> On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao > > wrote: >> >>> Dear Experts, >>> >>> Can you please help me to put vlookup or any other formula for the the >>> second row. Attached is the my file and request you to help on the same. >>> >>> Regards, >>> Vijayendra >>> 94491 67631 >>> >>> -- >>> 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. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > ಧನ್ಯವಾದಗಳು, > ವಿಜಯೇಂದ್ರ, > ೯೪೪೯೧ ೬೭೬೩೧ > > Regards, > Vijayendra > 94491 67631 > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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 thr
Re: $$Excel-Macros$$ Re: Help with combination formula
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i have started learning Excel techniques and admire your logics of Macros. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Monday, 16 March 2015 17:50:49 UTC+5:30, Vabz wrote: > > Hi Mandeep, > > Logic used in macro is rilli cool... > > Cheers!! > > On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja > wrote: > >> Check the *result sheet* in the attachment . for single single row this >> formula will work with helper column. >> >> >> >> >> >> >> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >> >>> Hi, >>> Please I need help with the attached file. I want a formula that >>> calculates how many times (10, 13, 17) combination has appeared within the >>> range D5:I32 >>> >>> >>> >>> >>> >>> 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...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> 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...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> Attachments area >>> Preview attachment Paks.xlsx >>> Paks.xlsx >>> >> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Re: $$Excel-Macros$$ Re: Help with combination formula
Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > >> Hi, >> Please I need help with the attached file. I want a formula that >> calculates how many times (10, 13, 17) combination has appeared within the >> range D5:I32 >> >> >> >> >> >> 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...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> -- >> 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...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> Attachments area >> Preview attachment Paks.xlsx >> Paks.xlsx >> > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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, goo
Re: $$Excel-Macros$$ Re: Help with combination formula
Hey Will Check this attachment..in any of given columns it will check occurrence of 10 , 13 & 17 in any order... Hope you like it,.,. Cheers!! On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote: > Gosh l like this method thanks a lot. This is the best l have seen most > appreciated > > On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja > wrote: > >> Check the *result sheet* in the attachment . for single single row this >> formula will work with helper column. >> >> >> >> >> >> >> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >> >>> Hi, >>> Please I need help with the attached file. I want a formula that >>> calculates how many times (10, 13, 17) combination has appeared within the >>> range D5:I32 >>> >>> >>> >>> >>> >>> 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...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> 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...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> Attachments area >>> Preview attachment Paks.xlsx >>> Paks.xlsx >>> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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 thre
Re: $$Excel-Macros$$ Re: Help with combination formula
Gosh l like this method thanks a lot. This is the best l have seen most appreciated On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > >> Hi, >> Please I need help with the attached file. I want a formula that >> calculates how many times (10, 13, 17) combination has appeared within the >> range D5:I32 >> >> >> >> >> >> 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...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> -- >> 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...@googlegroups.com. >> To post to this group, send email to excel-...@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> Attachments area >> Preview attachment Paks.xlsx >> Paks.xlsx >> > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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 re
Re: $$Excel-Macros$$ Extract Pages From Website
Thank You. On Sunday, 15 March 2015 22:35:47 UTC-4, Martin Wheeler wrote: > > Nothing easily explained. I have done it years ago but would not remember > how to. Any I have no experience with RSS, just xml Hopefully someone > with experience will help. Try googling this "how to download rss feed > into excel" and that should get you going in the right direction > > On 16 March 2015 at 15:07, Bill Q > > wrote: > >> Hi Martin, >> >> Thanks for the reply. I have no idea how to work with this. I am not >> overly savvy with this ? >> >> Can you give me any insight on how this can be done ? Is it >> relatively easy ? >> >> On Sunday, 15 March 2015 21:39:53 UTC-4, Martin Wheeler wrote: >> >>> Have you tried using the xml feed on http://www.covers.com/rss/ >>> index.aspx ? That may be your best bet - use a xml schema to import to >>> excel >>> >>> >>> Ta >>> Martin >>> >>> On 16 March 2015 at 09:28, Bill Q wrote: >>> Hi, Normally I can do this, but I can't with this particular site starting at this page. - http://contests.covers.com/Handicapping/topHandicappers. aspx?sportid=9 - Each page contains 50 records. - Somehow, something needs to be macro programed (if possible), so that it goes to the next page and extract the next 50 records - so on and so forth until it encounters the end. - The hyperlinks must remain in tact (the same as attached. If this cannot be done in Excel, can anyone suggest a good relatively inexpensive third party software that can do this ? Thanks !! -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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
Re: $$Excel-Macros$$ Help in Vlook-up or any other formula
Dear Vaibhav, Thank you very much for your quick support. This is very helpful. Regards, Vijayendra 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi : > PFA with #N/A handler... > > On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao > wrote: > >> Dear Experts, >> >> Can you please help me to put vlookup or any other formula for the the >> second row. Attached is the my file and request you to help on the same. >> >> Regards, >> Vijayendra >> 94491 67631 >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: vba recorded macro not working
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
Set Rng = Range("C1:C" & lr)
Debug.Print Rng.Address
For Each Cell In Rng
If Left(Cell.Value, 5) = "Estab" Then
estab = Cell
ElseIf Left(Cell.Value, 2) <> "CG" Then
temp = Cell
Debug.Print temp
Else
Debug.Print Len(estab)
Cell.Offset(0, -2).Value = Trim(Right(estab, Len(estab) - 14))
Cell.Offset(0, -1).Value = Trim(Right(temp, Len(temp) - 31))
End If
Next
ActiveSheet.Range("C3:C" & lr).AutoFilter field:=1, Criteria1:="<>*CG*"
ActiveSheet.Range("C2:C" &
lr).SpecialCells(xlCellTypeVisible).EntireRow.Delete
End Sub
--
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.
For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Help with combination formula
Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) combination has appeared within the > range D5:I32 > > > > > > 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...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > -- > 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...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > Attachments area > Preview attachment Paks.xlsx > Paks.xlsx > -- 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. For more options, visit https://groups.google.com/d/optout. Count_Combinations.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: Help with combination formula
Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, "Will Sob" wrote: > Thanks for responding yes in a single row. H l would like to know > about both methods of you can most appreciated > Tell me two things > > is the triplet combination your searching in single , single row one by > one it can be achievedd with concatenate > > but if you are trying to search the combination triplet like the I5 > contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? > > > > > > > > On Monday, 16 March 2015 10:04:17 UTC+5:30, Will Sob wrote: >> >> thanks for your reply: l have loads of values, l am trying to build a >> template where when l place numbers it should tell me how many triplet >> combination exist within a range >> >> 10, 13, 17 >> 1,19, 22 >> 7, 21,22 >> >> >> On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja >> wrote: >> >>> send me the values which you are trying to get >>> >>> On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja wrote: > Check this attachment achieved with a macro. Change your numbers > combination as per your requirement. > > Regards, > MandeepBaluja > Learningzmypassion. > https://www.facebook.com/VBAEXCELSQL?ref=hl > https://www.linkedin.com/profile/view?id=312532939 > > > > On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: >> >> l'm sorry please see attachment >> >> On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan >> wrote: >> >>> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >>> > Hi, >>> > Please I need help with the attached file. I want a formula that >>> calculates how many times (10, 13, 17) combination has appeared within >>> the >>> range D5:I32 >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > 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...@googlegroups.com. >>> > To post to this group, send email to excel-...@googlegroups.com. >>> > Visit this group at http://groups.google.com/group/excel-macros. >>> > For more options, visit https://groups.google.com/d/optout. >>> > >>> > -- >>> > 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...@googlegroups.com. >>> > To post to this group, send email to excel-...@googlegroups.com. >>> > Visit this group at http://groups.google.com/group/excel-macros. >>> > For more options, visit https://groups.google.com/d/optout. >>> > >>> > >>> > >
Re: $$Excel-Macros$$ Re: Help with combination formula
Thanks for responding yes in a single row. H l would like to know about both methods of you can most appreciated Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16 March 2015 10:04:17 UTC+5:30, Will Sob wrote: > > thanks for your reply: l have loads of values, l am trying to build a > template where when l place numbers it should tell me how many triplet > combination exist within a range > > 10, 13, 17 > 1,19, 22 > 7, 21,22 > > > On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja > wrote: > >> send me the values which you are trying to get >> >> On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: >>> >>> thanks but it is not working when l use other values >>> >>> On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja >>> wrote: >>> Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: > > l'm sorry please see attachment > > On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan > wrote: > >> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >> > Hi, >> > Please I need help with the attached file. I want a formula that >> calculates how many times (10, 13, 17) combination has appeared within >> the >> range D5:I32 >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > 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...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- >> > 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...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > >> > >> > Attachments area >> > >> > Preview attachment Paks.xlsx >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > Paks.xlsx >> >> Attachments not found >> >> -- >> Are you =EXP(E
Re: $$Excel-Macros$$ Re: Help with combination formula
Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16 March 2015 10:04:17 UTC+5:30, Will Sob wrote: > > thanks for your reply: l have loads of values, l am trying to build a > template where when l place numbers it should tell me how many triplet > combination exist within a range > > 10, 13, 17 > 1,19, 22 > 7, 21,22 > > > On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja > wrote: > >> send me the values which you are trying to get >> >> On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: >>> >>> thanks but it is not working when l use other values >>> >>> On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja >>> wrote: >>> Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will Sob wrote: > > l'm sorry please see attachment > > On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan > wrote: > >> On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: >> > Hi, >> > Please I need help with the attached file. I want a formula that >> calculates how many times (10, 13, 17) combination has appeared within >> the >> range D5:I32 >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > 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...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > -- >> > 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...@googlegroups.com. >> > To post to this group, send email to excel-...@googlegroups.com. >> > Visit this group at http://groups.google.com/group/excel-macros. >> > For more options, visit https://groups.google.com/d/optout. >> > >> > >> > >> > Attachments area >> > >> > Preview attachment Paks.xlsx >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > Paks.xlsx >> >> Attachments not found >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >> It’s =TI
