Search results

How do I send you a message please

I can't for some reason. The xl files aren't showing up when I go to the upload button. That is why I uploaded the word document.

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...

Thanks Hui I hadn't looked at the chart correctly. That's great!!

Thanks Hui Not sure how - but I missed your last post as you can tell from my last post. Not sure about the last file. The MNA is needed to be calculated, and I wanted to set this up so that when the MNA is done the cell/s in column O will populate automatically. Have to think about that...

The only issue I have is with the cells in column C which have not been completed due to that month's weight not being done yet. If I copy the formula into column I, I get whatever the phrase is in the Lookup table for the corresponding range. Thoughts on how to rectify this? I have uploaded...

Thanks - that does work :)

Thanks That works well. As you say, if the MNA is needed to be done each month, that will have to be a separate calculation - but easy to setup.

Thanks for the suggestion. That created another issue with the formula in E5. I have uploaded the file again with the result of the formula you suggested =IFERROR(IF($B5>0,C5/($B5*$B5),""),"") If the result at row D is blank, the result at row E needs to be as well. I tried to rectify it...

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...

Hi Narayan I have put some data in the file - not the whole amount as a bit late here and need get some rest. I have named the data ranges for reference. It would give us some idea of what this would do and how it would work. Thanks for your assistance with this. Sue

Hi Narayan Can I input some data now so that I can show them what it would look like when they use and/or print it? As I don't fully understand, they won't understand what I am saying? Thanks Sue

Thanks Narayan You are right with columns B to F. Following you numbering: 6. G is for the shift the staff member was to work. This will generally be AM PM or ND (Morning, afternoon or night) 7. H - is for the name of the person who took the call from the person ringing to say they are...

Thanks Narayan What you are suggesting is great - I just don't know how to create that. Tomorrow I will ask who needs to do what with the system. My understanding is that the form will be completed each time someone calls and says they are unable to come to work. The person taking the call...

Thanks Narayan As they had asked for a separate page for each day, I thought a tab would be the best way of doing this. The use of the file is two-fold 1. For administrative staff to input data 2. For nursing staff to be provided with printouts of one page for each day. There can be as...

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...

Thanks all for the suggestions. I agree with most of the comments - including the fools comments and it is not allowed in any workplace I have been in either :) Thanks Bobhc - it is not the doctors who use the forms - other than to know what they have to do. The doctors come and visit - so...

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...

Thanks Narayan - the first one worked. what is the difference between C5 and C$5 What does the $ do? Sue

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...

Thanks Narayan That worked - didn't have the right thought processes in place when I was doing it. Knew it would be really easy. Sue

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...

Thanks to both Oldchippy and Narayan The formula worked thanks, and I rectified cell R21 - not an incredibly better result for the audit - but still every little helps when you're not doing too well.

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...