| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy values in more cells
Hi,
I have a column with cells merged at groups of 8. in the column next to it i would like to have a formula that copy the value of the merged cells (that would be the first one of each group as if i do umerged the value is always on the top one) not sure i can make myself to clear about this. see table below (in the example I made groups of 3 instead 8) A B C 1”‚ z z 2”‚ z 3”‚ z 4”‚ k k 5”‚ k 6”‚ k 7”‚0 0 8”‚ 0 9”‚ 0 where column A contains the merged cells in groups of 3 (1 to 3, 4 to 6, 7to 9) and column B contains the formula that copy from column A. any idea of how to do this? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy values in more cells
In the first cell in B (at B1) put the formula =A1
In B2 put =IF(A2="",B1,A2) and fill that second formula down the column. "massi" wrote: Hi, I have a column with cells merged at groups of 8. in the column next to it i would like to have a formula that copy the value of the merged cells (that would be the first one of each group as if i do umerged the value is always on the top one) not sure i can make myself to clear about this. see table below (in the example I made groups of 3 instead 8) A B C 1”‚ z z 2”‚ z 3”‚ z 4”‚ k k 5”‚ k 6”‚ k 7”‚0 0 8”‚ 0 9”‚ 0 where column A contains the merged cells in groups of 3 (1 to 3, 4 to 6, 7to 9) and column B contains the formula that copy from column A. any idea of how to do this? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy values in more cells
works fine.
thanks a lot! "JLatham" wrote: In the first cell in B (at B1) put the formula =A1 In B2 put =IF(A2="",B1,A2) and fill that second formula down the column. "massi" wrote: Hi, I have a column with cells merged at groups of 8. in the column next to it i would like to have a formula that copy the value of the merged cells (that would be the first one of each group as if i do umerged the value is always on the top one) not sure i can make myself to clear about this. see table below (in the example I made groups of 3 instead 8) A B C 1”‚ z z 2”‚ z 3”‚ z 4”‚ k k 5”‚ k 6”‚ k 7”‚0 0 8”‚ 0 9”‚ 0 where column A contains the merged cells in groups of 3 (1 to 3, 4 to 6, 7to 9) and column B contains the formula that copy from column A. any idea of how to do this? thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy values in more cells
You're welcome.
"massi" wrote: works fine. thanks a lot! "JLatham" wrote: In the first cell in B (at B1) put the formula =A1 In B2 put =IF(A2="",B1,A2) and fill that second formula down the column. "massi" wrote: Hi, I have a column with cells merged at groups of 8. in the column next to it i would like to have a formula that copy the value of the merged cells (that would be the first one of each group as if i do umerged the value is always on the top one) not sure i can make myself to clear about this. see table below (in the example I made groups of 3 instead 8) A B C 1”‚ z z 2”‚ z 3”‚ z 4”‚ k k 5”‚ k 6”‚ k 7”‚0 0 8”‚ 0 9”‚ 0 where column A contains the merged cells in groups of 3 (1 to 3, 4 to 6, 7to 9) and column B contains the formula that copy from column A. any idea of how to do this? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy values available in different cells of a column into d | Excel Discussion (Misc queries) | |||
| How can I copy the values of all selected cells to the same cells inanother Sheet | Excel Programming | |||
| How do I copy only values of cells when they are enterd? | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy same values to several cells | Excel Discussion (Misc queries) | |||
![massi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
