Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Howdy,
I sure would love some help. I have a list of 400 stocks on one page of an excel spreadsheet. I have one cell for each symbol set to say "Buy" when it meets certain criteria. In another spread sheet, one that would appear blank at first, I would like to have it make a moving list of the symbols when they say "Buy". Example: Symbol IBM meets my criteria, in cell A1 on page 1 it says "Buy".. then on page 2 the symbol IBM pops up. Ten minutes later cell CC meets my criteria and says "Buy", I would like the symbol to appear before IBM on page 2 and push IBM from spot A1 to spot A2.... After half and hour I have 35 symbols that have met my criteria with the latest one that met my criteria in position A1 with the rest fo the symbols following that symbol..A2, A3,A4 and so forth... Would really help if I could figure this out...Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
sort list of players by team from player list on separate sheet | Excel Worksheet Functions |