text: excel formula? i have a sheet on excel called 'orderingsheet' and in a5:a60 there is a product name and in the cells j5:j60 it says yes or no dependant on another value. i need a formula which will show, on a sheet called 'orderform', the product names if it says yes. 1. in the "orderingsheet", click data > filter > autofilter 2. use the filer in j column to select the "yes" only 3. copy the product names in a column & paste them to "orderform" 4. if you have certain format/font that you have setup in the "orderform" sheet, and it's different from the format in "orderingsheet" page, then use copy & "paste special" (under "edit"), then select "paste value" - this will let you preserve the format setup in "orderform"