Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help please
A B C
80 100 700 70 200 65 300 40 400 24 500 19 600 0 700 0 800 0 900 I have two columns. Column A will have a series of descending numbers that can start with any value and will end with 0. The number of 0s can vary. The values of the numbers in Column will change each time I run a program, but will end with one or more 0's. Column B will have another series of numbers but these numbers will not change each time the program is run. I would like to show in cell C1, the number in Column B that is adjacent to the first time a 0 appears in Column A. In the example shown, 700 is the number in Column B that corresponds to the first time a 0 appears in Column A. I need the formula for cell C1. Thanks for the help, Bill |