Hi guys,
Just wondered how I could manipulate the following formula, so that rather than looking for "max", it tells me the placement of the 1st figure which is above (i.e. 1%)
UAFaQUcuRg_HiKU3cAdoXg.png
Using "above 1%", would mean in this example 5 is the value (BK2)
Hope that's clear enough, any questions feel free to ask
Thanks, Mdn
Last edited by Median; 02-18-2018 at 06:35 PM.
title updated....
Last edited by protonLeah; 02-18-2018 at 07:23 PM.
Ben Van Johnson
Try this ...
=INDEX($BJ$1:$BP$1,MATCH(TRUE,INDEX(BJ2:BP2>1,0),0))
Hi Phuo, had a go but couldn't quite get it to work.
This might help (small spreadsheet attached). I've also added what the first few values should be in column I
Try again
7-MATCH(TRUE,INDEX(A2:G2>1%,0),0)
I just stumbled upon something like this... I had a limit and had to find the first number above the specified limit.
What I did was using a MINIFS formula.
That min_range is the whole data set, the criteria1_range was again the whole data set and the criteria1 was ">x", where "x" is the limit value.
The end result was something like =MINIFS($A:$A;$A:$A;">"&$C:$1) and the cell C1 is where my limit was.
Hope it helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks