Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

file How to Extract Highlighted Cells

More
11 months 1 week ago #3085 by hartwith21
How to Extract Highlighted Cells was created by hartwith21
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.

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee