Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large worksheet and hate to use the fill down for this.
Here's my scenario: In column A there are different values. Examples: ADJ, REFUND, TUI, STE, BKS, etc. In column B, I need there to be an A or an E depending on which value is in column A. So, if ADJ, TUI or STE are in column A, an A would go in column B. If the value in Column A is REFUND or BKS, then E would go in Column B. Any suggestions on how to make this work? Thanks! -- Jess |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |