, August 31, 2012 7:35 AM
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Required Revenue started from Date..
Hi Experts,
I want to required Revenue started from Date.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld
Send ME your file
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Monday, September 10, 2012 3:10 AM
To: excel-macros@googlegroups.com
Subject: FW: $$Excel-Macros$$ Required Revenue started from Date..
Hi Don,
Thanks for your post
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required Revenue started from Date..
This is an array formula that must be entered using ctrl+shift+enter
=INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kuldeep
, August 31, 2012 7:35 AM
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Required Revenue started from Date..
Hi Experts,
I want to required Revenue started from Date.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld
Dear Kuldeep,
Please try it..
=INDEX($1:$1,0,SMALL(IF(D2:S20,COLUMN($D$1:$S$1),),COLUMN($A$1)))
with ctrl+shift+enter
See attached sheet for more clarity.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
: $$Excel-Macros$$ Required Revenue started from Date..
Hi Experts,
I want to required Revenue started from Date.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
Please Consider the environment. Please don't print this e-mail unless you
really
Don Sir, Nice Solution with excellent logic..
Kuldeep, you can also use vba version as UDF
Function Get_RevenueDate(Rng As Excel.Range)
Dim Cell As Range
For Each Cell In Rng.Cells
If Cell.Value 0 Then
Get_RevenueDate = Cells(1, Cell.Column).Value
Exit Function
End If
Next
End Function
On