Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting rows based on multiple values
I have a spreadsheet which I need to return record counts based upon the row
containing any of 10 values in Column E. To make it worse, for a different count, I will need to consder a subset of values in Column E as well. I will need to do multiple variations of this tp establish a variety of metrics. Yes, DB would be better, but not available to me. I am just above the novice level. What VBA functions should I consider? Is this a good use for an array? If so, some tips would be helpful. Or is there a better (easier) approach? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows based on the contents of multiple cells | Excel Worksheet Functions | |||
Counting values based on multiple conditions | Excel Worksheet Functions | |||
Counting rows based on multiple columns | Excel Worksheet Functions | |||
counting rows with same values for multiple values | New Users to Excel | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |