I have a large sheet to record patient visit , every time when patient came we enter his PB result and his status ( controlled or uncontrolled ) every visit in same row
Like this :
Column A ( patient name )
Column B ( patient Status)
Column C ( 1st visit date )
Column D ( 1st patient result)
Column E ( 1st visit status )
Column F ( 2ed visit date )
Column G ( 2ed patient result)
Column H ( 2ed visit status )
etc ..
what I need :
to show last status of this patient in (column B)
example : if he came for 1st visit and His status in column E was controlled the status in column B change to controlled . Next time if his status in column H was uncontrolled the status in column B change to uncontrolled
I hope to find a solution
Like this :
Column A ( patient name )
Column B ( patient Status)
Column C ( 1st visit date )
Column D ( 1st patient result)
Column E ( 1st visit status )
Column F ( 2ed visit date )
Column G ( 2ed patient result)
Column H ( 2ed visit status )
etc ..
what I need :
to show last status of this patient in (column B)
example : if he came for 1st visit and His status in column E was controlled the status in column B change to controlled . Next time if his status in column H was uncontrolled the status in column B change to uncontrolled
I hope to find a solution