Greetings!
I am a Data Clark working in a hospital in Scotland, UK. As Excel skills are limited but I manage to get by with what I need to do,... however I am now faced with the following problem and hoping someone on the forum can point me in the right direction. Any help will be much appreciated.
I am working with hospital admission / discharge data using Excel 2010. My spreadsheet contains approximately 3000 rows. Amongst other columns, these are the ones that my problem relates to:
Column A = Hospital No.
Column B = Admission Date
Column C = Discharge Date
What I am trying to do is add two extra calculated columns:
Column D = Admission Count (based on admission date order, this column will be the number of times the patient has visited hospital based on the data in the table)
Column F = 30 days (this column needs to indicate if the admission date for this spell in hospital falls within 30 days or less of the previous discharge for this patient)
The workaround I currently have is to order my data into Hospital No and date order and then base my calculation of the preceding row. The problem with this is that my figures change each time I filter or order columns. I’ve spent ages trying to find a solution. On the web I’ve noticed that other people have tried to find a solution to this but it’s either using PowerPivot or their problem is slightly different to mine and I am not able to modify the formula to suite my data. As you may have guessed my Excel skills are limited.
Hope you can help. I will try attach some dummy data…
Bookmarks