One way:

Select 4 cells across, say J1:M1. Array-enter (CTRL-SHIFT-ENTER or
CMD-RETURN):

=IF(E1=E2,A1:D1,"")



In article ,
bern23 wrote:

Does anyone know how....

I can display a range of cells, if an if statement condition is met
so

if e1=e2 then
i need to display a1:d1 into a different range