Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Logic formula to only count patient once, even though they are listed multiple times Logic formula to only count patient once, even though they are listed multiple times
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-29-2014, 03:59 PM
BobBridges's Avatar
BobBridges BobBridges is offline Logic formula to only count patient once, even though they are listed multiple times Windows 7 64bit Logic formula to only count patient once, even though they are listed multiple times Office 2010 32bit
Expert
  
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default
So forget looking at columns C, J and Q; all your formula needs is to look at column B and report how many different patient numbers are there, no matter how many times they appear. Will that work, or am I missing something? In the worksheet you posted, I see 244 different patient numbers. If you have a formula that tells you that for any range of rows, will that satisfy your requirement?
Reply With Quote
 

Tags
count logic, if then

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


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 12:57 PM.

Contact Us - Privacy Statement - Top

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