Ask Experts Questions for FREE Help !
Ask
    ali_burgan's Avatar
    ali_burgan Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 23, 2010, 07:06 AM
    Using Excel, how can I make an equation for the below mentioed example.
    Name Date
    George 5/1/2008
    Jessica 5/2/2008
    Sam 5/3/2008
    George 8/1/2008
    Jessica 5/5/2008
    Sam 5/6/2008

    How many rows (dates) falls during each month in year 2008 that corrospond a name.
    Answer: George should have 2, others are zero.

    Thanks
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Oct 23, 2010, 08:06 AM

    You would be better off using a pivot table for this.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How do I make a invoice template in Excel but have it make copies from 1 to 1000 [ 2 Answers ]

I have to make an invoice template but have it make copies from 1 to 1000 using Excel or Excel and Mail Merge

Can someone explain step by step how to make x the subject in an exponential equation [ 2 Answers ]

Can someone explain step by step how to make x the subject in an exponential equation? I know the general form is y = ae^kx So the just say I need to find out at what time would the experiment be at its half life which is 50, so I sub 50 into the following equation: y = 92.776e^(-0.701t)...

How do I make this equation? [ 1 Answers ]

Okay, I understand algebra quite well. My brother, whom is 2 years older then me has already done the homework I am currently working on. He won't help though, My dad don't know, And My step-mom won't help either. I have tried and tried to get this answer. I wouldn't normally be going to a huge...

View more questions Search