| 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! |
| 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 | |||
Threaded Mode
