First off - thank you all for the great help this place provides. I am a self taught consumer of excel, and usually can find the answers I need after a bit (sometimes a lot) of research.
This time I am stuck and out of my league
I get data from several venders in multiple formats, and most of them I can get setup in a way that I can pull out what I need.
This vender is really frustrating me.
the data comes in with 2 sections side by side and I need to be able to pull numbers based upon the values in the first row and the 3rd or 6th row.
for example
(CO AURORA) + (MID GRD 3-WAY (RVP870) should return 3.207
(CO AURORA) + (ETHANOL) should return 2.72
(CO DUPONT) + (ETHANOL) should return 2.91
I can easily pull the mid grd numbers, but the ethanol from the 2nd set of columns is causing me to have fits.
in the example I am only using 2 locations, but in reality I have 7 locations with 10 different fuels each, so I really need to be able to pull the data as it is formatted if possible.
looking for the code that I can use to pull from the above example to this new sheet I am making up
Thank you once again for any and all help / ideas.
Taz
This time I am stuck and out of my league
I get data from several venders in multiple formats, and most of them I can get setup in a way that I can pull out what I need.
This vender is really frustrating me.
the data comes in with 2 sections side by side and I need to be able to pull numbers based upon the values in the first row and the 3rd or 6th row.
for example
(CO AURORA) + (MID GRD 3-WAY (RVP870) should return 3.207
(CO AURORA) + (ETHANOL) should return 2.72
(CO DUPONT) + (ETHANOL) should return 2.91
I can easily pull the mid grd numbers, but the ethanol from the 2nd set of columns is causing me to have fits.
in the example I am only using 2 locations, but in reality I have 7 locations with 10 different fuels each, so I really need to be able to pull the data as it is formatted if possible.
Code:
CO AURORA 2/17/2013 UL RVP 7.8# 10% ET850 -0.0150 3.095 E-85 70% Eth/30% U825 -0.0189 2.61
CO AURORA 2/18/2013 MID GRD 3-WAY (RVP870 -0.0100 3.207 PUL RVP 7.8# 885 -0.015 3.41
CO AURORA 2/19/2013 PUL RVP 7.8# 10% E910 -0.0150 3.4225 ETHANOL 0 2.72
CO DUPONT 2/20/2013 UL RVP 7.8# 10% ET850 0.0000 5.16 E-85 70% Eth/30% U825 -0.015 3.25
CO DUPONT 2/21/2013 MID GRD 3-WAY (RVP870 -0.0150 3.0267 PUL RVP 7.8# 885 -0.015 3.25
CO DUPONT 2/22/2013 PUL RVP 7.8# 10% E910 -0.0150 3.0307 ETHANOL -0.015 2.91
looking for the code that I can use to pull from the above example to this new sheet I am making up
Code:
(PUL RVP 7.8# 10% E910) (BIO DIESEL) (ETHANOL) (and so on)
CO AURORA
MN ALEXANDRIA
CO DUPONT
CO COMMERCE CITY
Thank you once again for any and all help / ideas.
Taz