Posted to microsoft.public.excel.programming
|
|
count 1st cell and last cell that contain specific word
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
|