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
Hi Deepak,
Copy and paste the below formula in Second Row after Column H.
=IF(B2>100,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 unde
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 wrote:
> Hil All
>
> I have attached the file of data.
>
> My problem is i have to find the qualifying month of sales by a formula
