Questions

Excel

+
0 Votes
Locked

Excel

suemiller59
first second third forth fifth
1 11 28 33 11
1 11 13 11 25
2 8 23 25 36
2 3 4 19 23
3 4 27 30 36
1 13 22 23 11
3 7 8 16 19
3 12 15 17 22
4 5 1 20 23
4 7 10 14 27
5 9 12 31 32
6 13 27 28 34
6 11 15 32 1
7 14 17 42 44
8 20 36 43 45
8 24 27 1 34
8 9 19 28 31
9 24 11 32 1
12 18 26 35 40
16 22 24 30 39
19 11 39 44 45
20 24 33 34 37
23 1 28 33 44
26 29 30 42 43

I've got a friend who is doing spreadsheets and has to do a count, then create a table comparing the number 11 and what it appears with. This is a major problem, as we spent the whole of the day Bank Holiday Monday stuck in front of two laptops, with many books and many websites trying to find out how to do it and nothing. What is the function she needs, as I am no longer teaching spreadsheets (now having to teach Literacy and Numeracy), I really can't lose sleep over this, any chance you could point me in the right direction and then I could point her and leave her to it. We tried http://support.microsoft.com/kb/100122 , http://www.ehow.com/how_4480973_make-frequency-tables.html , a good three hours on http://office.microsoft.com/training/training.aspx?AssetID=RP061914881033&CTT=6&Origin=RP061914871033 , http://office.microsoft.com/en-us/excel/HP052090291033.aspx . Big zilich, nadda, nothing.

Can someone point me in the right direction. I am amths teacher and not a computer teacher so I am frustrated as what she needs to do won't work.