formula for merged cells

shahsavand

Board Regular
Joined
Dec 8, 2014
Messages
74
hi all i have a column with 15 rows merged cells and i need a formula to link each 15 merged cell from other sheets of single cell.
thanks
 

Attachments

  • 2024-04-15_9-21-01.jpg
    2024-04-15_9-21-01.jpg
    36.1 KB · Views: 13

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
@shahsavand it's not entirely clear to me what you are wanting.

If you are wanting Sheet1A1: A? to appear in a series of 15 rows deep merged cells then maybe like below.

Picking Teams.xlsm
A
1From Sheet1 A1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16From Sheet1 A2
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Test (2)
Cell Formulas
RangeFormula
A1,A16A1=OFFSET(Sheet1!A1,-QUOTIENT(ROW(),15)*14,)


If that is not what you require then please try and clarify.
Also, it will help someone to help you if you could clarify what version of Excel you are using.
 
Upvote 0
@shahsavand it's not entirely clear to me what you are wanting.

If you are wanting Sheet1A1: A? to appear in a series of 15 rows deep merged cells then maybe like below.

Picking Teams.xlsm
A
1From Sheet1 A1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16From Sheet1 A2
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Test (2)
Cell Formulas
RangeFormula
A1,A16A1=OFFSET(Sheet1!A1,-QUOTIENT(ROW(),15)*14,)


If that is not what you require then please try and clarify.
Also, it will help someone to help you if you could clarify what version of Excel you are using.
thank you brother. it worked properly . also i found another solution with =INDEX(Sheet2!$A$1:$A$203,COUNTA(A$2:A2))
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top