counting data in a column

  • Thread starter 請大家指點迷津
  • Start date
È

請大家指點迷津

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
 
M

Morgan

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.
 
Top