if-statementgoogle-sheetsspreadsheetequalitycountif
How to get Google Sheets to reliably compare text cells that include "<" and ">"?
As you can see in this sample scenario, I am having trouble reliably comparing cells A and B. It seems to have something to do with the "<" and ">" signs.
In my actual use case, I let conditional formatting highlight repeated values in a column using a formula similar to the one in cell C1 =countif($A2:$A,$A2)>1. However, that formula becomes totally unreliable when cells contain the "<" and ">" signs. This is a problem because I want to compare text cells that often contain HTML.
What’s the matter and is there a workaround?
I also recreated the image above using a table:
| A | B | =if(countif($A2:$B2,$A2)>1,"Yes","No") |
|---|---|---|
| whatever> | <whatever | No |
| <> | whatever | Yes |
| whatever | <> | No |
| <><> | <> | No |
| <>whatever | <whatever> |
Yes |
| <>whatever | <>whatever | Yes |
| whatever<> | <whatever> |
No |
| whatever<> | <>whatever | No |
| ><>< | No | |
| ><>< | <whatever> |
Yes |
| <><> | Yes | |
| <><> | <whatever> |
Yes |
| <>< | >< | Yes |
| <>< | <> | Yes |
| ><> | >< | Yes |
| ><> | <> | No |
| <> | ><> | Yes |
| < | > | No |
| > | < | No |
| <> | >< | Yes |
| >< | <> | Yes |
| << | >> | No |
| >> | << | No |
| << | <> | No |
Solution
to compare A1 to B1 formula is:
=ARRAYFORMULA(IF(A1:A24=B1:B24, "Yes", "No"))
- Fat-Free Framework Template Conditional Rendering Issue on Template
- Print a multiplication table in Python
- Can you store a variable inside a if-clause?
- How do I test for exceptions in if-statements in python?
- How to write lambda function with three conditions
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- If condition that matches if grep outputs at least one result even though the exit code is 2 due to some permission denied
- Why does `ifelse()` behave differently than `if (cond) {...} else {...}`?
- A Return inside and outside an If Statement
- How can I use "*ngIf else"?
- How to check repeated letters in a string c#
- How to create an 'empty if statement' in Python
- How to avoid if statement? for the compiler cannot optimize it to simd
- Test if it exists a node HXT
- python else statement causes a continuous loop
- Series of if vs else-if statements benchmarking
- Google Sheets - make a list of the names in column A where column E is greater than zero
- Condition evaluation process in Java
- Excel - Array Formula to skip empty cells
- Groups of compound conditions in Bash test
- How to use the IF statement to avoid the Weather API fetch result crashing once the user types wrong the city name?
- Comparing Text with a lot of If/else
- Count cells with two conditions
- New containing div after every 3 records
- Which one of the logical AND (`&&`) and logical OR (`||`) operators take precedence over the other?
- Macro to generate chained else ifs
- Java: break statement in "if else"
- Group of conditions in IF THEN statements in VBA
- Evaluate boolean environment variable in Python