If function to list.

[bartoni]

Hi,

The last thing i need to figure out is a little complicated. Ive got an IF formula in sheet1 which returns specific products in column A depending on criteria specified in the IF function. If prds dont fulfil the criteria, a blank is returned.

Now this formula goes down 4000 rows. The only problem is these products appear intermitently within the column since some fulfil the criteria and some dont (if so a blank appears i the cell). I need to somehow make them appear one after each other in another sheet (sheet2). Is there an If formula that can return all cells with prd names in them one after each other.

Thanks

 

[andy3816]

cant you just use a filter, and filter the data on non blanks