Search results

Hi I am using a gantt chart for the rostering staff to be able to plot the annual leave for all staff. In order to make this easier, I was wanting to have a formula to calculate the first and last day of leave from the project start date in the inputs tab if that is possible. This means that...

Hi I have a Gantt Chart from Chandoo projects which has the dates noted as workdays only. I need all days, Monday to Sunday to be shown and cannot determine the formula to alter the formula in row 2 from F3 to alter to include every day of the week. Can anyone assist please. I tried altering...

I am trying to create an attendance list for an organisation and set it up to automatically put in the Monday dates for each month in 2016. I figure there is an easy way to do this with a formula - but can't find it. If anyone is has a solution I would really appreciate it. I still can't...

Hi all I hope you are having a bit of a break from whatever you may normally do and that you are enjoying time with family and/or friends. :) I am trying to create an attendance list for an organisation and set it up to automatically put in the Monday dates for each month in 2016. I figure...

I don't seem to be able to see any excel files when I click on "Upload a file". I have tried saving the files in a few different formats and in various locations. It's just not working. Any clues anyone??

I am having problems with writing the correct formula for a spreadsheet. I am also having problems uploading an excel file as I can't see any excel files in any folders when I go to upload the file to explain the date formulas I want to write. To overcome this I have put the example, formulas...

I also need another chart for each patient for the year. In this I need to refer on the sheet "Weight Record" to a cell in a second sheet called "MNA". I've tried a few formulas - but not making it. If anyone can assist with the formulas in column "I" rows 13 - 25 I would really appreciate...

I have a weight chart used monthly to identify if a patient is underweight or not. On occasions patients either refuse to have their weight monitored or they are absent at the time the weights are recorded. Due to the formula used in the chart, anything other than a number results in a #Value...

I have been asked by a healthcare facility if there is a way to create a daily spreadsheet with the date automatically populated - either at the top of the form, or on the tab. Maybe this needs to be done as a 3 or six monthly sheet - not sure how stable it would be with 365 tabs if that is...

I am doing some work with a healthcare facility and someone came up with an idea of creating an excel spreadsheet to put all the people a doctor is to see - and why the doctor is to see those people. The issue we have is that the staff are not all very literate in it generally and excel...

I have a range of up to 5000 cells in a row. The data has been pasted into excel from a pdf document. I want to select the entire row and have cells highlighted if the number in the cell is less than a specific number - this will change for different sheets. It could be anywhere between 3 and...

I need to be able to count the number of cells (all numerical value between about 1 and 25) in a range of about 290 rows where the value in the cell is less than 6. I have had a brief look around and can't find this anywhere and need it reasonably quickly. I'm sure this is really easy - when...

I need to add the number of N/A answers in a spreadsheet. I have uploaded the spreadsheet to https://www.dropbox.com/s/l7hfh5y6f4q27m5/Oral_Dental_audit.xlsx At this stage the additions of the N/A answers is done manually. Need to make it idiot proof :) If anyone can assist I would really...

I am doing a Gantt chart - and I need it to be in weeks - not days, as this project is over a period of 4 years. I have modified the dates to be workday+5 - I am sure there is a better way of doing this - but my knowledge of programming is not good enough to work this out. One of the tasks...

I have a weight chart for a health care organisation and cannot figure one part of conditional formatting. In the previous % weight gain or loss column (the document can be seen at https://docs.google.com/open?id=0BwL-nA3ga6NVUUN5UjJocEJKOUE ) I need to highlight if there is a weight gain or...

I need to use conditional formatting in a spreadsheet a client is using. Unfortunately they only have Excel 2003. What I have is four different areas, lets say for ease of explanation, A, B, C, D and E and a range for each month of about 30 or 40 incidents. There can be any number in each of...

If I have conditional formatting and it is if any cell is less than say 90, (providing there is a number in the cell) how can I do this? When there is nothing in the cell, it is also highlighted but that is not what I want. I can't get my head in the right place to get this, and know it should...

I need to apply conditional formatting for averages for a group of hospitals. There are 82 questions and each hospital supplies their results and the average for each question is calculated. I thought that there is possibly a way to apply a conditional format to highlight if the individual...

A colleague of mine has asked if I can help. She selects a single cell in Excel (think it is 2010 but may be 2007) and about three cells below the cell she has selected are highlighted. I notice she is working in page layout view. Has anyone experienced this or have any suggestions of how to...

Hi I have just started learning about pivot tables and dashboards. I want to create both for data collected for a hospital to make the information better and more meaningful for the managers. I am having problems with getting the pivot tables to be as user friendly as I would like. The data...