## Text to be on top of column in excel

*Article updated on December 06, 2010*

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

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

Create a list of dates with blanks between quarters in excel

Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]How to create random numbers, text strings, dates and time values

In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]### 4 Responses to “Text to be on top of column in excel”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

Here is a slightly shorter formula which uses two less function calls (still needs to be array entered using Ctrl+Shift+Enter to commit it)...

=INDEX(A:A,MAX(ROW(A2:A100)*(A2:A100"")))

Rick Rothstein (MVP - Excel),

I can´t get your formula to work?

Thanks!

It looks like your Comments interface "ate" the not-equal-sign (less than symbol followed by a greater than symbol) apparently trying to interpret it as an html tag indicator of some kind. Anyway, use my formula as shown, but put a not-equal-sign between the last A100 and the ""... the last item is supposed to read "A2:A100 not equal to the empty string".

Rick Rothstein (MVP - Excel),

Thanks for your explanation!