The vistor data is in a single column in Y/M/D format. I am kind of stuck
here. There are 800 such entries. A sorting function helps me only partially.
After this I wish to count number of entries for each date

"mangesh_yadav" wrote:


Assuming your data is something like
1-jun-05 25
2-jun-05 45
3-jun-05 18
and so on

Simply select both the columns, go to sort, and sort on column B

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379969