Thread: Return true if multiple cells are the same
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default Return true if multiple cells are the same
Another way:

=COUNTIF(A1:E1,A1)=5

Biff

"linglc" wrote in message
...
I have cells A1 to E1 with same values. In cell F1, I want to return "true"
if cell A1=B1=C1=D1=E1. The result I get was #N/A when I enter the formula
"=A1=B1=C1=D1=E1". Anyone knows the answer?


Reply With QuoteReply With Quote