Thread: [Solved] Comparing 2 columns of Text
View Single Post
 
Old 02-03-2012, 08:29 AM
teshurtz teshurtz is offline Windows 7 64bit 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