Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Eva Hughes on Dec 02 In MS Office Category.

sort unmatched cells

Question Answered By: Mercedes Andrews on Dec 02

May this help you
Enter following formula in C1
=if(countif(A$1:A$30000,C1)>1,"y","n")
Copy the same uuto C30000
Select c1:c30000
Select copy
Select paste special
Select values
Sort entire data on column c

This Question has 1 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on sort unmatched cells Or get search suggestion and latest updates.

Related Topics:

Retain cell selection through sort
Sort where a selected cell is preserved
Copying current cell's value to another cell
Sort an array (Bubble sort)
Sort an array (Bubble sort) - Signed
Sort the Sheet & Sort or Filter Columns
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
Function needed to split the content of a cell into many cells
Moving data in the last cell of row to another column cell
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
how are cell coordinates referenced on a clicked cell
to see if text in a cell in a column is contained in any cell
Copy cell contents to same cell on different worksheet if contains
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
A Paragraphs in one cells --> convert into a line in per cells
Cell validation based on the contents of previous cell
How to copy automaticly (..using VB) my active cell after cell entry in different cell in anoth

Tagged:sort unmatched cells

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us