Filling of table based on horizontal & vertical data

H

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,226
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
I have data as follows being generated in 2 columns, column A & column B as below:
[TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]Age [/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Premium[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]56[/TD]
[TD="bgcolor: transparent, align: right"]4000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]32[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]45[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]29[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]35[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]37[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]48[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]54[/TD]
[TD="bgcolor: transparent, align: right"]4000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]78[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]90[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]33[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]43[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]75[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
</TBODY>[/TABLE]
In column E4:E10, premium is to generated in increasing order.
Based on Age (as 0 to 20, 0 & 20 punched in different cells), Total number of premium has to be filled as below.
For no filling, null ("") is required.

[TABLE="width: 528"]
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>[TR]
[TD="class: xl70, width: 64, bgcolor: transparent"]Premium[/TD]
[TD="class: xl66, width: 640, bgcolor: transparent, colspan: 10"]Age[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]40[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]60[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]61[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]80[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]81[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

How to accomplish?
Thanks in advance.
 
Sort by date Sort by votes
hsandeep said:
I have data as follows being generated in 2 columns, column A & column B as below:
[TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]Age [/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]Premium[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]56[/TD]
[TD="bgcolor: transparent, align: right"]4000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]32[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]45[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]29[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]35[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]37[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]48[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]54[/TD]
[TD="bgcolor: transparent, align: right"]4000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]78[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]90[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]3000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]33[/TD]
[TD="bgcolor: transparent, align: right"]2000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]43[/TD]
[TD="bgcolor: transparent, align: right"]1000[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]75[/TD]
[TD="bgcolor: transparent, align: right"]5000[/TD]
[/TR]
</TBODY>[/TABLE]
In column E4:E10, premium is to generated in increasing order.
Based on Age (as 0 to 20, 0 & 20 punched in different cells), Total number of premium has to be filled as below.
For no filling, null ("") is required.

[TABLE="width: 528"]
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>[TR]
[TD="class: xl70, width: 64, bgcolor: transparent"]Premium[/TD]
[TD="class: xl66, width: 640, bgcolor: transparent, colspan: 10"]Age[/TD]
[/TR]
[TR]
[TD="class: xl71, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]40[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]60[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]61[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]80[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]81[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

How to accomplish?
Thanks in advance.
Click to expand...

The easiest way is to make a pivot table.

Data -> Pivot Table

Set Premium as your rows, and Age as your columns.

If this doesn't work for you, let us know.
 
Upvote 0
Istead of Pivot Table, I want to do it with Excel functions & formulas. I am using Excel2007.
 
Upvote 0
Excel Workbook
ABCDEFGHIJKLMNO
1AgePremium
2205000PremiumAge
356400002021404160618081100
43230001000121  
54520002000211
62910003000111
735200040002
83710005000111
9485000
10544000
11783000
12902000
1311000
14153000
15332000
Sheet1
 
Upvote 0
A little change requested.
[TABLE="width: 525"]
<TBODY>[TR]
[TD]EMPLOYEE NAME</SPAN>[/TD]
[TD]RELATIONSHIP</SPAN>[/TD]
[TD]AGE</SPAN>[/TD]
[TD]Premium</SPAN>[/TD]
[TD]Effective Premium</SPAN>[/TD]
[/TR]
[TR]
[TD]ANANAD NARAYAN KADAM</SPAN>[/TD]
[TD]SELF</SPAN>[/TD]
[TD]47</SPAN>[/TD]
[TD]5000</SPAN>[/TD]
[TD]5000</SPAN>[/TD]
[/TR]
[TR]
[TD]ANANAD NARAYAN KADAM</SPAN>[/TD]
[TD]SPOUSE</SPAN>[/TD]
[TD]43</SPAN>[/TD]
[TD] [/TD]
[TD]5000</SPAN>[/TD]
[/TR]
[TR]
[TD]ANANAD NARAYAN KADAM</SPAN>[/TD]
[TD]SON</SPAN>[/TD]
[TD]19</SPAN>[/TD]
[TD] [/TD]
[TD]5000</SPAN>[/TD]
[/TR]
[TR]
[TD]ANANAD NARAYAN KADAM</SPAN>[/TD]
[TD]SON</SPAN>[/TD]
[TD]17</SPAN>[/TD]
[TD] [/TD]
[TD]5000</SPAN>[/TD]
[/TR]
[TR]
[TD]SUNIL R BOBDE</SPAN>[/TD]
[TD]SELF</SPAN>[/TD]
[TD]50</SPAN>[/TD]
[TD]4000</SPAN>[/TD]
[TD]4000</SPAN>[/TD]
[/TR]
[TR]
[TD]SUNIL R BOBDE</SPAN>[/TD]
[TD]SPOUSE</SPAN>[/TD]
[TD]46</SPAN>[/TD]
[TD] [/TD]
[TD]4000</SPAN>[/TD]
[/TR]
[TR]
[TD]SUNIL R BOBDE</SPAN>[/TD]
[TD]DAUGHTER</SPAN>[/TD]
[TD]21</SPAN>[/TD]
[TD] [/TD]
[TD]4000</SPAN>[/TD]
[/TR]
[TR]
[TD]SUNIL R BOBDE</SPAN>[/TD]
[TD]DAUGHTER</SPAN>[/TD]
[TD]15</SPAN>[/TD]
[TD] [/TD]
[TD]4000</SPAN>[/TD]
[/TR]
[TR]
[TD]ARVIND S. VITEKAR</SPAN>[/TD]
[TD]SELF</SPAN>[/TD]
[TD]38</SPAN>[/TD]
[TD]1000</SPAN>[/TD]
[TD]1000</SPAN>[/TD]
[/TR]
[TR]
[TD]ARVIND S. VITEKAR</SPAN>[/TD]
[TD]SPOUSE</SPAN>[/TD]
[TD]31</SPAN>[/TD]
[TD] [/TD]
[TD]1000</SPAN>[/TD]
[/TR]
[TR]
[TD]ARVIND S. VITEKAR</SPAN>[/TD]
[TD]SON</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD] [/TD]
[TD]1000</SPAN>[/TD]
[/TR]
[TR]
[TD]ARVIND S. VITEKAR</SPAN>[/TD]
[TD]SON</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD] [/TD]
[TD]1000</SPAN>[/TD]
[/TR]
[TR]
[TD]ANANAD NARAYAN KADAM</SPAN>[/TD]
[TD]SON</SPAN>[/TD]
[TD]46</SPAN>[/TD]
[TD] [/TD]
[TD]5000</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL span=2></COLGROUP>[/TABLE]
Effective premium column=Premium of EMPLOYEE NAME.
Now to make the table with ageband 1-20, 21-40, 41-60, 61-80, 81-100.
How to do? I am using Excel2007.
 
Upvote 0
[TABLE="width: 528"]
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]Effective[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Ageband[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]Premium[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]40[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]41[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]60[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]61[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]80[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]81[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]100[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5000[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
prevent message box from copying from userform to sheet based on matching missed month.
Replies
0
Views
74
Ali M
A
V
  • Solved
Suitable formula needed
2
Replies
16
Views
477
Joe4
Joe4
K
  • Solved
Sum data with multiple criteria
Replies
4
Views
81
Fluff
Fluff
O
  • Solved
show data on userform vertically based on combobox for multiple ranges
Replies
2
Views
161
Omran Y
O
A
  • Solved
add formulas in last column after sorting for each duplicates ID
Replies
9
Views
195
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

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