Thread: [Solved] Logic formula to only count patient once, even though they are listed multiple times
View Single Post
 
Old 01-29-2014, 03:59 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit 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