excel - Right to left offset formula with match -


i'm looking return start , end dates of person availability based upon gantt chart of hours on project.

i can @ minute return start of availability, formula looking left right , returning date of first "0" cell meets.

i need formula right left , return date of cell of last "0" meets.

formula is: =iferror(offset(b3,(row(b3)-2)*-1,match(0,c3:o3,0)),"")

data available here

this formula return results you're after:
{=index($c$2:$s4,1,max(if($c4:$s4>0,column($c4:$s4),0)))}

enter array/cse formula (use ctrl+shift+enter complete formula - put curly brackets in).

nb: return 00/01/1900 if last date greater 0.
adding custom format result cells hide 00/01/1900: dd/mm/yyyy;;;

i used reference answer: http://www.mrexcel.com/forum/excel-questions/234469-find-last-value-row-greater-than-zero.html


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -