find starting value

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
i would like to find the starting value the copy each cell that contains a value
So in this example column a would have 26.375 then copy each row down
BARGE CBC-105 TANK 1 OUT table.xls
BCDEFGHIJK
9IN2 FT.IN3 FT.IN4 FT.IN5 FT.IN6 FT.
1000155,4200144,0020132,5850121,168
111/41/4155,1821/4143,7651/4132,3471/4120,930
121/21/2154,9441/2143,5271/2132,1091/2120,692
133/43/4154,7063/4143,2893/4131,8723/4120,454
1411154,4681143,0511131,6341120,217
151/41/4154,2301/4142,8131/4131,3961/4119,979
161/21/2153,9931/2142,5751/2131,1581/2119,741
173/43/4153,7553/4142,3373/4130,9203/4119,503
1822153,5172142,1002130,6822119,265
191/41/4153,2791/4141,8621/4130,4441/4119,027
203/8162,0801/2153,0411/2141,6241/2130,2071/2118,789
213/4162,0603/4152,8033/4141,3863/4129,9693/4118,552
223162,0403152,5653141,1483129,7313118,314
231/4162,0201/4152,3271/4140,9101/4129,4931/4118,076
241/2162,0001/2152,0901/2140,6721/2129,2551/2117,838
253/4161,9413/4151,8523/4140,4353/4129,0173/4117,600
Sheet1
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"i would like to find the starting value the copy each cell that contains a value "

Copy to where?


"So in this example column a would have 26.375 then copy each row down "

It might be clear to you why this is the case, but is isn't to me :)

Care to post back with a few more details...
 

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
What I am trying to do is condense 22 columns into 2 one will be the feet and inches column converted to inches the other will be the numbers column
in the example the starting point is 2'-2'3/8 with 162,080 representing the gallons for that gauge so on a new worksheet i would like to copy any cell that has a number in it and the inches. so in example the new worksheet in cell a2 would be the value 26.375 b2 would have 162,080

hope i explained myself better
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
A little, but you've still lost me!

I get the 2 ft 2 3/8 inch bit (as in col B for 2ft, a18 for the 2 inch & a20 for the 3/8
I get the 162,080 - a look up from a20 to the value in col B, being the first cell with data in the column
I (think I) get the 26.375 bit - decimal inches for 2" 2' 3/8.


still lost on this bit:

"so on a new worksheet i would like to copy any cell that has a number in it and the inches. so in example the new worksheet in cell a2 would be the value 26.375 b2 would have 162,080"

...I don't get how these relate. in the example you posted, many cells have values - cell B20 just happens to be the 'first'. You say you want to copy "any" - what haoppens to the rest? What do you want in B3 etc?
 

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
go down the column until blank then start back at the next two columns and copy that data to the new worksheet. this will continue until 22 columns of data has been pasted into 2 columns i will end up looking like this
Book1
ABCD
226.375165500
326.5165545
426.75165540
527165535
627.25165530
727.5165525
827.75165520
928165515
1028.25165510
1128.5165505
1228.75165500
1329165495
1429.25165490
1529.5165485
1629.75165480
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,118,083
Messages
5,570,118
Members
412,305
Latest member
Mozz
Top