Re: $$Excel-Macros$$ No. Of sundays between dates
Chandru, Please refer the sheet. Regards, Sarvesh On Tue, Apr 3, 2018 at 7:46 PM, chandrashekarb.xls < chandrashekarb@gmail.com> wrote: > Hello, > > How to know no. Of sundays between dates? > > Regards, > Chandru > > > > Sent from my Samsung Galaxy smartphone. > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards, AK -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book1_Sol Sunday Count.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Count help
Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb 2014) to last blank cell and ignoring rest of the previous values. countblank or CountA formula is not working as they are counting all the cells in the range. For example 1: If I need to update cell N2 the value should be 2, as there are 2 non-blank cells from the Feb 2014 (Feb 14 and Jan 14) and ignoring rest of the prior values in the range (B2 : M2) For example 2. If I need to update cell N3 the value should be 5, as there are 5 non-blank cells from the Feb 2014 (Feb 14 to Oct 13) and ignoring rest of the prior values in the range (b3 : M3) Please let me know the solution. -- Regards, AK -- 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. test1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: FW: $$Excel-Macros$$ Count help
Thanks alot Raviinder! On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei ravindervbacli...@gmail.comwrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *AK *Sent:* Wednesday, March 19, 2014 8:15 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Count help Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb 2014) to last blank cell and ignoring rest of the previous values. countblank or CountA formula is not working as they are counting all the cells in the range. For example 1: If I need to update cell N2 the value should be 2, as there are 2 non-blank cells from the Feb 2014 (Feb 14 and Jan 14) and ignoring rest of the prior values in the range (B2 : M2) For example 2. If I need to update cell N3 the value should be 5, as there are 5 non-blank cells from the Feb 2014 (Feb 14 to Oct 13) and ignoring rest of the prior values in the range (b3 : M3) Please let me know the solution. -- Regards, AK -- 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, AK -- 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$$ lookup based on multiple dates.
Hi All, I have a question, looking for solution through formula (but VBA is fine if not possible through formula :) )...I have 2 sheets in a workbook i.e Cust data and Review... In the Cust data sheet I have start date of the project i.e column B, column C is First review date and Column D is second review date of project and Review Sheet is the lookup table Question 1 (Column E): I need to find out how many times the particular end customer id has occurred between “Start date” and “First Review date” using Review Sheet tab. For example : end customer id “1-168WAQL” occured once between Start date (3/1/2011) and First Review date (7/31/2011) so the output in column E should be 1. Question 2 (Column f); on the similar line as previous question I need to find out how many times the particular end customer id has occurred between “*First Review Date”* and “*Second Review date”* using Review Sheet tab. For example : end customer id “1-168WAQL” occur once between *First Review date* (7/31/2011) and *Second Review date* (2/29/2012) so the output in column F should be 1. Sample data is attached for reference. Note : date format is MM/DD/. -- Regards, AK -- 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. Sample Data _AK.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!
you can use any Excel function in vba via Application.WorksheetFunction.function Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4) arg= parameters required in excel functions Application.WorksheetFunction.VLookup(range(A1).value,Range(B1:D7),2,0) Best Regards, Anubhav On Monday, May 14, 2012 3:53:28 PM UTC+5:30, Bullet wrote: Hi All, Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Excel question
Hi Experts, Could you please look into my excel query. I have the multiple columns filled with some Revenue values. I need the first month when the revenue started flowing in (anything which is greater than 0). For example – for the Account Name: Mohan, We started recognizing the revenue from ‘3/31/2010’ so ‘Revenue started from Month’ Column should have 3/31/2010 as the output. Excel formula or Macro . Anything is fine with me :-) Thanking you in Advance. -- Regards, AK -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ABC sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel question
Thanks Vasant, Haseeb, Rajan and Ashish for your solution .. you guys are Master ! Regards, AK On Fri, Jul 8, 2011 at 5:39 AM, ashish koul koul.ash...@gmail.com wrote: =INDEX($1:$1,0,SMALL(IF(D2:AB20,COLUMN(D2:AB2),),1)) press ctrl +shift+ enter check the attachment On Fri, Jul 8, 2011 at 12:31 AM, Rajan_Verma rajanverma1...@gmail.comwrote: *Try this Function in C2* * * *Function GetStartDate(RevRange As Range) As Variant* *Dim cell As Range* *For Each cell In RevRange* *If cell.Value 0 Then* *GetStartDate = Cells(1, cell.Column).Value* *Exit Function* *End If* *Next* *End Function* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *AK *Sent:* Thursday, July 07, 2011 10:06 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Excel question ** ** Hi Experts, ** ** Could you please look into my excel query. I have the multiple columns filled with some Revenue values. I need the first month when the revenue started flowing in (anything which is greater than 0). ** ** For example – for the Account Name: Mohan, We started recognizing the revenue from ‘3/31/2010’ so ‘Revenue started from Month’ Column should have 3/31/2010 as the output. ** ** Excel formula or Macro . Anything is fine with me :-) Thanking you in Advance. -- Regards, AK -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, AK -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Export from Excel to access
I have an excel sheet with some data on sheet2 and I need to export this to an access database secured via workgroups security. The code I have works fine with database without security workgroup. Sub EXPORT() Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long ' connect to the Access database Set cn = New ADODB.Connection cn.Open Provider=Microsoft.Jet.OLEDB.4.0; _ Data Source=C:\Documents and Settings\Anubhav\Desktop\Desktop \Mydb.mdb,USERID,PASSWORD ' open a recordset Set rs = New ADODB.Recordset rs.Open table1, cn, adOpenKeyset, adLockOptimistic, adCmdTable ' all records in a table r = 2 ' the start row in the worksheet 'Do While Len(Range(A r).Formula) 0 ' repeat until first empty cell in column A With rs .AddNew ' create a new record ' add values to each field in the record .Fields(Status) = Sheets(Sheet2).Range(B r).Value .Fields(Type) = Sheets(Sheet2).Range(C r).Value .Update ' stores the new record End With ' r = r + 1 ' next row 'Loop rs.Close Set rs = Nothing cn.Close Set cn = Nothing End Sub --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---