counting items in a range

  • Thread starter Thread starter WMMorgan
  • Start date Start date
W

WMMorgan

This looks like a good place to ask:

I am using a spreadsheet to organize 15 days' worth of stock market price
data.

Each day of data (row: symbol in text, low price, high price),
in column form, is a bit different from every other days' column of
data, because a handful of stocks are added or dropped on an almost
daily basis. Each day has more than 7000 stocks.

Problem: how do I sort out and discard all the stocks in a column that do NOT
appear in each and every of the other 14 days?

Though MS Works Spreadsheet is grossly inadequate for the task, there
is a way to do it (but it's time-consuming, involving a lot of cutting
and pasting and SORT and a choice formula or two).

Some shareware spreadsheets have COUNTIF, but I can't get the COUNTIF
to reference text (symbol) from another cell for its value. (Method:
count each symbol's occurence in the entire 15 days' range of data.
Discard every stock that occurs less than 15 times.)

Any ideas?
 
Hi
could you post some example data (plain text please - no attachment)
and describe your expected result. I think a SUMPRODUCT formula or a
pivot table is what you're looking for
 

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

Back
Top