find starting value

FROGGER24

Well-known Member
Joined
May 22, 2004
Messages
701
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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

FROGGER24

Well-known Member
Joined
May 22, 2004
Messages
701
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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?
 

FROGGER24

Well-known Member
Joined
May 22, 2004
Messages
701
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,990
Messages
5,834,761
Members
430,317
Latest member
karenmi

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
Top