Search results

Hi Narayan, It only works if the data is sorted from column A and the separation date. That's fine though, I've got what I needed, thank you so much! Best, A

Thanks Narayan, it works! But the formulas are dependent on the Patient Identifier and Discharge Dates being sorted, right? What if I need to add more current data to the dataset? I'd need to sort it each time? Is there another way of doing the formula without having to sort the data?

Hello Paul F and Naresh, Thanks for your replies - I have uploaded the book and have put what I'm trying to achieve under the grey headers. Thanks in advance for your help! - A

Hi there, I have 200,000 unique identifiers (for patients) and I'm trying to see whether they came back in to hospitals within 28days. So I have the unique identifier in one column and the dates in which they came in in another column. How can I write a formula which will look at the dates for...

Hello there, I am trying to use a format and conditional format to see if a target has been achieved. The formula / conditional format seems to work when there are number in the cells it is referring to, however, when the cells the formula refers to contains texts, it marks it as the target has...

Great, thank you!

Hi there, I have sparklines set up to feed off a pivot table. What I need to figure out is how to make it a rolling sparkline. For example, if the current month is March 2015, I want the sparkline to show January, Febuary and March 2015. If June 2015, I'd like the sparkline to display April...

Oh my gosh, it works!!! HOW??? WHY??? THANK YOU!!!! Wondering if you might be able to help with another conundrum please, I'm trying to sum the number of KPIs and data is in columns with data next to it. For example, if G6>H6 then "1", if I6>J6 then "1" etc I want it to sum all the "1"s...

Hi there, I'm trying to recreate Chandoo's KPI chart as per this link: http://chandoo.org/wp/2011/03/24/kpi-dashboard-revisited/ I can't seem to get my scatter markers to align (be in the centre) of the bar chart like in Chandoo's example I've attached my workbook, KPIChart_AS and Chandoo's...

Hi Chiro, Thanks for your help! I've sorted out the sparkline and last month's figures issue but am stuck on the chart with target. I'm trying to create these blue bar charts with scatter but can't get the scatter markers to align with like it does here...

Hi there, I'm trying to create a dashboard but am a little bit stuck. The objective of the dashboard is to show a manager's performance by month. I'm stuck on three parts of the dashboard: - I want to create an in-cell sparkline which will automatically update based with each month's newly...

Hi Narayan, this seems to have worked, thank you so much for your help!!

Hi there, I need to answer the following questions but I'm not sure which formulas to use to achieve this: - proportion of doctors admitting 50% of all patients - proportion of patients admitted by the upper 50% of doctors - proportion of patient admitted by the lower 10% of doctors...

Hi, I have a dashboard that I've created using PowerPivot (OLAP cube). The dashboard updates daily to show current patients who are in hospital [today] and how many of them are at risk of readmission. This calculate a percentage of how many people are at risk. What I want to do is track on...

Hi there, I'm trying to develop a MDX calculated measure. I want to look at the most recent pathology results for a patient; however, a patient can have multiples of the same test done on different dates within the same hospital admission. I want Excel to give me the test result for the...

Oh, thanks Narayan! I just figured it out myself too!

In case anyone ever needs it: ="Data is for months: " &TEXT(EDATE(TODAY(),-3),"MMMM")&", "&TEXT(EDATE(TODAY(),-2),"MMMM")&", "&TEXT(EDATE(TODAY(),-1),"MMMM")&"."

Thanks, Narayan. This definitely works! Is there anyway to get the information into one formula without needing cells A1 and A2? The text in A1 isn't full necessary. Cheers!

Hi Narayan, No, I won't have any data in any cells. I want it to auto-formulate every month I open the spreadsheet. I think I need a cross between: =UPPER(TEXT(TODAY(), "mmm")) =EOMONTH(TODAY(),-3)+1 But can't figure out how to join it. Thanks!

In case anyone is interested, this is the formula I used (a colleague helped me): =IF(AND(Richmond!$D6=B$5,OR(DATEVALUE(Richmond!B6)=EOMONTH(TODAY(),-1)+1,DATEVALUE(Richmond!B6)=EOMONTH(TODAY(),-2)+1,DATEVALUE(Richmond!B6)=EOMONTH(TODAY(),-3)+1)),Richmond!E6,0)

Hi all, I'm looking for way simple way to get the following information into one cell: I need to know the month names of the previous three months. So, if today's month is November, display text "Data is for months August, September, October." Thanks in advance for your help!

Hi Hui, Thanks for your response, managed to figure it out. I'm looking for way simple way to get the following information into one cell: I need to know the month names of the previous three months. So, if today's month is November, display text "Data is for months August, September...

Hi there, I'm wondering if someone might have a work around/formula for what I’m trying to achieve. I need to get the “rolling” three month aggregate figures for a dimension - let’s say Falls (in column E of the table below), for the ward at each campus. The data looks as in the image...

Hi there, I'm comparing data from two different sources and need an efficient way to do it. I have one Excel workbook with two sheets - RAS EpSelect 0101-0106 and RAS HCP 0101-0106. Both worksheets have mostly the same data but is distributed over different columns. The data I'm using has...