Dear All,
I do have a sample data set as follows.
I would like to count the maximum & minimum occurrence from the data set.
I have written a formula which is yielding the correct count of the maximum occurrence but I am unable to find out how write the same for the minimum occurrence.
Here in this case the count of the minimum occurrence needs to be 1(since number 3 is there only once).
Could somebody help me out with the formula in C2 which can deliver the desired result?
Regards
Sheet1
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"><col style="width: 194px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
I do have a sample data set as follows.
I would like to count the maximum & minimum occurrence from the data set.
I have written a formula which is yielding the correct count of the maximum occurrence but I am unable to find out how write the same for the minimum occurrence.
Here in this case the count of the minimum occurrence needs to be 1(since number 3 is there only once).
Could somebody help me out with the formula in C2 which can deliver the desired result?
Regards
Sheet1
* | A | B | C |
1 | 1 | Count Of Maximum Occurrence | 6 |
2 | 2 | Count Of Maximum Occurrence | * |
3 | 3 | * | * |
4 | 2 | * | * |
5 | 1 | * | * |
6 | 1 | * | * |
7 | 1 | * | * |
8 | 1 | * | * |
9 | 1 | * | * |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"><col style="width: 194px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas | ||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4