LinkBack URL
About LinkBacks
Sekars 
Hello Friends
I need to plot the minimum value for the given year by skipping or ignoring the
zeros, blanks and error values.
The values to be plotted in the light yellow color cells.
thanks in advance
Hello Friends
I need to plot the minimum value for the given year by skipping or ignoring the
zeros, blanks and error values.
The values to be plotted in the light yellow color cells.
thanks in advance
Sekar
Try this array formula entered with CTRL + SHIFT + ENTER
=MIN(IF(ISNUMBER($B$1:$B$834),IF(YEAR($A$1:$A$834)=E4,IF($B$1:$B$834>0,$B$1:$B$834))))
Hello Jonmo1
Thank you your formula helped me to save the time.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks