responded

Can anyone provide me with a formula to obtain the "Earliest Response Time" for each row when "Response A" or "Response B" = "Responded". If both do not match then the earliest response time should remain blank as per the entries shown in the table below: Name Response A Date A...

Hi there, I'm producing some graphs based on a set of questionnaires. Some are Likert Scale statements and some are simple yes/no/don't know questions. We are trying to split the answers down by type of respondents: Amenity manager; productive managers; multi-functional managers; and...

Hi All, I have two spreadsheets for a monthly mail shot. The first spreadsheet has Full Names and Dates of births. The Second spreadsheet is a list of people that have returned with a response. Full Name & DoB again. I need to do the following.... Run a look up to see who and how many...

Hi I have a spreadsheet with two worksheets, on the first I have a list of applications with two dates, the date an application was made and the date it was responded to e.g. <tbody> Application no Date made Date responded to App-001 01/09/2017 05/09/2017 App-002 04/09/2017 15/09/2017...

I am trying to create a spreadsheet to track attendance In the rows I have listed Calls, Meeting and Training by month The columns are for each person I would like to set the conditional formatting on each row to turn the number red if it is below the total calls, meetings or training that is...