Hi All,
In one worksheet I have the relative strength (RS) calculations of a basket of stocks, and their percentile rank (example below). How would I generate a list in a different worksheet with the symbols that meet the criteria (ie the 4th column of the example). So on the separate page I basically want the heading to be "selection" in column A1, Stock E in A2, Stock H in A3, and Stock J in A4. If the RS changes and more or less stocks meet the criteria, the "Selection" worksheet ie column A would have more or less values accordingly in chronological order. Thanks so much for the help!
The only way I can think of doing this is have some sort of macro to look up the value in D2 of the example and then if there is no value look in D3. If there is a value paste in A2 of the Selection work page if that cell is blank if not paste in the next available cell. But this seems really complicated and I do not know how to go about doing this. There must be an easier way!
Bookmarks