I input the number 3
.
I want to find the first number in a 3x3
table for example, that is bigger than my 3
.
2 3 4
5 6 7
8 5 6
In this case, I want this formula to return 4
.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI input the number 3
.
I want to find the first number in a 3x3
table for example, that is bigger than my 3
.
2 3 4
5 6 7
8 5 6
In this case, I want this formula to return 4
.
You need this Array (CSE) formula:
I'm assuming that you have data in Range A1:C3
.
{=MIN(IF($A$1:$C$3>3,$A$1:$C$3))}
Finish formula with Ctrl+Shift+Enter.
Adjust cell references in the formula as needed.
For any size table:
=AGGREGATE(15,6,myRange*1/(myRange>3),1)
where myRange
is the cell reference to your table.