Get refief form missing info

  • Hi All,


    I have a sheet with 45,000 data with 22 columns like below with unnecessary fields and missing info. missing info means acount name is there but email is not. again account ID is there but phone number is blank.



    • Account ID
    • Account Owner
    • Account Name
    • Email
    • Phone Number
    • Specialization etc.. In another sheet I want to take the necessary fields info and another sheet I want to get the missing info list.
    • Account ID
    • Account Name
    • Phone Number
    • Email


    In one sheet I want the data with all info means there will not be any blank in my necssary column.


    In another sheet I want the data for which I have account Number but not the email or as said above in bold.


    How do I do that?


    Please help!!

  • Re: Get refief form missing info


    Have a look at Data > AutoFilter


    It allows you to filter on blanks or non-blanks and then then you can use copy + paste into the other sheet

    There are three types of people in this world.
    Those who can count and those who can't.