Hi. One last question for the day!
Spreadsheet attached. I need to calculate the number of days from a hospital discharge to the next admission. These are in two different columns. One person an have 1 or many admissions. If they don't have a readmission, I just want an NA returned. The values in the attached example spreadsheet were calculated by hand as an example of what I'm need.
Thanks!
Are you sure your calculations are correct?
In D2
=IF(COUNTIF(A3:$A$21,A2),INDEX(B3:$B$21,MATCH(A2,A3:$A$21,0))-C2,"NA")
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Fantastic. Worked like a charm. Thanks!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks