How to make a list of stores in the order they have been visited?

[schappelljr]

I am trying to make a list of stores in the order they have been visited. The data has the store name and time of when each transaction has taken place. Sometimes in the same day they will go back to the same store. I want to see what store they have been to and the order they visited in. I tried removing duplicates but it won’t work if they go back in the venue in the same day. I would like to use a pivot table if possible, but any suggestion on how to make this list?

Store name	time
Store 1	12:00 pm
Store 1	12:30 pm
Store 1	1:00 pm
Store 2	1:39 pm
Store 2	2:00 pm
Store 1	2:30 pm
Store 3	3:30 pm
Store 3	4:00 pm

<tbody>
</tbody>

Answer

Store 1

Store 2

Store 1

Store 3

<tbody>
</tbody>

 

[MickG]

Perhaps this:-
Results in column "D"

[COLOR="Navy"]Sub[/COLOR] MG19Dec55
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] Temp [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
    [COLOR="Navy"]If[/COLOR] Not Dn.Value = Temp [COLOR="Navy"]Then[/COLOR]
        c = c + 1
        Cells(c, "D") = Dn.Value
    [COLOR="Navy"]End[/COLOR] If
    Temp = Dn.Value
[COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[schappelljr]

Thanks that works but after thinking about it how would I also add the time next to it?

Store 1	12:00pm
Store 2	1:30pm
Store 1	2:15 pm
Store 3	3:15 pm

<tbody>
</tbody>

 

[MickG]

Which of the times per store, do you want ???