MDA - Market Direction Analysis Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : MDA - Market Direction Analysis

SPY 689.17

+0.2%

Dec 11 4:00 PM EST

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: HairBall who wrote ()	1/25/2000 2:30:00 PM
From: Sun Tzu	Read Replies (2) of 99985

OT -- Help with a formula...I have a large amount of stock data that I'd like to generate stats on. At the moment they are in MS Excel spread sheet. The problem is that when I run the Data-Analysis wizard, it fails with a message along the lines of "text data (or none-numeric data) in the range. This is because some of the cells are missing data points and are blank. I'd like to find a way to tell excel to simply exclude null data from its sample base. Does anyone know how to do this? There are too many rows and columns to manually set a filter on. And if possible, I do not want to limit myself to only those rows that have data in every column. I know this is not the forum for this question and I apologize. This is as likely a place to find a knowledgeable person as any. thanks, ST

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next