$$Excel-Macros$$ Find the month of sales cross the target
Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as Not Qualify Pls Help!! Regards, Deepak -- -- 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 Sale Cross Querry.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Find the month of sales cross the target
Dear deepak here is the sample formula =If(sum(b2:b2)=100,Qualified,Not Qualified) -- *Great day,* *viper* On Fri, Sep 23, 2011 at 3:04 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as Not Qualify Pls Help!! Regards, Deepak -- -- 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
Re: $$Excel-Macros$$ Find the month of sales cross the target
Hi Deepak, Copy and paste the below formula in Second Row after Column H. =IF(B2100,B$1,IF(SUM(B2:C2)100,C$1,IF(SUM(B2:D2)100,D$1,IF(SUM(B2:E2)100,E$1,IF(SUM(B2:F2)100,F$1,IF(SUM(B2:G2)100,G$1,IF(SUM(B2:H2)100,H$1,Not Qualified))) I have attached an example file for your better understanding. Hope that helps! --- Ms.Exl.Learner --- On Fri, Sep 23, 2011 at 3:04 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as Not Qualify Pls Help!! Regards, Deepak -- -- 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 -- --- Ms.Exl.Learner --- -- -- 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 Sale Cross Querry - Solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Find the month of sales cross the target
How about a nice macro to populate col K and color the month within the row. Option Explicit Sub crossmonthSAS() Dim i As Long Dim j As Double Dim ms As Long For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row ms = 0 For j = 2 To 8 ms = ms + Cells(i, j) If ms 100 Then Cells(i, k) = Not Qualified Else 'MsgBox Cells(1, j - 1) Cells(i, K) = Cells(1, j) Cells(i, j).Interior.ColorIndex = 4 Exit For End If Next j Next i End Sub -Original Message- From: Deepak Rawat Sent: Friday, September 23, 2011 4:34 AM To: excel-macros Subject: $$Excel-Macros$$ Find the month of sales cross the target Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as Not Qualify Pls Help!! Regards, Deepak -- -- 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
