I had tried but being new to excel I was not transcribing the formula exactley as you had suggested. The formula works just as it should with the exception of how many times we have repeat patients and for these I am getting negative numbers in the length of stay. I will keep trying to figure this one out. Thank you very much for your assistance.
Larry
Quote:
Originally Posted by Mazzaropi
--------------------------------------------------------------------------
Dear Lhysell, Good Afternoon.
If you are asking this, itīs because you didnīt executed nor tested my suggestion for you.
Please, implement and test my suggestion.
Youīll see that the order of patients donīt matter.
You can improve the formula that I suggested you, to controlling the result when the DISCHARGE DATE is zero(0) (Blank).
Change the formula :
Before : Plan1 D2 -- =VLOOKUP(Plan1!A2,Plan2!A:B,2,FALSE)-Plan1!B2
Now....: Plan1 D2 -- =IF(VLOOKUP(Plan1!A2,Plan2!A:B,2,FALSE)=0,"",VLOOK UP(Plan1!A2,Plan2!A:B,2,FALSE)-Plan1!B2)
Do this and tell me if it worked for you.
|