LinkBack URL
About LinkBacks
Hi all,
I got a problem in finding the minimum value from a range of values which includes both numbers and few cells with #N/A. Please help me out on this. Normal MIN function is not working.
Thanks in advance
Hi all,
I got a problem in finding the minimum value from a range of values which includes both numbers and few cells with #N/A. Please help me out on this. Normal MIN function is not working.
Thanks in advance
kannanr03,
Give this array formula a try. Note that array formulas must be confirmed with Ctrl+Shift+Enter and not just Enter. That will cause Excel to surround the formula in the curly braces {}, don't try to type those in manually.
{=MIN(IF(ISNUMBER(A1:A5),A1:A5))}
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It works perfectly.. Thank you so much..
@ kannanr03
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
@cutter
Sorry and thanks. I will look it after from now on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks