Let's say I have an Excel spreadsheet aggregating votes in some poll over a period of time as per the example below.
How do I find the min and max value people have voted on on a given day (the column header)?
A B C D E F G H I
--------------------------------------------------
1 | Answers: | 0 | 1 | 2 | 3 | 4 | 5 | Min | Max |
--------------------------------------------------
2 | 2014-12-01 | | 2 | 4 | 1 | | | 1 | 3 |
3 | 2015-01-01 | | | 1 | 4 | 2 | | 2 | 4 |
^ ^ ^-----^- Min: 2, Max: 4
| |
| |_ 2 people voted "4"
|
|_ 1 person voted "2" on 2015-01-01