Hi everyone,
I am trying to find the minimum value in cell range J2:J70, I want this minimum value to appear in cell K2. However, if the number is negative then I do not want it to be taken into consideration. So I only want values zero and upwards to be considered. If you could help me out with some code that would be great! I want to be able to do this using VBA.
Thank you
Sarah
Formula:
Please Login or Register to view this content.
using array formula...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
in vba
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you so much! It works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks