$$Excel-Macros$$ need PowerPoint VBA book
Hi guys, if anyone have PowerPoint VBA book, please share. Thanks, Maksood Alam -- 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/groups/opt_out.
Re: $$Excel-Macros$$ Please help on FileName = Dir()
Hi Paul, Thank you very much. It solved my query. [?] Regard, Maksood Alam On Thu, Dec 5, 2013 at 5:59 PM, Paul Schreiner wrote: > In your script, you have a line: > FileName = Dir(CurrDir & "*.*", vbDirectory) > This basically creates a "collection" of information from "CurrDir". > vbDirectory indicates that it is to return "directories or folders in > addition to files with no attributes". > > the statement itself returns the first entry in CurrDir. > > to loop through the rest of the entries in Currdir, > you use Dir() > So basically, Filename = Dir(CurrDir & "*.*",vbDirectory) > gets the first entry, > Filename = Dir() > loops through the rest of the entries. > > BTW: All this can be found using the VBA "help". > > hope this helps. > > *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:* maksood alam <786maks...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 4, 2013 2:05 PM > *Subject:* $$Excel-Macros$$ Please help on FileName = Dir() > > Hi Guys, > > Can anyone please explaint what *FileName = Dir() *is doing in below > code. > > > Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As > Long) > Dim Dirs() As String > Dim NumDirs As Long > Dim FileName As String > Dim PathAndName As String > Dim i As Long > Dim Filesize As Double > ' Make sure path ends in backslash > If Right(CurrDir, 1) <> "\" Then CurrDir = CurrDir & "\" > ' Put column headings on active sheet > Cells(1, 1) = "Path""" > Cells(1, 2) = "Filename""" > Cells(1, 3) = "Size""" > Cells(1, 4) = "Date / Time""" > Range("A1:D1").Font.Bold = True > ' Get files > FileName = Dir(CurrDir & "*.*", vbDirectory) > Do While Len(FileName) <> 0 > If Left(FileName, 1) <> "." Then 'Current Dir > PathAndName = CurrDir & FileName > MsgBox (GetAttr(PathAndName) And vbDirectory) > If (GetAttr(PathAndName) And vbDirectory) = vbDirectory Then > 'store found directories > ReDim Preserve Dirs(0 To NumDirs) As String > Dirs(NumDirs) = PathAndName > NumDirs = NumDirs + 1 > Else > 'Write the path and file to the sheet > Cells(WorksheetFunction.CountA(Range("A:A")) + 1, 1) = _ > CurrDir > Cells(WorksheetFunction.CountA(Range("B:B")) + 1, 2) = _ > FileName > 'adjust for filesize > 2 gigabytes > Filesize = FileLen(PathAndName) > If Filesize < 0 Then Filesize = Filesize + 4294967296# > Cells(WorksheetFunction.CountA(Range("C:C")) + 1, 3) = > Filesize > Cells(WorksheetFunction.CountA(Range("D:D")) + 1, 4) = _ > FileDateTime(PathAndName) > End If > End If > > *FileName = Dir()*Loop > ' Process the found directories, recursively > For i = 0 To NumDirs - 1 > RecursiveDir Dirs(i), Level + 2 > Next i > End Sub > > > > > Thanks, > Maksood Alam > -- > 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. >
$$Excel-Macros$$ Please help on FileName = Dir()
Hi Guys, Can anyone please explaint what *FileName = Dir() *is doing in below code. Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As Long) Dim Dirs() As String Dim NumDirs As Long Dim FileName As String Dim PathAndName As String Dim i As Long Dim Filesize As Double ' Make sure path ends in backslash If Right(CurrDir, 1) <> "\" Then CurrDir = CurrDir & "\" ' Put column headings on active sheet Cells(1, 1) = "Path""" Cells(1, 2) = "Filename""" Cells(1, 3) = "Size""" Cells(1, 4) = "Date / Time""" Range("A1:D1").Font.Bold = True ' Get files FileName = Dir(CurrDir & "*.*", vbDirectory) Do While Len(FileName) <> 0 If Left(FileName, 1) <> "." Then 'Current Dir PathAndName = CurrDir & FileName MsgBox (GetAttr(PathAndName) And vbDirectory) If (GetAttr(PathAndName) And vbDirectory) = vbDirectory Then 'store found directories ReDim Preserve Dirs(0 To NumDirs) As String Dirs(NumDirs) = PathAndName NumDirs = NumDirs + 1 Else 'Write the path and file to the sheet Cells(WorksheetFunction.CountA(Range("A:A")) + 1, 1) = _ CurrDir Cells(WorksheetFunction.CountA(Range("B:B")) + 1, 2) = _ FileName 'adjust for filesize > 2 gigabytes Filesize = FileLen(PathAndName) If Filesize < 0 Then Filesize = Filesize + 4294967296# Cells(WorksheetFunction.CountA(Range("C:C")) + 1, 3) = Filesize Cells(WorksheetFunction.CountA(Range("D:D")) + 1, 4) = _ FileDateTime(PathAndName) End If End If *FileName = Dir()*Loop ' Process the found directories, recursively For i = 0 To NumDirs - 1 RecursiveDir Dirs(i), Level + 2 Next i End Sub Thanks, Maksood Alam -- 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/groups/opt_out.
Re: $$Excel-Macros$$ Need help--- conversion* in differetn laguage
> > Hi All, > > if we covert a macro file to the a different language file, let's say in > Spanish. will the macro work in that converted laguage file? > > > Thanks, > Maksood Alam > -- 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/groups/opt_out.
$$Excel-Macros$$ Need help--- conversation in differetn laguage
Hi All, if we covert a macro file to the a different language file, let's say in Spanish. will the macro work in that converted laguage file? Thanks, Maksood Alam -- 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/groups/opt_out.
$$Excel-Macros$$ Need help on worksheet protect and unprotect code
Hi Guys, I have workbook with codeing below Private Sub Worksheet_Change(ByVal Target As Range) *Sheets("MMPs").Unprotect "1234"* ** If ActiveSheet.Name = "MMPs" And Target.Column = 2 Then If Selection.Value = "F" Then Selection.EntireRow.Interior.Color = vbYellow ElseIf Selection.Value = "C" Then Selection.EntireRow.Interior.ColorIndex = 15 ElseIf Selection.Value = "N" Then Selection.EntireRow.Interior.ColorIndex = 34 End If End If *Sheets("MMPs").Protect "1234"* End Sub when i make it a share workbook, and change value then its shows error "Run time error 1004, Unprotect method of worksheet class failed." Please help on this.. -- 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.
Re: $$Excel-Macros$$ Need help to fill the range between two date.(column wise)
Noorain bhai, Need it throgh Vba Coding. On Tue, May 7, 2013 at 6:39 PM, NOORAIN ANSARI wrote: > Dear Maksood, > > Pls see attachment hope it will help to you. > > > On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote: > >> Hi guys, >> >> I have to select two dates, start date and end date. e.g. start date is >> 31/dec/2012 and end date is 31/jan/2014, then it should start range from >> 31/dec/2012 and add 7 days and drag it to the end date 31/jan/2014. and it >> should be colum wise . See below for more clarification. start and end date >> is dynamic, I will create a form to select the start and end date. >> >>*31-Dec* >> *7-Jan* >> *14-Jan* >> *21-Jan* >> *28-Jan* >> *4-Feb* >> *11-Feb* >> *18-Feb* >> >> >> >> Thanks >> Maksood alam >> >> -- >> 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. >> >> >> > > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> > http:// > <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> > > -- > 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.
$$Excel-Macros$$ Need help to fill the range between two date.(column wise)
Hi guys, I have to select two dates, start date and end date. e.g. start date is 31/dec/2012 and end date is 31/jan/2014, then it should start range from 31/dec/2012 and add 7 days and drag it to the end date 31/jan/2014. and it should be colum wise . See below for more clarification. start and end date is dynamic, I will create a form to select the start and end date. *31-Dec* *7-Jan* *14-Jan* *21-Jan* *28-Jan* *4-Feb* *11-Feb* *18-Feb* Thanks Maksood alam -- 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.
Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***
Hi ashish, Thanks your very much, it solved my query. On Sat, Mar 30, 2013 at 10:03 AM, ashish koul wrote: > try the attachment .. see if it helps > > > > On Fri, Mar 29, 2013 at 10:37 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi all >> >> please send me the code to attach a file in outlook and send it to >> respective email address. >> >> >> Thanks >> Maksood alam >> >> -- >> 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. >> >> >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *My Excel Blog <http://www.excelvbamacros.com/>* > Like Us on > Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > > -- > 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.
$$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***
Hi all please send me the code to attach a file in outlook and send it to respective email address. Thanks Maksood alam -- 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.
Re: $$Excel-Macros$$ Please Try this ,I assure you will be benefited
Hi Aju, Could you please share the coding part also.. so we can learn. On Thu, Jan 17, 2013 at 10:10 AM, Aju Chacko wrote: > Please see the *Reconciliation Tool *attached herewith,Which is an * > EXCEL-ADDIN* created by me.Which very useful for Handling large excel > database. This utility has got three options > > 1] *Reconciliation* > This option help you to *Reconcile two Excel worksheets/Workbooks > based on 1 /2/ 3 Common Field(s)*.Based on the common field(s),the * > Difference/Sum/Product/Quotient* of *Numerical fields of first sheet & > second sheet can be calculated *[*The sum of Numerical fields in each > sheet based on the common fields calculated first,then the selected > operation (+,-,*,/) applied on numerical fields*] .In the sample file > named *SALES DATA* the examples are demonstrated. > > 2] *Vlookup* >This option is a *Menu driven utility for making Vlookup > between two list of data ,E*ven without knowing the syntax for Vlookup > .The advantage of this utility is that if blank spaces are there in look-up > fields program will be automatically eliminate it.if numbers are stored as > text numbers that also will taken care of during Vlookup. If Vlookup is not > successful *N/A* error message will not be displayed in cells.since > the program copies formula automatically down the cells,You need not have > copy Vlookup formula down the cells > > 3] *Compare* > This option is useful to *Compare two excel sheets cell > by cell, *in output sheet the cell address/first sheet's value/Second > sheet's value are displayed side by side & the cells with difference > are colored in original sheets for easily identifying > > A file called SALES DATA attached herewith demonstrating all the examples > *HOW TO INSTALL THE UTILITY* > * Please save the add-in RECONCILIATION.XLAM to any folder you like.**Then > double click on the icon,Then the utility is installe*d.Once installed a > new tab called ADD-IN appears at the end of the Excel ribbon as shown in > picture below.*Double click on the icon to execute the utility*. > > > > 1] *Advantages of RECONCILIATION UTILITY* > When the program is executed it shows a menu that displays all > the worksheets in all open workbooks,so you need not have bring the > worksheets two the same workbook.*The program automatically recognize the > rectangular data even if the first row doesn't contain filed headers / Or > if tables titles/heading are appearing above the data (as shown in NOV 12 > sales w.sheet in SALES DATA)*.You have the option to select the output to > a new Worksheet/Workbook > > * So please try & Give your valuable feed back* > > Aju V Chacko > > > -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. <>
Re: $$Excel-Macros$$
Please try =TEXT(TEXT(A2,"hh:mm")-TEXT(B2,"hh:mm"),"hh:mm") On Wed, Oct 3, 2012 at 6:33 PM, Chandra Shekar wrote: > Hello, > > Could you please help me in the attached file. > > Thanks in advance. > > Regards, > > Chandra Shekar B > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ I want to Learn Array Formulas
don don don, i did't find it thats why am asking, why u take all the thing in wrong way. On 9/7/12, dguillett1 wrote: > Is there some reason you cannot “google” it yourself > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > From: maksood alam > Sent: Friday, September 07, 2012 12:50 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ I want to Learn Array Formulas > > Hi Rajan > > Please provide the link to download > Excel function and formulas by Berend held > > > > > On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma > wrote: > > Google and Download this book > > > > Excel function and formulas by Berend held > > > > > > Regards > > Rajan verma > > +91 7838100659 [IM-Gtalk] > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Waseem Saifi > Sent: 07 September 2012 2:59 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ I want to Learn Array Formulas > > > > Hi All Members, > > I want to learn array formulas in excel 2007. > > Please send me some useful stuff or refer me any useful link to learn > array formulas. > > thanx in advance. > > > > Regards, > > Waseem Saifi > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > mailto:excel-macros%2bunsubscr...@googlegroups.com. > > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing
Re: $$Excel-Macros$$ I want to Learn Array Formulas
Hi Rajan Please provide the link to download *Excel function and formulas by Berend held* On Fri, Sep 7, 2012 at 7:24 PM, Rajan_Verma wrote: > *Google and Download this book* > > * * > > *Excel function and formulas by Berend held* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi > *Sent:* 07 September 2012 2:59 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ I want to Learn Array Formulas > > ** ** > > Hi All Members, > >I want to learn array formulas in excel 2007. > >Please send me some useful stuff or refer me any useful link to learn > array formulas. > >thanx in advance. > > > > Regards, > > Waseem Saifi > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ show only last four digit of the number
Thanks sam, for the great support. On Fri, Sep 7, 2012 at 11:02 PM, Sam Mathai Chacko wrote: > Here's the file > > Sam Mathai Chacko > > > On Fri, Sep 7, 2012 at 11:01 PM, Sam Mathai Chacko wrote: > >> Not sure if I can provide a smaller formula :) >> >> Because of the length of the formula, if you ever want to try using a >> UDF, use this >> >> Function ASTERIK(strText As String, lngLeaveDigits As Long) >> >> Dim lng As Long >> Dim lngLen As Long >> >> For lngLen = Len(strText) To 1 Step -1 >> If IsNumeric(Mid(strText, lngLen, 1)) Then >> lng = lng + 1 >> If lngLeaveDigits < lng Then >> Mid(strText, lngLen, 1) = "*" >> End If >> End If >> Next >> ASTERIK = strText >> >> End Function >> >> Regards, >> Sam Mathai Chacko >> >> >> On Fri, Sep 7, 2012 at 10:57 PM, maksood alam <786maks...@gmail.com>wrote: >> >>> Thank you very much Sam, it solved my qurey, and it is the right >>> solution , but it is a very long formula , please provide me any short >>> formula if possible. >>> >>> On Fri, Sep 7, 2012 at 10:53 PM, Sam Mathai Chacko >>> wrote: >>> >>>> Didn't you find my solution worthwhile? >>>> >>>> Sam Mathai Chacko >>>> >>>> >>>> On Fri, Sep 7, 2012 at 10:52 PM, maksood alam <786maks...@gmail.com>wrote: >>>> >>>>> Paul, >>>>> >>>>> I want excel function solution. >>>>> >>>>> On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote: >>>>> >>>>>> superb answer sam.. >>>>>> >>>>>> Thx >>>>>> >>>>>> >>>>>> On Friday, September 7, 2012 9:21:48 PM UTC+5:30, Sam Mathai Chacko >>>>>> wrote: >>>>>> >>>>>>> Would this help? >>>>>>> >>>>>>> Regards, >>>>>>> Sam Mathai Chacko >>>>>>> >>>>>>> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786ma...@gmail.com>wrote: >>>>>>> >>>>>>>> Partially correct, but it show as per below >>>>>>>> >>>>>>>> *Numbers* >>>>>>>> *Required out put* >>>>>>>> 555-55-5505 >>>>>>>> ***-***-5505 >>>>>>>> 555-55-125-0 >>>>>>>> ***-**-***-* >>>>>>>> 555-55--23 >>>>>>>> ***-**-**55-23 >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Sep 7, 2012 at 8:41 PM, Kuldeep Singh < >>>>>>>> naukri...@gmail.com> wrote: >>>>>>>> >>>>>>>>> >>>>>>>>> Dear Maksood, >>>>>>>>> >>>>>>>>> You can use this and more clarity see attached file. >>>>>>>>> >>>>>>>>> =RIGHT(SUBSTITUTE(A1,"-",""),**4) >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Kuldeep Singh >>>>>>>>> >>>>>>>>> >>>>>>>>> On Fri, Sep 7, 2012 at 8:38 PM, wrote: >>>>>>>>> >>>>>>>>>> ** >>>>>>>>>> First use Substitue fn to subst "-" with "" and then use Right >>>>>>>>>> function. >>>>>>>>>> >>>>>>>>>> Rgds >>>>>>>>>> Vabs >>>>>>>>>> -- >>>>>>>>>> *From: *maksood alam <786ma...@gmail.com> >>>>>>>>>> *Sender: *excel-...@googlegroups.com >>>>>>>>>> *Date: *Fri, 7 Sep 2012 20:33:28 +0530 >>>>>>>>>> *To: * >>>>>>>>>> *ReplyTo: *excel-...@googlegroups.com >>>>>>>>>> *Subject: *Re: $$Excel-Macros$$ show only last four digit of >>>>>>>>>> the number >>>>>>>>>> >>>>>>>>>> >>
Re: $$Excel-Macros$$ show only last four digit of the number
Thank you very much Sam, it solved my qurey, and it is the right solution , but it is a very long formula , please provide me any short formula if possible. On Fri, Sep 7, 2012 at 10:53 PM, Sam Mathai Chacko wrote: > Didn't you find my solution worthwhile? > > Sam Mathai Chacko > > > On Fri, Sep 7, 2012 at 10:52 PM, maksood alam <786maks...@gmail.com>wrote: > >> Paul, >> >> I want excel function solution. >> >> On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote: >> >>> superb answer sam.. >>> >>> Thx >>> >>> >>> On Friday, September 7, 2012 9:21:48 PM UTC+5:30, Sam Mathai Chacko >>> wrote: >>> >>>> Would this help? >>>> >>>> Regards, >>>> Sam Mathai Chacko >>>> >>>> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786ma...@gmail.com>wrote: >>>> >>>>> Partially correct, but it show as per below >>>>> >>>>>*Numbers* >>>>> *Required out put* >>>>> 555-55-5505 >>>>> ***-***-5505 >>>>> 555-55-125-0 >>>>> ***-**-***-* >>>>> 555-55--23 >>>>> ***-**-**55-23 >>>>> >>>>> >>>>> On Fri, Sep 7, 2012 at 8:41 PM, Kuldeep Singh >>>>> wrote: >>>>> >>>>>> >>>>>> Dear Maksood, >>>>>> >>>>>> You can use this and more clarity see attached file. >>>>>> >>>>>> =RIGHT(SUBSTITUTE(A1,"-",""),**4) >>>>>> >>>>>> Regards, >>>>>> Kuldeep Singh >>>>>> >>>>>> >>>>>> On Fri, Sep 7, 2012 at 8:38 PM, wrote: >>>>>> >>>>>>> ** >>>>>>> First use Substitue fn to subst "-" with "" and then use Right >>>>>>> function. >>>>>>> >>>>>>> Rgds >>>>>>> Vabs >>>>>>> -- >>>>>>> *From: *maksood alam <786ma...@gmail.com> >>>>>>> *Sender: *excel-...@googlegroups.com >>>>>>> *Date: *Fri, 7 Sep 2012 20:33:28 +0530 >>>>>>> *To: * >>>>>>> *ReplyTo: *excel-...@googlegroups.com >>>>>>> *Subject: *Re: $$Excel-Macros$$ show only last four digit of the >>>>>>> number >>>>>>> >>>>>>> >>>>>>> Kuldeep, please read my question in the mail. it should show last >>>>>>> four digit and rest of all should show "*". >>>>>>> if i use right(555-55--23,4) it will show 5-23 but the answer >>>>>>> should be 5523. >>>>>>> On Fri, Sep 7, 2012 at 8:29 PM, Kuldeep Singh >>>>>>> wrote: >>>>>>> >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> Try this one. >>>>>>>> >>>>>>>> =RIGHT(A1,4) >>>>>>>> >>>>>>>> Regards, >>>>>>>> Kuldeep Singh >>>>>>>> >>>>>>>> On Fri, Sep 7, 2012 at 8:15 PM, maksood alam >>>>>>>> <786ma...@gmail.com>wrote: >>>>>>>> >>>>>>>>> Hi Guys, >>>>>>>>> >>>>>>>>> Below are the number i want to show only last four digit of the >>>>>>>>> numbers and rest of all should be "*", please provide me the solution. >>>>>>>>> >>>>>>>>> *Numbers* >>>>>>>>> *Required out put* >>>>>>>>> 555-55-5505 >>>>>>>>> ***-***-5505 >>>>>>>>> 555-55-125-0 >>>>>>>>> ***-**-***-* >>>>>>>>> 555-55--23 >>>>>>>>> ***-**-**55-23 >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Join official facebook page of this forum @ >>>>>>>>> https://www.facebook.com/**discussexcel<https://www.fac
Re: $$Excel-Macros$$ show only last four digit of the number
Paul, I want excel function solution. On Fri, Sep 7, 2012 at 10:21 PM, Vabs wrote: > superb answer sam.. > > Thx > > > On Friday, September 7, 2012 9:21:48 PM UTC+5:30, Sam Mathai Chacko wrote: > >> Would this help? >> >> Regards, >> Sam Mathai Chacko >> >> On Fri, Sep 7, 2012 at 8:45 PM, maksood alam <786ma...@gmail.com> wrote: >> >>> Partially correct, but it show as per below >>> >>>*Numbers* >>> *Required out put* >>> 555-55-5505 >>> ***-***-5505 >>> 555-55-125-0 >>> ***-**-***-* >>> 555-55--23 >>> ***-**-**55-23 >>> >>> >>> On Fri, Sep 7, 2012 at 8:41 PM, Kuldeep Singh wrote: >>> >>>> >>>> Dear Maksood, >>>> >>>> You can use this and more clarity see attached file. >>>> >>>> =RIGHT(SUBSTITUTE(A1,"-",""),**4) >>>> >>>> Regards, >>>> Kuldeep Singh >>>> >>>> >>>> On Fri, Sep 7, 2012 at 8:38 PM, wrote: >>>> >>>>> ** >>>>> First use Substitue fn to subst "-" with "" and then use Right >>>>> function. >>>>> >>>>> Rgds >>>>> Vabs >>>>> -- >>>>> *From: *maksood alam <786ma...@gmail.com> >>>>> *Sender: *excel-...@googlegroups.com >>>>> *Date: *Fri, 7 Sep 2012 20:33:28 +0530 >>>>> *To: * >>>>> *ReplyTo: *excel-...@googlegroups.com >>>>> *Subject: *Re: $$Excel-Macros$$ show only last four digit of the >>>>> number >>>>> >>>>> >>>>> Kuldeep, please read my question in the mail. it should show last four >>>>> digit and rest of all should show "*". >>>>> if i use right(555-55--23,4) it will show 5-23 but the answer >>>>> should be 5523. >>>>> On Fri, Sep 7, 2012 at 8:29 PM, Kuldeep Singh wrote: >>>>> >>>>>> >>>>>> Hi, >>>>>> >>>>>> Try this one. >>>>>> >>>>>> =RIGHT(A1,4) >>>>>> >>>>>> Regards, >>>>>> Kuldeep Singh >>>>>> >>>>>> On Fri, Sep 7, 2012 at 8:15 PM, maksood alam <786ma...@gmail.com>wrote: >>>>>> >>>>>>> Hi Guys, >>>>>>> >>>>>>> Below are the number i want to show only last four digit of the >>>>>>> numbers and rest of all should be "*", please provide me the solution. >>>>>>> >>>>>>> *Numbers* >>>>>>> *Required out put* >>>>>>> 555-55-5505 >>>>>>> ***-***-5505 >>>>>>> 555-55-125-0 >>>>>>> ***-**-***-* >>>>>>> 555-55--23 >>>>>>> ***-**-**55-23 >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Join official facebook page of this forum @ >>>>>>> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel> >>>>>>> >>>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>>> >>>>>>> 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) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> 6) Jobs posting is not allowed. >>>>>>> >>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>>>> allowed. >
Re: $$Excel-Macros$$ show only last four digit of the number
Partially correct, but it show as per below *Numbers* *Required out put* 555-55-5505 ***-***-5505 555-55-125-0 ***-**-***-* 555-55--23 ***-**-**55-23 On Fri, Sep 7, 2012 at 8:41 PM, Kuldeep Singh wrote: > > Dear Maksood, > > You can use this and more clarity see attached file. > > =RIGHT(SUBSTITUTE(A1,"-",""),4) > > Regards, > Kuldeep Singh > > > On Fri, Sep 7, 2012 at 8:38 PM, wrote: > >> ** >> First use Substitue fn to subst "-" with "" and then use Right function. >> >> Rgds >> Vabs >> -- >> *From: *maksood alam <786maks...@gmail.com> >> *Sender: *excel-macros@googlegroups.com >> *Date: *Fri, 7 Sep 2012 20:33:28 +0530 >> *To: * >> *ReplyTo: *excel-macros@googlegroups.com >> *Subject: *Re: $$Excel-Macros$$ show only last four digit of the number >> >> >> Kuldeep, please read my question in the mail. it should show last four >> digit and rest of all should show "*". >> if i use right(555-55--23,4) it will show 5-23 but the answer should >> be 5523. >> On Fri, Sep 7, 2012 at 8:29 PM, Kuldeep Singh wrote: >> >>> >>> Hi, >>> >>> Try this one. >>> >>> =RIGHT(A1,4) >>> >>> Regards, >>> Kuldeep Singh >>> >>> On Fri, Sep 7, 2012 at 8:15 PM, maksood alam <786maks...@gmail.com>wrote: >>> >>>> Hi Guys, >>>> >>>> Below are the number i want to show only last four digit of the numbers >>>> and rest of all should be "*", please provide me the solution. >>>> >>>> *Numbers* >>>> *Required out put* >>>> 555-55-5505 >>>> ***-***-5505 >>>> 555-55-125-0 >>>> ***-**-***-* >>>> 555-55--23 >>>> ***-**-**55-23 >>>> >>>> >>>> >>>> -- >>>> Join official facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES (1120+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> 6) Jobs posting is not allowed. >>>> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>>> >>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> excel-macros+unsubscr...@googlegroups.com. >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. &g
Re: $$Excel-Macros$$ show only last four digit of the number
Kuldeep, please read my question in the mail. it should show last four digit and rest of all should show "*". if i use right(555-55--23,4) it will show 5-23 but the answer should be 5523. On Fri, Sep 7, 2012 at 8:29 PM, Kuldeep Singh wrote: > > Hi, > > Try this one. > > =RIGHT(A1,4) > > Regards, > Kuldeep Singh > > On Fri, Sep 7, 2012 at 8:15 PM, maksood alam <786maks...@gmail.com> wrote: > >> Hi Guys, >> >> Below are the number i want to show only last four digit of the numbers >> and rest of all should be "*", please provide me the solution. >> >> *Numbers* >> *Required out put* >> 555-55-5505 >> ***-***-5505 >> 555-55-125-0 >> ***-**-***-* >> 555-55--23 >> ***-**-**55-23 >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ show only last four digit of the number
Hi Guys, Below are the number i want to show only last four digit of the numbers and rest of all should be "*", please provide me the solution. *Numbers* *Required out put* 555-55-5505 ***-***-5505 555-55-125-0 ***-**-***-* 555-55--23 ***-**-**55-23 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ need tool for automation
like find duplicate, filter, advance filter, any reporting tool with the vba coding, so i can learn from it. On Wed, Sep 5, 2012 at 8:21 PM, Rajan_Verma wrote: > *What kind of tool* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *maksood alam > *Sent:* 04 September 2012 11:47 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ need tool for automation > > ** ** > > Hi Gusy, > > > > > > Please provide some website from where i can download automated tool for > excel. > > > > > > Thanks > > > > Maksood alam > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ need tool for automation
Hi Gusy, Please provide some website from where i can download automated tool for excel. Thanks Maksood alam -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ please help with array formula
Thanks Noorain bhai.. its solved my qurey.. On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote: > See attachment for more clarity > > On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi experts, >> >> I have data in once sheet in two colums like *NAME*(colum A) and >> *Marks*(colum >> B). In 2nd sheet i want a formula if i enter 20 its should show me the name >> of all the candidate who has 40 marks in 1st sheet. can it done with array >> forumla. please help. >> >> >> *Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY, >> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH, >> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 >> SENSENBRENNER, >> SUSAN 35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA >>40 ROLLINS, ANNETTE 40 CRATTY, CYNTHIA 40 RYAN, PHYLLIS 100 SPENCER, >> SUSAN 100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 >> ROMEO, >> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL 100 RYMSKI, JOSEPH G >> 100 >> >> >> >>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores* >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> > http:// > <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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)
Re: $$Excel-Macros$$ please help with array formula
cannot send any attchment due to system restrictions. On Tue, Aug 28, 2012 at 8:20 PM, ashish koul wrote: > can you send us the attachment > > > On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi experts, >> >> I have data in once sheet in two colums like *NAME*(colum A) and >> *Marks*(colum >> B). In 2nd sheet i want a formula if i enter 20 its should show me the name >> of all the candidate who has 40 marks in 1st sheet. can it done with array >> forumla. please help. >> >> >> *Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY, >> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH, >> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 >> SENSENBRENNER, >> SUSAN 35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA >>40 ROLLINS, ANNETTE 40 CRATTY, CYNTHIA 40 RYAN, PHYLLIS 100 SPENCER, >> SUSAN 100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 >> ROMEO, >> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL 100 RYMSKI, JOSEPH G >> 100 >> >> >> >>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores* >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* > > P Before printing, think about the environment. > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ please help with array formula
Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd sheet i want a formula if i enter 20 its should show me the name of all the candidate who has 40 marks in 1st sheet. can it done with array forumla. please help. *Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY, SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH, WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 SENSENBRENNER, SUSAN 35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA 40 ROLLINS, ANNETTE 40 CRATTY, CYNTHIA 40 RYAN, PHYLLIS 100 SPENCER, SUSAN 100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 ROMEO, CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL 100 RYMSKI, JOSEPH G 100 *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.