| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative references
How do I write the formula to replace data that occurs in every 46th
row in col B (for example, in B1, B47, etc) with data that occurs in every row in Col C (for example, in C1, C2, etc)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative references
I assume you have data all the way down column B. So I assume you were planning to manually go to each 46th row, and then want to paste a standard formula into the cell. It would be better to use a macro. Here it is for you. http://members.optusnet.com.au/~alli...es/replace.xls Matt -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=552712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
| Confused about relative references in named formulas | Excel Worksheet Functions | |||
| Averaging using relative references across sheets | Excel Discussion (Misc queries) | |||
| How can I enable the "Record Using Relative References" option in. | Excel Discussion (Misc queries) | |||
Linear Mode
