LinkBack URL
About LinkBacks
Hi forum ,
Would be appreciate if you can help me to solve this issue,
Please see attached file,
Thanks,
robert
Compared Cell in multiple column and find min
Hi forum ,
Would be appreciate if you can help me to solve this issue,
Please see attached file,
Thanks,
robert
Your sample is a bit confusing. The range you are asking for is A2:E2 for everything. I'm assuming that the range should change to the appropriate row number? If so, you can use the MIN function to find the minimum values in the number cells. MIN will automatically ignore blank cells. So, if my assumption is correct, then put this in F3..
Not sure how to get the NOTTEST part of it though.
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks gmr4 for quick advise ,
Just correct file,
Thanks,
robert
Hello forum,
I found the function for this but how can we write a code for this:
{=IF(SUMPRODUCT(ISNUMBER(A2:E2)*1)>0,MIN(A2:E2),A2)}
Thanks,
robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks