Hi.
If I have the following values (in the range A6:A10), and would like to return the row number (in this case the answer = 3) from the first row of "table" of the first non-zero value (from the top), is there a formula to do that?
A
6 0
7 0
8 233412
9 198349
10 2309458076
Thanks.
Hi,
Use the formula:
=COUNTIF(A6:A10,">0")
and that will return the answer 3
Sorry it returns because there are 3 numbers that are more than 0
Regards Howard
Last edited by Gearcutter; 10-11-2008 at 04:59 PM. Reason: Incorrect answer
I think this is what you need
*Press Ctrl + Shift + Enter.
Please Login or Register to view this content.
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks