This also can be used: =COUNTA(D2:D15)
Regards
Pravin Gunjal.
On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes rbar...@hcsgcorp.com wrote:
You are a GENIUS!!!
On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Are you looking for this?
=COUNTIF($D$2:$D$15,S)
You are a GENIUS!!!
On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Are you looking for this?
=COUNTIF($D$2:$D$15,S)
Regards,
Sam Mathai Chacko
On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes rbar...@hcsgcorp.comwrote:
First of all thank you. I am, at best,
Are you looking for this?
=COUNTIF($D$2:$D$15,S)
Regards,
Sam Mathai Chacko
On Sat, Nov 2, 2013 at 4:16 AM, Robert Barnes rbar...@hcsgcorp.com wrote:
First of all thank you. I am, at best, a novice user of excel. Even though
we use it for its most basic functions daily. I am attempting to
Pls find a UDF
Public Function GetFirstRevenueDate(Rng As Range)
For Each cls In Rng.Cells
If cls.Value 0 Then
Dt = Cells(1, cls.Column)
GetFirstRevenueDate = Format(Dt, dd-mmm-)
Exit Function
End If
Next
End Function
File attached.
On Thu, Jul 7, 2011 at 10:05 PM, AK exce...@gmail.com
Hi,
C2 copy down.
=IFERROR(INDEX(D$1:SF$1,MATCH(TRUE,INDEX(ISNUMBER(1/D2:SF2),),0)),Not
Started)
HTH
Haseeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
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
=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*
*
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