| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
| Counting Data in a Column | Excel Worksheet Functions | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Hybrid Mode
