Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-29-2014, 01:20 PM
Carol Salcido Carol Salcido is offline Logic formula to only count patient once, even though they are listed multiple times Windows 7 32bit Logic formula to only count patient once, even though they are listed multiple times Office 2007
Novice
Logic formula to only count patient once, even though they are listed multiple times
 
Join Date: Jan 2014
Posts: 9
Carol Salcido is on a distinguished road
Default

If the baby's admit date is less than their first occurance date, in column J, then they were possibly in with the mother when they were first born, not needing to be in the NICU. Does this make sense? An example of this is Pt Nbr (column B) is 2452590. As you can see, their first day in the NICU was 1/11/13, but baby was born on 1/9/13. So, in this instance, I would want to count the baby as an admit on the 1/11/13 day only, even though the baby stayed in the NICU for 48 days.
Reply With Quote
 

Tags
count logic, if then



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Count Formula clau_dos Word VBA 1 08-27-2013 02:05 PM
Logic formula to only count patient once, even though they are listed multiple times Selecting the same word multiple times at one go No.1 Word 3 08-08-2013 06:29 PM
make a form that can be used multiple times at once Dsp581 Excel 19 04-05-2013 07:25 AM
Count If Formula beb1227 Excel 10 06-19-2011 11:19 AM
Logic formula to only count patient once, even though they are listed multiple times Outlook Sending Same Email Multiple Times mudpuppy Outlook 1 08-03-2010 06:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft