I'm trying to write a formula to see if 2 values equal each other until an empty cell.

For example
A B
1: John, 15
2: Mike, 30
3: Scott, 33
4: Kevin,55
5:
6: Mark, 23
.
.
.
37: John, 15
38: Mike, 30
39: Scott, 33
40: Kevin,55
A41:
A42: Joe, 21
.
.
.


I can just write =if(and(B1=B37,B2=B38,B3=B39,B4=B40),"Equal","Not Equal") but the problem is that the row of the empty cell always changes.

I know how to find John even if it's no longer in cell A37 but I don't know how to tell it to stop checking if it's equal or not until the blank cell. Do I have to write a macro?

Thanks