开发者

excel function to get value of another cell

开发者 https://www.devze.com 2022-12-23 09:01 出处:网络
Image describing the problem http://img215.imageshack.us/img215/3725/20100314235127schedule2.jpg I hope the image above can explain what I need. :)

Image describing the problem http://img215.imageshack.us/img215/3725/20100314235127schedule2.jpg

I hope the image above can explain what I need. :)

Problem 1: Get the date where it is 开发者_Python百科the first value in the row

Problem 2: Get the date where the value is 100

I would also attach the actual excel file, but I am limited to posting only 1 link.


Function for left blue cell:

=IF(COUNTIF(L11:BJ11,">0"),INDEX($L$2:$BJ$2,MATCH(TRUE,INDEX(L11:BJ11>0,0),0)),"")

Function for right blue cell:

=IF(COUNTIF(L11:BJ11,100),INDEX($L$2:$BJ$2,MATCH(100,L11:BJ11,0)),"")

0

精彩评论

暂无评论...
验证码 换一张
取 消