Thread: Array Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sarah
 
Posts: n/a
Default Array Formula

I would like to compare a range of data in 2 different column, using an array
formula?

I need to compare if the figures in Column K is greater the figures in
Column J?

Would this be the right formula to use?

{=IF(K10:K60J10:J60,1,0)}

If it is, i can't seem to get the right answer. Is there something wrong
with my formula?
--
sarah