counting data in a column
 

I used a match() function to find out a specified data in a range, and it
replied a number. Let's say I got 3(column or row). Is there any way to know
how many data in the column 3(or row 3) by using counta() or any other
function, except VBA.
Thanks for any help

counting data in a column
 

Have a look in the help index for COUNTIF and SUMIF
--
Don Guillett
SalesAid Software

"???????" wrote in message
...
I used a match() function to find out a specified data in a range, and it
replied a number. Let's say I got 3(column or row). Is there any way to
know
how many data in the column 3(or row 3) by using counta() or any other
function, except VBA.
Thanks for any help

counting data in a column
 

Sorry, I did not make my question clear. Actually, I am trying to use a
function in Data Validation like below.
=OFFSET(StartCell,1,MATCH(B3,NameList,0)-1,ROWS(Num))
Where the Num is what I really want to count for the validation list.
Because there are different numbers of name in each columns within NameList.
So, what function can I use to take the place of Num.

"Don Guillett" wrote:

Have a look in the help index for COUNTIF and SUMIF
--
Don Guillett
SalesAid Software

"???????" wrote in message
...
I used a match() function to find out a specified data in a range, and it
replied a number. Let's say I got 3(column or row). Is there any way to
know
how many data in the column 3(or row 3) by using counta() or any other
function, except VBA.
Thanks for any help