counting data in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
nth row or column counting 1
Counting NON-Blank fields 2
Excel VBA 1
Counting dates in columns in a linked spreadsheet 1
SUMPRODUCT - Tweak 2
counting data in columns with linked cells 4
Counting only displayed cells in the column 3

Back
Top