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:

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

Related posts:

1. Create a list of all numbers or text in a column in excel
2. Unique list to be created from a column where an adjacent column has text cell values
3. Identify largest text value in a column using array formula in excel
4. Create a unique distinct text list from a range containing both numerical and text values in excel
5. Extract duplicate text values from a range containing both numerical and text values in excel
6. Filter unique text values from a range containing both numerical and text values in excel
7. Sum adjacent values using multiple lookup text values in a column in excel
8. Extract and sort text cells from a range containing both numerical and text values
9. Extract all rows from a range that meet criteria in one column in excel
10. Create unique distinct list from column where an adjacent column meets criteria