So are you saying that if your raw data sheet has anything in Col F on a particular row then that row should referenced by a formula in the cleansed sheet ? Why cant you sort the Raw Data Sheet by Col F, and then copy all the rows with a value in F across to your cleansed sheet?
Bookmarks