I have range of values and need to return min and max values of that range, however, some of the values in the range are #N/A and when I use =min or =max formula I always get #N/A as a result.
How to make excel exclude those #N/A values and pick min and max from those cells, which contain actual numbers only? so, let's say =min formula in G2 would only take values from B2 and C2?
I attached a photo, which may help to describe my issue.
Thanks!
Bookmarks