This also can be used: =COUNTA(D2:D15)
Regards
Pravin Gunjal.
On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes wrote:
> You are a GENIUS!!!
>
>
> On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote:
>
>> Are you looking for this?
>>
>> =COUNTIF($D$2:$D$15,"S")
>>
>> Regards,
>> Sam Mathai Cha
You are a GENIUS!!!
On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote:
> 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 wrote:
>
>>
>>
>> First of all thank you. I am, at best, a novice user of exc
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 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 go to the
> ne
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 wrote:
> =INDEX($1:$1,0,SMALL(IF(D2:AB2>0,COLUMN(D2:AB2),""),1))
>
> press ctrl +shift+ enter
>
> check the attachment
>
>
> On Fri, Jul 8, 2011 at 12:31 AM
=INDEX($1:$1,0,SMALL(IF(D2:AB2>0,COLUMN(D2:AB2),""),1))
press ctrl +shift+ enter
check the attachment
On Fri, Jul 8, 2011 at 12:31 AM, Rajan_Verma wrote:
> *Try this Function in C2*
>
> * *
>
> *Function GetStartDate(RevRange As Range) As Variant*
>
> *Dim cell As Range*
>
> *For Each cell
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 Functio
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 :
ht
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 wrote:
> Hi Exper