I am trying to create a formula so that from a list of say 2000 of which 1999
are "NO" and one will be a digit, what formula can I use so that this one is
selected out of all of them?

Example:
7
No
No
No
No
....
I want to create a formula so that all the cells are checked and it picks
the 7 (or whatever number) because it is not a "NO".

Thanks.