Forum Discussion
Taking information where a column is blank to create a column in another part of Excel sheet
I want to take the information in column A in the Program of Study where column D IS BLANK and put the results and place the results in column N in the New Data part of the sheet. Is there a formula ...
Hi Robert Cobb
In your case, i will
1. Apply filter "Blank Cells" in "Column D" in "Program of Study".
2. Then select data top to bottom in "Column A".
3. Will Select visible cells of "Column A" and copy them
4. Then go to "New Data", will paste where i want.
There is no way to simply do it. Ask me if you have doubts.