Forum Discussion

Robert Cobb's avatar
Robert Cobb
Copper Contributor
May 19, 2018

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 or function that will help me accomplish this. The Program of Study and New Data are on the same sheet in the Excel Workbook.

Excel Desktop
Formulas & Functions

1 Reply

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Iron Contributor
    May 19, 2018

    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.

Resources