| 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. |
|
#2
|
|||
|
|||
|
Hi
why not copy it. The row index will change automatically -- Regards Frank Kabel Frankfurt, Germany "L/P" schrieb im Newsbeitrag ... 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. |
|
#3
|
|||
|
|||
|
Figured it out, copy that is..
Thanks, L. "Frank Kabel" wrote in message ... Hi why not copy it. The row index will change automatically -- Regards Frank Kabel Frankfurt, Germany "L/P" schrieb im Newsbeitrag ... 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. |
| Reply |
| 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 | |||
Linear Mode
