Hope this has attached. You will see what I need to do is to be able to select a value in the row on the left and have it find the value of the columns going across. These will change as they are drop down so that you can compare any value in the row to any value in the column
Yes the Analysis Tool Sheet. The top box where it says Cellulitis in B7 (I think) - this will pull information from the sheet marked CCG List Cellulitis - so once you have selected the name in the row I have marked 1 (currently NHS Barnet CCG) it will find the value corresponding to the G6 value also on the CCG List Cellulitis (so currently it will find the value for NHS Barnet CCG Episodes per patient and put in that value. If you change the name in the row or the value in the Column it will find the new answer. Hope that makes some sense
The bottom table marked lower limb ulcer will do the same looking at the information in the sheet marked CCG List lower limb ulcer
Yes that sounds right - but important that when both row and column are changed the values change with them - thank you so much
Yes - this just allows comparison for up to 5 accounts (the ones listed as CCGs) at a time across a changing variety of measures in two different disease areas
Here is the download link:
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.Thank you!Best regards,Jess
Hi - this is awesome - could I push my luck a little more - happy to pay a little more if needed.
Could a row be added with the value of the National Average (available on each sheet at the bottom) - and then the cells conditionally formatted so that if above average they turn light red and is below they go green and if equal they go amber ?
Sorry but that wasn't what I was looking for. I wanted to be able to rate the cost in the box on the analysis tool against the average on the Cellulitis / Lower Limb sheets - not the average of the 5 entries on the analysis tool - and if possible to shade the cell itself red or green - not sure if this is possible?
I think I have managed to do that now thanks. The report is almost ready - just looks a little untidy as cannot make the cells give details in £s or just numbers and make the number of decimal points consistent as this changes with each choice made - but it looks pretty good so far. I may need to develop this further - is there an easier way to contact you if I need your help or just through this system?