Search text based upon date
Hi Im struggle to put together a (what should be simple) statement to search a column (section) based on the month it was checked.
From the attached table i want to pull the data out of the sheet into another and record that the check has been completed for each month.
So the output would be in march electrical repairs, dust suppression, environmental checks were all completed however site buildings and pedestrian & Traffic were not.
The output in Feb would be vice versa..
Any help would be greatly appreciated :P