Hello:
I am using below formula without any problem.
This formula picks up the value in column P at cell P181.
Please Login or Register to view this content.
However, I need to modify the formula so to pick up the lowest value from cell range P181:P211.
Let me know if you have any questions.
Thanks.
Riz
can you upload a sample? hard to be certain what you're asking... but I think if you throw a min() in there and add a "height" component to your offset formula that should get you on the right track... as for defining height, based on the information you provided it sounds like it could just be 30... but if there's some logic to that number we'll need to see the sheet (or something similar) to make it work.
something like:
Formula:
Please Login or Register to view this content.
(untested...)
Last edited by simarui; 08-08-2014 at 11:31 AM. Reason: added a formula example
Maybe this?
=IFNA(OFFSET($O181,0,MATCH(MIN($P$3:$EG$3),$P$3:$EG$3,0)),0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this...
Formula:Please Login or Register to view this content.
Don't forget to click *
Hello:
It loks like Simari's formula works..
Thanks a lot to all for helping.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks