I am trying to search Data by Date Criteria ie data (from Date) to (to date)
if the Date exists between FromDate toDate then it should display the dates with data Else Date should not be highlited if not exists.
also thought of incorporating "EVALUATE" but i get Type mismatch
the data of...
Not able to resolve the following using Index and Match. My column displays blank
Full code is at following : https://www.extendoffice.com/documents/excel/3354-excel-search-multiple-sheets-workbooks.html
First finding a value which is in coulmn 3 of mutiplie sheets i am able to get the...