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 Function
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of AK
Sent: Thursday, July 07, 2011 10:06 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel question
Hi Experts,
Could you please look into my excel query. I have the multiple columns
filled with some Revenue values. I need the first month when the revenue
started flowing in (anything which is greater than 0).
For example - for the Account Name: Mohan, We started recognizing the
revenue from '3/31/2010' so 'Revenue started from Month' Column should have
3/31/2010 as the output.
Excel formula or Macro . Anything is fine with me :-)
Thanking you in Advance.
--
Regards,
AK
--
----------------------------------------------------------------------------
------
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
