Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function for two columns in diffent cases
I have two columns that I need to compare and get a TRUE or FALSE answer on
if the text in the columns match. The problem is that the case of the text in the two columns is different. One column is in all CAPS and the other is using Proper formatting. I have tried using the IF function after converting one column to all CAPS using the UPPER formula, but it still returns a FALSE even if the colums match. Is there another way to get a TRUE or FALSE since the cases do not match? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function for two columns in diffent cases
Doesn't sound like case is the problem. Try TRIM ing the cells to remove any
leading/trailing spaces. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pt_lily" wrote in message ... I have two columns that I need to compare and get a TRUE or FALSE answer on if the text in the columns match. The problem is that the case of the text in the two columns is different. One column is in all CAPS and the other is using Proper formatting. I have tried using the IF function after converting one column to all CAPS using the UPPER formula, but it still returns a FALSE even if the colums match. Is there another way to get a TRUE or FALSE since the cases do not match? Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function for two columns in diffent cases
pt_lily,
=A1=B1 will return TRUE independent of case. You would actually need to use =EXACT(A1,B1) to show differences in case. HTH, Bernie MS Excel MVP "pt_lily" wrote in message ... I have two columns that I need to compare and get a TRUE or FALSE answer on if the text in the columns match. The problem is that the case of the text in the two columns is different. One column is in all CAPS and the other is using Proper formatting. I have tried using the IF function after converting one column to all CAPS using the UPPER formula, but it still returns a FALSE even if the colums match. Is there another way to get a TRUE or FALSE since the cases do not match? Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function for two columns in diffent cases
Thank you for the help. That seems to be what the problem is. All of the
text in one of the columns has several trailing spaces at the end. Is there a way to get rid of these without doing it all manually? My spreadsheet has about 6,000 lines. Thanks again! "Bob Phillips" wrote: Doesn't sound like case is the problem. Try TRIM ing the cells to remove any leading/trailing spaces. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pt_lily" wrote in message ... I have two columns that I need to compare and get a TRUE or FALSE answer on if the text in the columns match. The problem is that the case of the text in the two columns is different. One column is in all CAPS and the other is using Proper formatting. I have tried using the IF function after converting one column to all CAPS using the UPPER formula, but it still returns a FALSE even if the colums match. Is there another way to get a TRUE or FALSE since the cases do not match? Thank you! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function for two columns in diffent cases
Just cater for it in the formula
TRIM(B3) for instance -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pt_lily" wrote in message ... Thank you for the help. That seems to be what the problem is. All of the text in one of the columns has several trailing spaces at the end. Is there a way to get rid of these without doing it all manually? My spreadsheet has about 6,000 lines. Thanks again! "Bob Phillips" wrote: Doesn't sound like case is the problem. Try TRIM ing the cells to remove any leading/trailing spaces. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pt_lily" wrote in message ... I have two columns that I need to compare and get a TRUE or FALSE answer on if the text in the columns match. The problem is that the case of the text in the two columns is different. One column is in all CAPS and the other is using Proper formatting. I have tried using the IF function after converting one column to all CAPS using the UPPER formula, but it still returns a FALSE even if the colums match. Is there another way to get a TRUE or FALSE since the cases do not match? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Cases=144 * # of Cases + Pieces | Excel Discussion (Misc queries) | |||
formula for coping a cell from a diffent sheet | Excel Discussion (Misc queries) | |||
Code to Ignore Certain Cases in a Looping Function | Excel Programming | |||
map data (x-y axis) with diffent series name | Charts and Charting in Excel | |||
GCD Function doesn't work in some cases | Excel Worksheet Functions |