x
login register about faq

How to find out the record of each users' last site visit ?

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.

more ▼

asked Jan 15, 2013 at 12:15 AM

DeanTaylor gravatar image

DeanTaylor
17 4 5 6

(comments are locked)
10|600 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jan 15, 2013 at 05:15 AM

JessicaQiu gravatar image

JessicaQiu
17 8 10 10

(comments are locked)
10|600 characters needed characters left

Hi Jessica, thanks for your comment. But I still like to use Excel. I don't want to learn another tool which costs time.

more ▼

answered Jan 15, 2013 at 10:51 PM

DeanTaylor gravatar image

DeanTaylor
17 4 5 6

(comments are locked)
10|600 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Topics:

x5
x2
x2
x1
x1

asked: Jan 15, 2013 at 12:15 AM

Seen: 726 times

Last Updated: Jan 15, 2013 at 10:51 PM