Extracting Rows Based on a Filter

G

G1511

New Member
Joined
May 19, 2017
Messages
3
Hi,

I'd like to extract specific cells from a table like the sample one below based on the sample type in column 1. I have also provided a sample output below. Basically, I want a final table where I can classify some columns based on the types separately. What formulae can I use for achieving such an output?

Sample Data:
[TABLE="class: grid, width: 542"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Type[/TD]
[TD]Data Point 1[/TD]
[TD]Data Point 2[/TD]
[TD]Data Point 3[/TD]
[TD]Data Point 4[/TD]
[TD]Data Point 5[/TD]
[TD]Data Point 6[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]42[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]66[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]72[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]78[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]84[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]96[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[/TR]
</tbody>[/TABLE]

Sample Output:
[TABLE="class: grid, width: 316"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD="colspan: 4, align: center"]Type A[/TD]
[/TR]
[TR]
[TD="align: center"]Data Point 3[/TD]
[TD="align: center"]Data Point 6[/TD]
[TD="align: center"]Data Point 1[/TD]
[TD="align: center"]Data Point 5[/TD]
[/TR]
[TR]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 4, align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: center"]Data Point 3[/TD]
[TD="align: center"]Data Point 6[/TD]
[TD="align: center"]Data Point 1[/TD]
[TD="align: center"]Data Point 5[/TD]
[/TR]
[TR]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 4, align: center"]Type C[/TD]
[/TR]
[TR]
[TD="align: center"]Data Point 3[/TD]
[TD="align: center"]Data Point 6[/TD]
[TD="align: center"]Data Point 1[/TD]
[TD="align: center"]Data Point 5[/TD]
[/TR]
[TR]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 4, align: center"]Type D[/TD]
[/TR]
[TR]
[TD="align: center"]Data Point 3[/TD]
[TD="align: center"]Data Point 6[/TD]
[TD="align: center"]Data Point 1[/TD]
[TD="align: center"]Data Point 5[/TD]
[/TR]
[TR]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
</tbody>[/TABLE]

Thanks much in advance!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
You really show what you expect here, just the layout of what you want, but mayb e this?
[Table="width:, class:grid"][tr][td] [/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][td]
D​
[/td][td]
E​
[/td][td]
F​
[/td][td]
G​
[/td][/tr]
[tr][td]
1​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
2​
[/td][td]Sample Data:[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
3​
[/td][td]Type[/td][td]Data Point 1[/td][td]Data Point 2[/td][td]Data Point 3[/td][td]Data Point 4[/td][td]Data Point 5[/td][td]Data Point 6[/td][/tr]

[tr][td]
4​
[/td][td]A[/td][td]
1​
[/td][td]
2​
[/td][td]
3​
[/td][td]
4​
[/td][td]
5​
[/td][td]
6​
[/td][/tr]

[tr][td]
5​
[/td][td]B[/td][td]
7​
[/td][td]
8​
[/td][td]
9​
[/td][td]
10​
[/td][td]
11​
[/td][td]
12​
[/td][/tr]

[tr][td]
6​
[/td][td]C[/td][td]
13​
[/td][td]
14​
[/td][td]
15​
[/td][td]
16​
[/td][td]
17​
[/td][td]
18​
[/td][/tr]

[tr][td]
7​
[/td][td]D[/td][td]
19​
[/td][td]
20​
[/td][td]
21​
[/td][td]
22​
[/td][td]
23​
[/td][td]
24​
[/td][/tr]

[tr][td]
8​
[/td][td]E[/td][td]
25​
[/td][td]
26​
[/td][td]
27​
[/td][td]
28​
[/td][td]
29​
[/td][td]
30​
[/td][/tr]

[tr][td]
9​
[/td][td]A[/td][td]
31​
[/td][td]
32​
[/td][td]
33​
[/td][td]
34​
[/td][td]
35​
[/td][td]
36​
[/td][/tr]

[tr][td]
10​
[/td][td]C[/td][td]
37​
[/td][td]
38​
[/td][td]
39​
[/td][td]
40​
[/td][td]
41​
[/td][td]
42​
[/td][/tr]

[tr][td]
11​
[/td][td]B[/td][td]
43​
[/td][td]
44​
[/td][td]
45​
[/td][td]
46​
[/td][td]
47​
[/td][td]
48​
[/td][/tr]

[tr][td]
12​
[/td][td]E[/td][td]
49​
[/td][td]
50​
[/td][td]
51​
[/td][td]
52​
[/td][td]
53​
[/td][td]
54​
[/td][/tr]

[tr][td]
13​
[/td][td]D[/td][td]
55​
[/td][td]
56​
[/td][td]
57​
[/td][td]
58​
[/td][td]
59​
[/td][td]
60​
[/td][/tr]

[tr][td]
14​
[/td][td]B[/td][td]
61​
[/td][td]
62​
[/td][td]
63​
[/td][td]
64​
[/td][td]
65​
[/td][td]
66​
[/td][/tr]

[tr][td]
15​
[/td][td]B[/td][td]
67​
[/td][td]
68​
[/td][td]
69​
[/td][td]
70​
[/td][td]
71​
[/td][td]
72​
[/td][/tr]

[tr][td]
16​
[/td][td]A[/td][td]
73​
[/td][td]
74​
[/td][td]
75​
[/td][td]
76​
[/td][td]
77​
[/td][td]
78​
[/td][/tr]

[tr][td]
17​
[/td][td]C[/td][td]
79​
[/td][td]
80​
[/td][td]
81​
[/td][td]
82​
[/td][td]
83​
[/td][td]
84​
[/td][/tr]

[tr][td]
18​
[/td][td]C[/td][td]
85​
[/td][td]
86​
[/td][td]
87​
[/td][td]
88​
[/td][td]
89​
[/td][td]
90​
[/td][/tr]

[tr][td]
19​
[/td][td]C[/td][td]
91​
[/td][td]
92​
[/td][td]
93​
[/td][td]
94​
[/td][td]
95​
[/td][td]
96​
[/td][/tr]

[tr][td]
20​
[/td][td]E[/td][td]
97​
[/td][td]
98​
[/td][td]
99​
[/td][td]
100​
[/td][td]
101​
[/td][td]
102​
[/td][/tr]
[/table]
[Table="width:, class:grid"][tr][td] [/td][td]
J​
[/td][td]
K​
[/td][td]
L​
[/td][td]
M​
[/td][/tr]
[tr][td]
2​
[/td][td]Type A[/td][td][/td][td][/td][td][/td][/tr]

[tr][td]
3​
[/td][td]
Data Point 3​
[/td][td]
Data Point 6​
[/td][td]
Data Point 1​
[/td][td]
Data Point 5​
[/td][/tr]

[tr][td]
4​
[/td][td]
3​
[/td][td]
6​
[/td][td]
1​
[/td][td]
5​
[/td][/tr]

[tr][td]
5​
[/td][td]
​
[/td][td]
​
[/td][td]
​
[/td][td]
​
[/td][/tr]
[/table]
J4=IFERROR(INDEX($B$4:$G$20,MATCH(RIGHT($J$2,1),$A$4:$A$20,0),MATCH(J$3,$B$3:$G$3,0)),"")
copied across.

Change the reference in RIGHT($J$2,1) for the other tables
 
Upvote 0
FDibbins said:
You really show what you expect here, just the layout of what you want, but mayb e this?
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]
A​
[/TD]
[TD]
B​
[/TD]
[TD]
C​
[/TD]
[TD]
D​
[/TD]
[TD]
E​
[/TD]
[TD]
F​
[/TD]
[TD]
G​
[/TD]
[/TR]
[TR]
[TD]
1​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
2​
[/TD]
[TD]Sample Data:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
3​
[/TD]
[TD]Type[/TD]
[TD]Data Point 1[/TD]
[TD]Data Point 2[/TD]
[TD]Data Point 3[/TD]
[TD]Data Point 4[/TD]
[TD]Data Point 5[/TD]
[TD]Data Point 6[/TD]
[/TR]
[TR]
[TD]
4​
[/TD]
[TD]A[/TD]
[TD]
1​
[/TD]
[TD]
2​
[/TD]
[TD]
3​
[/TD]
[TD]
4​
[/TD]
[TD]
5​
[/TD]
[TD]
6​
[/TD]
[/TR]
[TR]
[TD]
5​
[/TD]
[TD]B[/TD]
[TD]
7​
[/TD]
[TD]
8​
[/TD]
[TD]
9​
[/TD]
[TD]
10​
[/TD]
[TD]
11​
[/TD]
[TD]
12​
[/TD]
[/TR]
[TR]
[TD]
6​
[/TD]
[TD]C[/TD]
[TD]
13​
[/TD]
[TD]
14​
[/TD]
[TD]
15​
[/TD]
[TD]
16​
[/TD]
[TD]
17​
[/TD]
[TD]
18​
[/TD]
[/TR]
[TR]
[TD]
7​
[/TD]
[TD]D[/TD]
[TD]
19​
[/TD]
[TD]
20​
[/TD]
[TD]
21​
[/TD]
[TD]
22​
[/TD]
[TD]
23​
[/TD]
[TD]
24​
[/TD]
[/TR]
[TR]
[TD]
8​
[/TD]
[TD]E[/TD]
[TD]
25​
[/TD]
[TD]
26​
[/TD]
[TD]
27​
[/TD]
[TD]
28​
[/TD]
[TD]
29​
[/TD]
[TD]
30​
[/TD]
[/TR]
[TR]
[TD]
9​
[/TD]
[TD]A[/TD]
[TD]
31​
[/TD]
[TD]
32​
[/TD]
[TD]
33​
[/TD]
[TD]
34​
[/TD]
[TD]
35​
[/TD]
[TD]
36​
[/TD]
[/TR]
[TR]
[TD]
10​
[/TD]
[TD]C[/TD]
[TD]
37​
[/TD]
[TD]
38​
[/TD]
[TD]
39​
[/TD]
[TD]
40​
[/TD]
[TD]
41​
[/TD]
[TD]
42​
[/TD]
[/TR]
[TR]
[TD]
11​
[/TD]
[TD]B[/TD]
[TD]
43​
[/TD]
[TD]
44​
[/TD]
[TD]
45​
[/TD]
[TD]
46​
[/TD]
[TD]
47​
[/TD]
[TD]
48​
[/TD]
[/TR]
[TR]
[TD]
12​
[/TD]
[TD]E[/TD]
[TD]
49​
[/TD]
[TD]
50​
[/TD]
[TD]
51​
[/TD]
[TD]
52​
[/TD]
[TD]
53​
[/TD]
[TD]
54​
[/TD]
[/TR]
[TR]
[TD]
13​
[/TD]
[TD]D[/TD]
[TD]
55​
[/TD]
[TD]
56​
[/TD]
[TD]
57​
[/TD]
[TD]
58​
[/TD]
[TD]
59​
[/TD]
[TD]
60​
[/TD]
[/TR]
[TR]
[TD]
14​
[/TD]
[TD]B[/TD]
[TD]
61​
[/TD]
[TD]
62​
[/TD]
[TD]
63​
[/TD]
[TD]
64​
[/TD]
[TD]
65​
[/TD]
[TD]
66​
[/TD]
[/TR]
[TR]
[TD]
15​
[/TD]
[TD]B[/TD]
[TD]
67​
[/TD]
[TD]
68​
[/TD]
[TD]
69​
[/TD]
[TD]
70​
[/TD]
[TD]
71​
[/TD]
[TD]
72​
[/TD]
[/TR]
[TR]
[TD]
16​
[/TD]
[TD]A[/TD]
[TD]
73​
[/TD]
[TD]
74​
[/TD]
[TD]
75​
[/TD]
[TD]
76​
[/TD]
[TD]
77​
[/TD]
[TD]
78​
[/TD]
[/TR]
[TR]
[TD]
17​
[/TD]
[TD]C[/TD]
[TD]
79​
[/TD]
[TD]
80​
[/TD]
[TD]
81​
[/TD]
[TD]
82​
[/TD]
[TD]
83​
[/TD]
[TD]
84​
[/TD]
[/TR]
[TR]
[TD]
18​
[/TD]
[TD]C[/TD]
[TD]
85​
[/TD]
[TD]
86​
[/TD]
[TD]
87​
[/TD]
[TD]
88​
[/TD]
[TD]
89​
[/TD]
[TD]
90​
[/TD]
[/TR]
[TR]
[TD]
19​
[/TD]
[TD]C[/TD]
[TD]
91​
[/TD]
[TD]
92​
[/TD]
[TD]
93​
[/TD]
[TD]
94​
[/TD]
[TD]
95​
[/TD]
[TD]
96​
[/TD]
[/TR]
[TR]
[TD]
20​
[/TD]
[TD]E[/TD]
[TD]
97​
[/TD]
[TD]
98​
[/TD]
[TD]
99​
[/TD]
[TD]
100​
[/TD]
[TD]
101​
[/TD]
[TD]
102​
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]
J​
[/TD]
[TD]
K​
[/TD]
[TD]
L​
[/TD]
[TD]
M​
[/TD]
[/TR]
[TR]
[TD]
2​
[/TD]
[TD]Type A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
3​
[/TD]
[TD]
Data Point 3​
[/TD]
[TD]
Data Point 6​
[/TD]
[TD]
Data Point 1​
[/TD]
[TD]
Data Point 5​
[/TD]
[/TR]
[TR]
[TD]
4​
[/TD]
[TD]
3​
[/TD]
[TD]
6​
[/TD]
[TD]
1​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR]
[TD]
5​
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

J4=IFERROR(INDEX($B$4:$G$20,MATCH(RIGHT($J$2,1),$A$4:$A$20,0),MATCH(J$3,$B$3:$G$3,0)),"")
copied across.

Change the reference in RIGHT($J$2,1) for the other tables
Click to expand...


Hi FDibbins, thank you for your response!

I'm just showing the layout of my data since the data I have is confidential.

The solution you have given works if the values in Column 1 (Type) were unique but they are repetitive. So the result of your formula will give me the first value for Type A but I'd like a consolidated list of all the Type A values. Almost like what a PivotTable provides but I don't want to use Pivots.

Is there a solution for that?

Thanks!
 
Upvote 0
FDibbins said:
So you want the repeats summed? That's why I asked for some sample answers :)
Click to expand...

Yes, I need a summary table. Sorry for not giving out the answers earlier. I have added the same below. These I created using a Pivot and then breaking it apart and formatting it.

[TABLE="class: grid, width: 252"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 3, align: center"]Type A[/TD]
[/TR]
[TR]
[TD="align: center"]Data Point 2[/TD]
[TD="align: center"]Data Point 3[/TD]
[TD="align: center"]Data Point 5[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: center"]33[/TD]
[TD="align: center"]35[/TD]
[/TR]
[TR]
[TD="align: center"]74[/TD]
[TD="align: center"]75[/TD]
[TD="align: center"]77[/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]Type B[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]11[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]47[/TD]
[/TR]
[TR]
[TD="align: center"]62[/TD]
[TD="align: center"]63[/TD]
[TD="align: center"]65[/TD]
[/TR]
[TR]
[TD="align: center"]68[/TD]
[TD="align: center"]69[/TD]
[TD="align: center"]71[/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]Type C[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]17[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: center"]39[/TD]
[TD="align: center"]41[/TD]
[/TR]
[TR]
[TD="align: center"]80[/TD]
[TD="align: center"]81[/TD]
[TD="align: center"]83[/TD]
[/TR]
[TR]
[TD="align: center"]86[/TD]
[TD="align: center"]87[/TD]
[TD="align: center"]89[/TD]
[/TR]
[TR]
[TD="align: center"]92[/TD]
[TD="align: center"]93[/TD]
[TD="align: center"]95[/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]Type D[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]56[/TD]
[TD="align: center"]57[/TD]
[TD="align: center"]59[/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]Type E[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]29[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: center"]51[/TD]
[TD="align: center"]53[/TD]
[/TR]
[TR]
[TD="align: center"]98[/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]101[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
CountIfs Help
Replies
9
Views
131
Joe4
Joe4
M
  • Solved
Automate insertion of row data
2
Replies
12
Views
603
myall_blues
myall_blues
M
  • Solved
Dynamically Plot Data Points in Scatterplot
Replies
5
Views
681
felixstraube
F
S
  • Solved
Concatenate Numerous rows based off cells value
Replies
4
Views
338
hagia_sofia
hagia_sofia
H
  • Solved
Automatic copy new rows in sheet. Shooter contest.
Replies
8
Views
244
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,224,823
Messages
6,181,183
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

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