Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill in columns
Is there anyway to expand the information in a column and its relation in the
next column? example, in column A, I have numbers 50, 52.1, 55, 58.8, 60, 65, 70, etc. (up to 20,000) in column B, I have a number I can divide them with to give me another system of numbers. the divisor of 50 is 4.66, 52.1 is 4.88, 55 is 5.13, 58.8 is 5.46, 60 is 5.52, etc. I'm building a form where I need to be able to have someone type in any number (not just the ones in the table), and it can find the divisor and divide to give them an answer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
Fill Handle Across Columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |