Thursday, 18 February 2021
  0 Replies
  2.9K Visits
0
Votes
Undo
I have used Kutools "same & different cells" to highlight a number of non-contiguous cells by comparing the content of two separate Excel columns. The different cells are now highlighted with a coloured background in column A. How can I use Kutools to extract the highlighted cells into a third column but so that each cell will be contiguous above one another listed immediately above one another without white space.
I can obviously copy and paste each cell manually but that would seem a tedious process when I have Kutools available to me.
There are no replies made for this post yet.