I am working with a Log file and need to count the number "Days" each User has logged in, not the times the User has logged in.
Column "A" contains the email address (Range Name ACCESS -- $A$2:$A$36595)
Column "E" contains the date of access (Range Name TimeStamp $E$2:$E$36595)
Separated by several Blank Columns Cell J2 holds the email address in question
Based on review of other threads, I am using the Formula below entered as an array (Shift-Ctrl-Enter)
=SUM(--(FREQUENCY(IF(Access=$J2,TimeStamp),TimeStamp)>0))
Results are returning as #N/A
What am I missing?
Column "A" contains the email address (Range Name ACCESS -- $A$2:$A$36595)
Column "E" contains the date of access (Range Name TimeStamp $E$2:$E$36595)
Separated by several Blank Columns Cell J2 holds the email address in question
Based on review of other threads, I am using the Formula below entered as an array (Shift-Ctrl-Enter)
=SUM(--(FREQUENCY(IF(Access=$J2,TimeStamp),TimeStamp)>0))
Results are returning as #N/A
What am I missing?
