Attempting to sort and count data

  • Thread starter Thread starter Sixgill
  • Start date Start date
S

Sixgill

Hi there,

i have 2 columns of data, 8 to 9 thousand entries per column, i woul
like to filter the columns and then count the filtered cells.

example:

Column one is Speed (0-35 cm/sec)
Column two is Direction (0-360 degrees)

i would like to sort column one for all entries between 0 & 3 cm/sec
and then sort column 2 for entries between 0 & 15 degrees, then i woul
like to count the results and paste the number to a seperate cell i
another work sheet.

Note column 1 & 2 are organized by a time stamp in a seperate column.

thank
 
I don't think that you searched newsgroups for previous
solutions. Many questions on filtering can be answered
on Debra Dalgleish's site contextures.com look for tips
for a table of contents and then filters.

You can do a search of excel newsgroups from
http://google.com/advanced_group_search?q=group:*Excel*&num=100

Search for all words: count +filtered

In fact Debra provided the following reply within the last week.
http://google.com/[email protected]


both using SUBTOTAL variations depending on How you want
to count them.l
 
Back
Top