| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying formula to different cells
Have a sheet with 64 rows(accounts) and several columns.
Need to compare two columns and either place an "p" in 3rd column if column x - column y or "x" if not. No problem with formula,D3 =IF(C3=B3,"p","x") but how does one copy the formula without retyping formula in every cell down 64 rows? thanks, L. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
| Automatic copying data excluding blank cells | Excel Worksheet Functions | |||
| A formula to check differrent cells | Excel Worksheet Functions | |||
Threaded Mode
