In this excel first we have to put filter in L column to get empty values and then we have to put filter for column A for non empty values then finally we have to take L1 cell value its a vlookup formula we have to put in all the empty cell of column L
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Apply filter in existing excel column, we have to apply filter without #N/A and empty cells | 5 | 146 | March 3, 2024 | |
I want to put filter for empty cells in this excel and copy the L1 cell value and paste it in rest of the empty cells in L column | 3 | 144 | March 7, 2024 | |
I want to apply filter in L column in existing Excel | 3 | 114 | March 7, 2024 | |
Filter empty cells, and then write a formula | 2 | 1667 | March 8, 2022 | |
I want to filter existing excel L column with NA and empty values but the problem is L1 column has some NA values so actual column starts from L2 cell | 1 | 83 | March 19, 2024 |