Can you help me answer this question about counting categorical data with Excel?

Answer Use the countif function. For example:=Countif(A:A,"B")This will tell you how many cells in column A have the value "B". You can replace "B" with the name of the campus. Repeat this command for ... Read More »

Top Q&A For: Can you help me answer this question about coun...

Can you transfer data from Outlook to Excel and have Excel lay out the data in a calendar format?

There is is no easy way to do what you are requesting.It might be easier to use MS-Access for this, since it would be much easier arranging and handling the data..

Counting words or phrases in excel 2007?

Because you are probably wanting to search every cell in all Worksheets within the whole Workbook, then I would suggest creating some VBA code and making that available as a macro you could run.I s... Read More »

All my data is off by 2 rows in Microsoft Excel, is there a way to move all the data w/o starting over?

Using the INSERT Row, at the row where you wish one extra row to be added above it, will do the trick. Or you can select all of your cells with data in them, use the CUT, and then just PASTE all t... Read More »

Excel 2007: How to Import Data From One Excel Sheet to Another?

In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just one of the many programs that is capable of creating and working with ... Read More »