|
|
#1
10-27-2022, 05:41 AM
|
|||
|
|||
COUNT TRIPLETs present in an array of values
The following formula: =SOMMA(SE(FREQUENZA(SE($A$3:$M$7=O3;RIF.RIGA($A$3: $M$7);SE($A$3:$M$7=P3;RIF.RIGA($A$3:$M$7);0));RIF. RIGA($A$3:$A$7)-1)=2;1;0)) manages to count PAIRS present in a given array of values … QUESTION: HOW can it be modified to count triplets instead of Pairs of values? Sample file attached. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 COUNT TRIPLETs present in an array of values
|
AP41-at-OfficeFORUM | Excel Programming | 1 | 10-27-2022 11:22 PM |
| How To Make A Formula To Count Only 2 Values Between 01 To 100 | xrfsna | Excel | 3 | 05-12-2017 11:27 AM |
| Count max of x values | timbrignall | Excel | 2 | 05-10-2016 07:45 AM |
| How do you loop through an array with some empty values? | omahadivision | Excel Programming | 5 | 11-28-2013 10:49 AM |
| How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |
Windows 10 
Office 2019
Threaded Mode