
05-30-2018, 06:31 AM
|
Novice
|
|
Join Date: May 2018
Posts: 5
|
|
Quote:
Originally Posted by NBVC
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
|
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).
|