I need a list created in an excell spreadsheet.
I am watching a group of stocks. I have IF functions that tell me when a stock meets my criteria. I want a list created that takes stocks that meet my criteria and put them in order by which they met my criteria.
In the L and M columns of my work sheet the cell will read "go" when it meets my criteria and "don't go" when it doesn't meet my criteria. When stock symbols, located in A column meet my criteria, I want them to be put in a list ...preferably in another worksheet.
Example: Say stock IBM is the first stock of the day to meet my criteria and it's cell L1 says "go", I then want IBM to be put in a list in the cell position A1 of the new worksheet... two minutes later stock BSC meets my criteria and its L or M cell says "go", I then want it to be put into the list in position A1. IBM would then slide to A2. 5 mintues later stock symbol HOT turns "go", I then want HOT to go into position A1 of the list and BSC will move to A2 and IBM will move to A3.. this will continue all day as more and more stocks meet my criteria and thier cells turn to "go".
I need to have some sort of sound go off each time a stock is added to the list.. an alert or alarm.
That is it... realatively pretty simple, just more then I know how to do.