The have created the following formula that counts a text quote from a column in another dynamically changing sheet.
=COUNTIF(OFFSET(Sheet1!$F$2,0,0,COUNTA(Sheet1!F:F),1),"Missing Data").
On the sheet that shows the found values (Sheet 2) I also want to add a Start Date in a field and an End Date in a field so the found values will only show between a specific date range.
I have a date range in column E on Sheet 1.
Where and how do I specify this ?
Thanks in advance
Bookmarks