View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leibtek
 
Posts: n/a
Default IF Formula to go through every line of array


Enter this formula in B1 as an array using the key combo of

CTRL,SHIFT,ENTER:

I'm not sure how to do that...


Also, when you say "Match(1," what are referring to with the "1"?

Thanks,
Leibtek


--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile: http://www.excelforum.com/member.php...o&userid=32287
View this thread: http://www.excelforum.com/showthread...hreadid=520424