Thread: two arrays correction
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
dmexcel
 
Posts: n/a
Default two arrays correction
f2=If($F$1=A2,"Yes","")
copy this formula accross to J
then highlight F1:J1
copy (ctrl c)
Highlight the F3:J150 or however far down this goes
and then paste (Ctrl v)

Reply With QuoteReply With Quote