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...
Jasmine770 Following formula will work to all version of excel. You may download the attached file.
=IFERROR(INDEX(Sheet1!A:A,IF(A2=TRUE,ROW(A2),"")),"")