Hi all ,
I am currently working on a report for usage of mobile app.
I am using =SUMPRODUCT(1/COUNTIF(Sheet3!B2:B7,Sheet3!B2:B7)) to see how many unique customer logged in.
However, I have a requirement to show number of customers logging in twice (C15 Sheet 2) and customers who logged more than 3 times (C16 Sheet 2).
I will appreciate any ideas.
Thank you in advance
Bookmarks