Hi all,
I'm sure there will be some of you shaking your heads in disbelief but I realized this morning that I am absolutely useless with Excel formulas.
I have a user table showing users joined to my site as well as the date they joined etc.
All I want to do is create a chart showing how many users joined on each day.
So I need to get the amount of times a date occurs in the column, displayed next to the specific date.
Can anyone help please?
Thank you in advance.
Last edited by eben80; 10-23-2008 at 05:36 AM.
Hi and welcome to the board.
Why attach an image when you need a sheet?
This being said, the easiest way is to use a Pivot Chart . Go to data Pivot Table and chart and follow the wizard
HTH
To just show the count against the first instance of each date put this formula in E2 and copy down column
=IF(C2=C1,"",COUNTIF(C:C,C2))
Thanks a lot. That did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks