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...
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...
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...
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...
I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...