multiple monitors

This Week's Hot Topics

• How to sum values of the year till 31/12 and reset to 0 on 1/1 for years running totals?

  • Started by LRATOZ
  • Jan 19, 2021
  • Replies: 38

  Howdy, I have been recording rainfall data since 15/11/2015. I used to have mutiple sheets for each year but I've learned that it makes more sense...
• Auto filter between a range of dates

  • Started by K1600
  • Jan 20, 2021
  • Replies: 37

  I am trying to apply a filter to a data set which is with an excel formatted table (Table8) but the first bit I need to do is only show data where...
• Formula to Display Sheet Name of Worksheet that Contains Max Value Across Multiple Sheets in Workbook

  • Started by erino
  • Jan 19, 2021
  • Replies: 36

  I have created a workbook that is comparing my business transactions from year to year. Each year is represented by a worksheet (2020, 2019, 2018...
• date formula to determine amount of vacation weeks

  • Started by bh24524
  • Jan 20, 2021
  • Replies: 32

  I am looking for help on a formula that will look up a given seniority date contained in cell C11. The formula would be in D11. I want it to...
• Inserting IF formula in complex index/match formula to get results until certain date

  • Started by SteveNL86
  • Jan 20, 2021
  • Replies: 28

  Dear reader, I'm using this formula...
• Nesting INDEX MATCH into SUMIFS

  • Started by lost_in_the_sauce
  • Jan 18, 2021
  • Replies: 26

  I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...