View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] rrstudio2@icqmail.com[_2_] is offline
external usenet poster
 
Posts: 29
Default Search Range for item in seperate range

Thanks, this seems to work, however I can't say I understand the
formula. I haven't seem the -- before, what does that do? So it looks
like transpose is creating an array, how is checking the array
different than simply checking a range such as L1:O1?

-Andrew