Excel count if
Closed
edonkatz
-
Feb 28, 2011 at 06:28 PM
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - Mar 5, 2011 at 01:25 AM
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - Mar 5, 2011 at 01:25 AM
Related:
- Googlle doc
- How to count names in excel - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
2 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 1, 2011 at 05:31 AM
Mar 1, 2011 at 05:31 AM
Use Pivot Table for this.
Put Student Name is Row labels
Marks In column lebels
and again student name in values label
Put Student Name is Row labels
Marks In column lebels
and again student name in values label
eskagsms
Posts
24
Registration date
Wednesday February 9, 2011
Status
Member
Last seen
May 30, 2012
Mar 5, 2011 at 01:25 AM
Mar 5, 2011 at 01:25 AM
Hi, you could use the autofilter feature to get unique values from column A to another column and use countif function. If you can share the Google Docs with me, I can help you. Thanks.
Mar 1, 2011 at 06:56 AM
Mar 4, 2011 at 05:31 PM
Mar 5, 2011 at 12:30 AM