View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hicks Hicks is offline
external usenet poster
 
Posts: 2
Default IF Function and ignore if

Hi there

I need a If statement to Extract data in a worsheet array column B IF COLUMN
A IN THAT Worksheet meets a certain condition else the if statement must
ignore those that does not meet the condition and loop to the next row that
meets the condition.