I have created a spreadsheet to monitor the quality of the work carried out by my team, the spreadsheet is nearly done and just requires a small amount of work to get completed.
All I require is someone with a better knowledge of excel to put in the formula that will be needed to work out daily, weekly, Month to date and monthly stats and have this show in a graph and in numbers.
I am struggling because I only have very basic excel knowledge and have not set the sheet up in a traditional manner so I am unsure of the formula needed. There are 3 outcomes that get recorded, red, amber and green with the date recorded underneath.
I need someone to be able to make a formula that searches for the date in an array and then finds the colour that is in the cell above and counts it, so it searches the whole sheet for the date and then tells me how many of each result there has been for a particular, day, week, month.
Good Excel knowledge is the only skill required for this job.