Thread: Return column header from first cell from consecutive cells below a threshold
View Single Post
 
Old 05-30-2018, 06:31 AM
zara007 zara007 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: May 2018
Posts: 5
zara007 is on a distinguished road
Default
Quote:
Originally Posted by NBVC View Post
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).
Reply With Quote