Logic formula to only count patient once, even though they are listed multiple times

		Microsoft Office Forums > Microsoft Excel > Excel
Logic formula to only count patient once, even though they are listed multiple times

FAQ

Thread Tools

Display Modes

#18

02-26-2014, 03:57 PM

macropod

Windows 7 32bit Logic formula to only count patient once, even though they are listed multiple times

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,520

If you want to identify the patients, you could use:
=IF(COUNTIF(B$3:B4,B4)=1,1,"")
in Q4 and copy down. That will output a 1 against their first admission.

If you want to get the data for a given month, things get more complicated.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

count logic, if then

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word Count Formula	clau_dos	Word VBA	1	08-27-2013 02:05 PM
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
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 01:07 AM.