exclusion

I posted a question a couple of weeks ago and received some great help. Unfortunately, I was not as precise as I needed to be in how I described what I needed to accomplish. Thus, I will try see if I can get some help for this last bit of formula-building.... I have a number candidates that...

I am working with a data set which is in pivot tables which is a series of staff appraisals and the dates these were conducted. That part has been simple. However, my bosses have asked if the table can be changed to list all staff that have not had an appraisal in the last 6 weeks. Any advice...

I have created a VLOOKUP list of my company's office holidays. This list has only non "standard" holidays and weekends. Example: 7/4 and 7/5/2016 are in the VLOOKUP list because my company is closed and pays us for those days. Here is what I am trying to do: There is hard delivery date of...

Good afternoon, I am trying to exclude all empty cells from my sheet, but I cannot find a way to do it other than to exclude them one by one. I am trying to make this: To turn into this: Does anyone know a way to do it?

HI Basically, I have a 20 x 20 array which contains the distances between 20 cities. I need to find the closest city beginning at the starting city. Whilst I've a programmed the minimum, I am not sure how to exclude cities that have already been visited as you cannot use these again. My code...