Dear All,
I do have a sample data set across A1:E4.
The data represents the NO Of BINs in which the SKU is kept at the DC.
I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period.
The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2)) & so on.
Could somebody help me out with the formulae across G2:G4 which can populate the desired result as shown below?
<tbody>
</tbody>
I do have a sample data set across A1:E4.
The data represents the NO Of BINs in which the SKU is kept at the DC.
I would like to figure out the dates on which the no of BINs is more than the Modal no of BINs across a given period.
The formulae put in F2=COUNTIF(B2:E2,"<>"&MODE(B2:E2)) & so on.
Could somebody help me out with the formulae across G2:G4 which can populate the desired result as shown below?
SKU | 01-Oct | 02-Oct | 03-Oct | 04-Oct | Non Modal Frequency | Desired Result |
A | 4 | 3 | 4 | 4 | 1 | 02-Oct |
B | 8 | 8 | 9 | 10 | 2 | 03.10.2017/04.10.2017 |
C | 12 | 15 | 12 | 12 | 1 | 02-Oct |
<tbody>
</tbody>