# Collating data from separate columns

#### Milano1000

##### New Member
Hello all, I am confused how to collate or tabulate the results in this data set. Any help would be appreciated. I think this can be accomplished by using a formula but every effort has failed. I have given up and am asking for help.

This is it is just a set of math mathematical formulas that represent data points for a roll playing game. There 3 columns, Range Band (column B), Damage (column C), and Penetration (column D). The columns C and D are two separate formulas drawn from mathematical formulas. What I am trying to accomplish is take the data set of B:3 to D:31 and have Excel automatically Create the table in cells F:20 to K:21. Could I get help doing this from you all?

To clarify or reiterate, Damage gets smaller with Range, as does the Penetration. I am looking for a way to tabulate the data in table B:3 to D:31. Then reproduce it in F:20 to K:21. I highlighted the applicable data in red (column B) and Orange (column C and D). For example, (in row 7) at 145m the data should be eventually read as "4 / 2". As in a reference to G:20 and G:21. At 900m (row 27) should eventually read "1 / nil" as in K:20 and K:21.

I hope what I am asking makes sense. If not please do not hesitate to ask me and I will try to reiterate what I am trying to do.

Formula results.xlsx
ABCDEFGHIJKL
1
2BandDamagePenetration
30
4052
5542
61042
714542
815042
915542
1016042
1116542
1217032
1317532
1422532
1525032
1627532
1730033
1832533
1935033
20375230 - 55 - 165165 - 275275 - 350350 - 575575 - 950
21400235 / 24 / 23 / 23 / nil2 / nil1 / nil
2252524
2355024
2457524
2560015
2662515
27900112
28925113
29950015
30975016
311000018
32
Sheet1

#### Milano1000

##### New Member
Hey thank you all! Peter_SSs I worked off your suggestion and it came out perfectly. My actual file is 11 tabs long. Mostly for organization because of the amount of data and cross referencing, so it took me these last few days to translate your solution into the actual data.

To Doss, I appreciate the help as well. It could be an easier or better solution but given that this is just a hobby and something I do in free time I didn't really want to learn VBA.

To RandomHelper, I didn't see your posting until after I was engaged with the idea from Peter. It could be that this is easier also.

Thank you again guys.

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### Peter_SSs

##### MrExcel MVP, Moderator
You're welcome. Glad we were able to help. Thanks for the follow-up.

Replies
1
Views
140
Replies
4
Views
195
Replies
4
Views
362
Replies
3
Views
141
Replies
6
Views
97

### Forum statistics

1,126,928
Messages
5,621,654
Members
415,849
Latest member
PhoenixRising2015

### 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.

### Which adblocker are you using?

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

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