LinkBack URL
About LinkBacks
Hello,
I trying to write a formula that finds the first number in a row that is greater than zero and return the column header, which in my document is a date.
In the attached example I want cell K3 to return the date 1/4/2009.
Thanks for your help!
Hello,
I trying to write a formula that finds the first number in a row that is greater than zero and return the column header, which in my document is a date.
In the attached example I want cell K3 to return the date 1/4/2009.
Thanks for your help!
one way...
the following entered as an array with CTRL + SHIFT + ENTER
K3:=MIN(IF($B3:$J3>0,$B$2:$J$2))
Once array set the above will appear encased within { } ... copy down for remaining rows (above assumes dates listed in asc order from left to right ... if not you can alter to an INDEX approach)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks