Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 02-03-2012, 08:29 AM
teshurtz teshurtz is offline Comparing 2 columns of Text Windows 7 64bit Comparing 2 columns of Text Office 2010 64bit
Novice
 
Join Date: Feb 2012
Posts: 4
teshurtz is on a distinguished road
Default

I am not exactly sure what you are looking for but I think it is this, you want a counter that will count how many wins there are vs losts? or do you want a number that says how many times there have been more wins than losses (like you have 20 columns of data, each with a list of win or lost in each cell, so a column would represent a single match of 10 games for example and then there are 20 matches and you want to see how many matches each person won?)

if all you want is to see how many wins are in a column or how many lost
label a1 as "wins" then in a2 =countif(c:c,"win")
and cell b1 as "losses" and in b2 =countif(c:c,"lost")

the countif function counts the number of cells within the range (in this case c:c for all of column c) that equal a given value (in this case the word win or lost)

if you want more of the second scenario I listed you could expand on the idea. make a1 say wins and a2 =if(countif(c:c,"win")>countif(c:c,"lost"),1,0)
than make a3 say lost and a4 =if(countif(c:c,"lost")>countif(c:c,"win"),1,0)
if you put a similar set of counters next to each column of win/lost then you can sum all of row 2 and 4 to get the totals.

if neither of those are what you are looking for please be as descriptive as possible in what you want to do.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing 2 columns of Text Pasted text comes in columns yotas312 Word 2 11-12-2011 07:58 AM
Comparing 2 columns of Text The text in the two columns are not in the same level!!!! why? Jamal NUMAN Word 22 10-18-2011 09:00 AM
Comparing 2 columns of Text Advanced Filter - Comparing Two Columns apolloman Excel 5 07-27-2011 04:54 AM
Comparing 2 columns of Text text in columns not even KENDO Word 1 01-22-2011 01:06 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 AM.


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