Forum Discussion
Copying over data that doesn't "have a pair"
I have a sheet 'Site A History' that shows every sign in/out as recorded on a Microsoft Form: I want to copy over any entries where for a given Name e.g. Apple Banana, in column C there is an ...
=UNIQUE(FILTER('Site A History'!$A$2:$B$1000,COUNTIFS('Site A History'!$A$2:$A$1000,'Site A History'!$A$2:$A$1000,'Site A History'!$C$2:$C$1000,"In")>COUNTIFS('Site A History'!$A$2:$A$1000,'Site A History'!$A$2:$A$1000,'Site A History'!$C$2:$C$1000,"Out"),""))
=UNIQUE(FILTER('Site A History'!$A$2:$B$1000,COUNTIFS('Site A History'!$A$2:$A$1000,'Site A History'!$A$2:$A$1000,'Site A History'!$C$2:$C$1000,"In")>COUNTIFS('Site A History'!$A$2:$A$1000,'Site A History'!$A$2:$A$1000,'Site A History'!$C$2:$C$1000,"Out"),""))
