The cells at column A are first sorted for valued cells only.
As format of cells (Cell A7) is copied to valued cells at column A under sorting,
the unsorted cells are also formatted as attached file.
How to copy format to other cells under sorting, without copying format to unsorted cell?
(as shown in expected results in column B)
Bookmarks