| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula that selects value from list in sequence order
I have a series of text data entries in P5:P149.
I also have data in some of the cells in Column I. In Column K, I want to select the data from Column P in sequential order, IF there is data in Column I. If there is not data in Column I, I want it to advance to the next time data appears in Column I, without skipping the selection order of Column P. Hope that makes sense? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for formula that selects last value entered in a column? | Excel Worksheet Functions | |||
| 2 part macro question (sequence & order) | Excel Worksheet Functions | |||
| Is there an formula to reverse the order of a number sequence? | Excel Discussion (Misc queries) | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| How do I reverse the order (sequence) of a column of data in Excel | Excel Worksheet Functions | |||
Threaded Mode
