| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for copying a value in a cell until that value changes
I don't know if this is possible but here goes.
I have exported data into excel and in column D there are identifiers i.e. "IN" & "OUT". In column A there are items that fit into these categories, but the items switch back and forth between the two. There will be 20 items that are "IN" with the "IN" appearing in just the first items row and doesn't change until there are "OUT" items. This switches back and forth. Is there a formula that can copy the identifier on every row until it changes, so that every row has a label of IN or OUT? Am i making sense? Please help! -- Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell formula newbie. Thank You | Excel Discussion (Misc queries) | |||
| Copying formula from one cell to another with absolute value in it | Excel Discussion (Misc queries) | |||
| copying formula to another cell | Excel Discussion (Misc queries) | |||
| How do I copy the value from a cell without copying the formula? | Excel Worksheet Functions | |||
| How do I keep one cell constant in a formula even when copying | Excel Discussion (Misc queries) | |||
Threaded Mode
