Comparing Text Between Cells

[aramey]

I want to compare the text in two cells and with the result of the comparison manifesting as a percent that explains the accuracy between the text in the two cells.

For example, cell A1 would have the words: "Mostly Cloudy/Breezy"
Cell B1 would have the words: "Breezy"
Cell C1 would be the percentage of accuracy between the cells A1 and B1

 

[Robert Mika]

HI aramey and welcome to the board
In this example what the % woudl be?
You can go with this in C1:

=IF(ISNUMBER(FIND("Breezy",A1)),1,0)
(format cell as %)
and the result is 100%
What other option do you consider?

 

[Yahya]

See if this will help too
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Mostly Cloudy/Breezy</td><td style=";">Breezy</td><td style="text-align: right;;">400%</td><td style="text-align: right;;">40%</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Mostly Cloudy/Breez</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Mostly Cloudy/Br</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Mostly Cloudy/No</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Mostly Cloudy/1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Mostly Cloudy/2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Mostly Cloudy/3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Mostly Cloudy/Breezy</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Mostly Cloudy/Breezy</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">Mostly Cloudy/Breezy</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C1</th><td style="text-align:left">=COUNTIF(<font color="Blue">A1:A10,"*"&B1&"*"</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D1</th><td style="text-align:left">=COUNTIF(<font color="Blue">A1:A10,"*"&B1&"*"</font>)/COUNTA(<font color="Blue">A1:A10</font>)</td></tr></tbody></table></td></tr></table><br />

 

[aramey]

Great, helpful answers. I should probably give a little more detail to explain what I'm trying to accomplish.

So the "Mostly cloudy/breezy" is the hourly weather condition from the National Weather service. I've set up the spread sheet to import that automatically.

I want to compare that information with information that is manually entered to see how accurate the manual entry (which would be forecast information) is to the actual observation.

So cell A1 would have "Mostly Cloudy/breezy" (or whatever the current observation would be .. sunny, rain, cloudy, clear..etc.)

Cell B1 would be the manual entry (forecast information from a meteorologist).

Cell C1 would tell me the accuracy of B1 compared to A1.

I'm trying to track the accuracy of a weather forecast.

Thanks.