I have 5 PC which will be used by a user. So i would like to count the usage in hourly range and avoid count duplicate ID/name in that hour. Attached the sample. Thanks.
I have 5 PC which will be used by a user. So i would like to count the usage in hourly range and avoid count duplicate ID/name in that hour. Attached the sample. Thanks.
Can you put some expected result and what is the thought behind the expected result?
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Can apply this formula.Formula:Please Login or Register to view this content.
or try below array formula and copy towards right
F13=SUM((FREQUENCY(IF(F$2:F$11=1,MATCH($C$2:$C$11,$C$2:$C$11,0)),ROW($C$1:$C$11))>0)+0)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks