Minimum search in the next 15 entries
I have a table with 2 by n entries.
On the 1st column I have continuous values on the 2nd they're random.
I want to search the minimum value on the 15 entries on the left after each entry on the righ.
The range can't contain the value on the left to the random entry.
Can anyone help?
Not until you're a little clearer. Can you attach an example workbook?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I think I know what you are trying to do. This should do the trick if not I agree with Chemist you need to upload sample data with expected results.
=INDEX(B14:B19,MATCH(MIN(A14:A19),A14:A19,0))
hope this helps to show my problem
SOLVED
stupid question... long hours
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks