admin管理员组

文章数量:1122832

I've figured out how to use MATCH to return the number of the column of the first number greater than X. See the image (formula I put in cell G3).

However, when I try something similar – the formula I put in G4 was:
=MATCH(TRUE,B4:E4>0.5,0)

It returns 1 (see the result in G4 in the image) because the text in cell B4 (Apple) "counts" as being greater than 0.5. I want it to ignore anything that is not a number and return to me the number of the column of the first cell with a number greater than 0. That means it would skip over B4, because it is text, and return 2 because C4 contains the number 8, which is greater than 0.5 (when I use this on my other spreadsheet, I want it to be greater than 0 rather than 0.5).

If anyone can point me in the right direction, that'd be fantastic.

本文标签：

版权声明：本文标题：excel - Using MATCH Function to Get Number of Column With First Cell Greater Than Zero but Ignoring Non-Numbers - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736299990a1930655.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。