Author: Oscar Cronquist Article last updated on August 13, 2018

Question: I have a text name coloumn, there will be only 1 value to be listed in 1 coloumn in any cell i want tha the text come to be on top of coloum like we use the =min formula for a coloumn values in numaric data

like if data is numaric we put formula =MIN(E5:E20) but in this case datais text


Answer: I am not sure I understand but I will try to give you an answer.


Array formula in A1:

=INDEX(A1:A100, MIN(IF(ISBLANK(A2:A100), "", ROW(A2:A100)))) + CTRL + SHIFT + ENTER

copied right as far as needed.

Functions in this article:

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

Returns the smallest number in a set of values. Ignores logical values and text

ROW(reference) returns the rownumber of a reference

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

Checks whether a reference is to an empty cell and returns TRUE or FALSE