We don't need you to post the solution, we need you to post the links to the threads you started in other forums... I found a couple already. It is not fair to the people to not know you have posted elsewhere and possibly have received a solution already. They helpers are not here to waste their time if you have a solution, they are to help if you don't.




By the way, I gave you a solution here: https://www.ozgrid.com/forum/forum/h...ow-a-threshold

https://www.mrexcel.com/forum/excel-...ml#post5077811

https://www.excelguru.ca/forums/show...ow-a-threshold

https://www.ozgrid.com/forum/forum/h...ow-a-threshold

https://www.excelguru.ca/forums/show...ed=1#post37149

https://www.mrexcel.com/forum/excel-...-criteria.html

https://superuser.com/questions/1327...980266_1327146

https://www.msofficeforums.com/newre...ote=1&p=129061

Thanks for this:
Try Array* formula:

=MATCH(MAX(FREQUENCY(IF(A2:N2<P2,COLUMN(A2:N2)),IF (A2:N2>P2,COLUMN(A2:N2)))),FREQUENCY(IF(A2:N2<P2,C OLUMN(A2:N2)),IF(A2:N2>P2,COLUMN(A2:N2))),0)

I'm applying it to my larger dataset to see if it works (it works for the example given).

Thank you for taking the time to look at this. This worked for my initial example given but not for my larger dataset (example attached).

Attached Files

Example.xlsx (10.0 KB, 13 views)