Trying to write code that would check a single column for data starting at the top and then subtract that cell's values with the next cell with data that it finds further down the column. Let me know if this doesn't make any sense. Thanks, Byron
Which lookup functions find a value equal or greater than the lookup value?
In column "K" if conditions are matched we would have data in a cell such as Column K Row 30 the data would be 650. Then another cell further down the column might also have data such as Column K Row 40 data value 900. In column "L" I would like to search automatically for all data in column K and subtract as in this example K30-K40. Hope this clarifys. Thanks in advance.
I'm sorry in my 2nd post I should have listed as the example K40-K30. Then the next cell to be computed would be let's say K50-K40. You can see why I'm going nuts. I guess this would require some coding that would read ahead for the next entry in a column and subtract that entry from the previous one. Thanks for your help.