More info. Your OP asked to determine TEXT in a column. In the future,
ALWAYS state your requirement in the FIRST post so time is not wasted. I
don't understand what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"crapit" wrote in message
...
Pls ignore the worksheet Qs. If I need to use the min and max in a range
e.g sum('abc ge'!a3:a33), where a3 is the value in MIN array and a33 in
MAX array,is that possible

"crapit" wrote in message
...
If the reference is in another worksheet, can I just change to
=MIN(IF("abc num"(A2:A21)="a",ROW("abc num"(A2:A21))))
"Don Guillett" wrote in message
...
This is an Array formula that could be put anywhere on the worksheet. It
refers to the indicated range.
Instead of entering/editing with just ENTER, hold down the ctrl & shift
keys and touch enter at the same time.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"crapit" wrote in message
...
do i need to put the array across the same row
"Don Guillett" wrote in message
...
Array enter
=MIN(IF(A2:A21="a",ROW(A2:A21)))
=Max(IF(A2:A21="a",ROW(A2:A21)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"crapit" wrote in message
...
From a column e.g "A"
How to determine the 1st cell and the last cell that contain a
specific word?

A B C
1
2 grp
3 grp
4
5 grp
6
7 hex
8 hex
9 hex
10 grp
11 grp