I want to filter data in excel

  Kiến thức lập trình

I have data in excel, there are around 30 columns having some values in each column. I want to filter data based on the primary key i.e. say serial no and want to know the column name where data is not filled or it is blank. PLease help with the function that can be used for the same in excel.
Thank you for the help in advance.

Please help with the funstion that can be used to filter the data where the fields in the column is not updated or data is not there in the column. The filter should be on the base of serial no that is the primary key.
I selected say serial no one after putting the filter on the header column, then i should get all the fields in all the columns of the excel where data is not assigned or filed is blank in the excel.

New contributor

Pratik Dwivedi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.