Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-11-2017, 11:27 AM
xrfsna xrfsna is offline How To Make A Formula To Count Only 2 Values Between 01 To 100 Windows 10 How To Make A Formula To Count Only 2 Values Between 01 To 100 Office 2013
Novice
How To Make A Formula To Count Only 2 Values Between 01 To 100
 
Join Date: May 2017
Posts: 2
xrfsna is on a distinguished road
Default How To Make A Formula To Count Only 2 Values Between 01 To 100

Expl. I want to know how many times the number 23 left with the number 15> ex 15 along with 23 left 1 time together

Expl. I wonder how many times the number 23 left with the number 96> ex 15 along with 96 left 1 time together

Expl. I wonder how many times the number 71 left with the number 96> ex 15 along with 71 left 1 time together

So successively

And that I have 5 thousands from the 1st to the 5th prize, but in each award can repeat the draw of the ten in each prize Because each prize is drawn ten of 01 oo or better 100 would like to know how to count only 2 certain value Among the five prizes more There can be a draw of ten duplicates so I need a formula for the specific case on top 1 and the 100 or 00 and so on
Assinar
01323 23
53015 15
32796 96
72271 71
57902 02


Tipo de Alteração



0




Expl. quero saber quantas vezes o número 23 saiu com o número 15 >ex 15 junto com 23 saiu 1 vez junto

Expl. quero saber quantas vezes o número 23 saiu com o número 96 >ex 15 junto com 96 saiu 1 vez junto

Expl. quero saber quantas vezes o número 71 saiu com o número 96 >ex 15 junto com 71 saiu 1 vez junto

Assim sucessivamente
E que tenho 5 milhares do 1º ao 5º prêmio, mas em cada premiação pode repetir o sorteio das dez em cada premio Pois cada prêmio é sorteado dez de 01 oo ou melhor 100 gostaria de saber como contar só 2 determinado valor Entre os cinco prêmios mas pode ocorrer sorteio de dez duplicada por isso preciso de uma formula para o caso específico em cima 1 e o 100 ou 00 e assim sucessível
01323 23
53015 15
32796 96
72271 71
57902 02
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Duplicate Values without a specific Unique Value Brittni Excel 1 02-01-2017 06:22 PM
How To Make A Formula To Count Only 2 Values Between 01 To 100 Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
Count max of x values timbrignall Excel 2 05-10-2016 07:45 AM
How To Make A Formula To Count Only 2 Values Between 01 To 100 Count unique values that match 2 or more criteria caeiro01 Excel 1 10-25-2015 02:34 AM
How To Make A Formula To Count Only 2 Values Between 01 To 100 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 11:08 PM.


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