Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can do this with a filter. Select all the cells. On the main menu choose Data/Filter/Standard Filter. Make the condition column1 = .* (that's a period followed by an asterisk, i.e. everything) Choose More Options and check the boxes Regular expression and No duplication, then click OK The filtered list will be highlighted. You can copy and paste to a different part of the page or to a different sheet.