|
I have a table which contains information of visitors to my website. I want to find out the last access time to the website of each users. How to find out? Any formula could do this for me easily? By the way, I'm using Excel.
(comments are locked)
|
|
There steps you could solve this problem. First, Sort ascending by user as primary sort field, then sort decending by access time as the secondary sort field. Second, add a judgment expression in another column. Last, filter the data and keep the data that is FALSE in this column. But I don't use Excel for such kind of problems, becuase this solution is also not simple. I use esCalc in a simple way: Group by user, then filter only once.
(comments are locked)
|
|
Hi Jessica, thanks for your comment. But I still like to use Excel. I don't want to learn another tool which costs time.
(comments are locked)
|
