formula to find data

  1. H

    CUME Week to date formula

    Hello, I have a table of data, in the first column is the week i.e Week 1, Week 2 etc. In the second column i have fully populated with last year sales data by week. in the final column i have this year data which every Monday is updated. I have this setup for many departments and each week i...
  2. B

    find data in column that meets parameter

    I have a two columns of data that exists in the range A5:B1199. Column A is time stamps and column B is temperatures. I need to find the first occurrence in column B when the temperature rises above a certain point and then display the corresponding time from column A. Ideally, I want to be...

Some videos you may like

This Week's Hot Topics

Top