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.

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

MIN(number1,[number2])
Returns the smallest number in a set of values. Ignores logical values and text

ROW(reference) returns the rownumber of a reference

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

ISBLANK(value)
Checks whether a reference is to an empty cell and returns TRUE or FALSE