JordanN
Reputation: 45
Compare cell to range of cells
I have two columns of cells with numbers. For each cell in column B, I want to check whether column A has a value less than it. If column A has a lesser value, return True otherwise return False. Any ideas?
Upvotes: 0
Views: 2862
Answers (2)
Bleh
Reputation: 451
You can find the minimum value in column A and compare it with the value in a particular cell of B, say B1.
=IF(B1 > MIN(A1:A5), TRUE, FALSE)
Upvotes: 1
Chris Moore
Reputation: 456
If you need to compare each cell in column B against all values in column A, you can use:
=IF(COUNTIF(A:A,"<"&B1)>0,TRUE,FALSE)
Upvotes: 1
Related Questions
- Compare multiple cells inside the same column in Excel
- Comparing two cells with two other cells in Excel
- Is there a shorthand way to compare a range of cells to a single value?
- Check if multiple cell ranges are equal
- Compare a cell to a range of cells in a workbook and set the result as another range of cells
- Excel Formula If a value matches a value in a range of cells then return corresponding value in a different cell
- Excel How to compare 2 Column Ranges
- compare a part of a cell with the another column
- IF Statement on Range Of Cells
- Compare two cells for different values in Excel