Hi,
I have an unsorted range of values in a column. From that range I want to determine the position (row) in which the a particular value is exceeded for the first time. The correct value in the attached example is 5 (corresponding to value 84.7). Any suggestions to cure my blind spot?ExcelForumQuestion.xlsx
welcome to the forum. try:
=MATCH(TRUE,INDEX(TestRange>ThresholdValue,),0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Benishiryo,
That solution worked but I had to make one adjustment to the data. Initially I had some "~" as observations in the data set. That meant that in some circumstances your solution did not work correctly (I did not discover why). But, once the ~ was removed, the solution worked. Thanks for your prompt response.
Cheers
you're welcome. if the tilda (~) is really there, try:
=MATCH(1,INDEX((TestRange>ThresholdValue)*(ISNUMBER(TestRange)),),0)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks