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
--
--
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
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
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