Hello:
Please refer to attached file.
I need formula in cell F1 to give me the Row# of 1st non-zero cell.
In this case its row#21
Let me know if you have any questions.
Thanks.
R
Hello:
Please refer to attached file.
I need formula in cell F1 to give me the Row# of 1st non-zero cell.
In this case its row#21
Let me know if you have any questions.
Thanks.
R
See if the following formula works for you:
=MATCH(1,INDEX(ISNUMBER(A1:A10000)*(A1:A10000>0),0),0)
You have negative numbers ... they are non-zero values
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello:
Thanks to all and special to Alkey for simple solution
R
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks