Forum Discussion
Excel: How to populate a column in one sheet with only another column of another sheet?
Hi, I am trying to improve some datasheets for my research and I'm trying to figure out how to streamline some stuff. Basically, I have three sheets "Sheet 1" "Sheet 2" and "Sheet 3". They're all...
If you have Excel 365 then you can use FILTER
=FILTER(A:A, E:E="TRUE", "")
so the format is FILTER( range-to-filter, conditional, if-not-found )
so the range to filter could be A:A for just column A or A:F for the whole table or if you are using Table Format it could be Data-Set[Ind_Code]
the conditional can be simply E:E to return when column E returns anything that evaluates as true or specifically E:E="TRUE" if that is text or you can do something like (E:E="TRUE)*(F:F="FALSE") to only return rows with TRUE in column E AND FALSE in column F
=FILTER(A:A, E:E="TRUE", "")
so the format is FILTER( range-to-filter, conditional, if-not-found )
so the range to filter could be A:A for just column A or A:F for the whole table or if you are using Table Format it could be Data-Set[Ind_Code]
the conditional can be simply E:E to return when column E returns anything that evaluates as true or specifically E:E="TRUE" if that is text or you can do something like (E:E="TRUE)*(F:F="FALSE") to only return rows with TRUE in column E AND FALSE in column F