Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2-dimensional array to 2 column list
I have data like this:
.01 .02 .03 .04 .05 .06 .07 .08 .09 1.0 2.0 2.15 2.3 2.7 3.0 3.26 3.40 3.61 3.89 1.1 3.94 1.2 1.3 1.4 1.5 Etc... this is a basic table to figure the greater number (1st column) + the lesser number (the 1st row) ...the find the array value @ A3:C3. I need to convert this a 2-column file such as: 1.01 2.0 1.02 2.15 1.03 2.3 1.04 2.7 1.05 3.0 etc. Hope this is enough info... Basically it is an array for figuring flow of water...if I know how high the creek is flowing, I can figure how many cfs it is passing. So, if I know it's 2.45 ft...then the table would figure xx.xxx cfs. But in order to bring it into another program I have to have it in a 2-column list. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions | |||
Formula to search for given term, and if not found in column to add it to list | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions |