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:
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