Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2022, 06:24 AM
AP41-at-OfficeFORUM AP41-at-OfficeFORUM is offline COUNT TRIPLETs  present in an array of values Windows 10 COUNT TRIPLETs  present in an array of values Office 2019
Novice
COUNT TRIPLETs  present in an array of values
 
Join Date: May 2021
Location: Italy
Posts: 17
AP41-at-OfficeFORUM is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Count-triplets in array of values.xlsx (12.1 KB, 8 views)
Reply With Quote
  #2  
Old 10-27-2022, 11:22 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline COUNT TRIPLETs  present in an array of values Windows 10 COUNT TRIPLETs  present in an array of values Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,667
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

Duplicate thread https://www.msofficeforums.com/excel...ay-values.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
COUNT TRIPLETs  present in an array of values How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft