Filter Numeric value appearing once

[nirola]

Hi,

I have 500 columns with numbers appearing - invoice numbers only in numbers like 12234.

These invoices are also appearing twice or thrice in the same column and few are appearing only once.

There are others column corresponding this column with amount city details.

My requirement is to flush out all the invoices appearing just once and put them at the end of the invoices which are appreaing more than once.

Help required.

Thanks
San

[alski]

Any chance you can post a sample of the spreadsheet with fake data?

[martindwilson]

do you mean rows with invoice numbers?
if so put in a spare column
=COUNTIF(A:A,A2)>1 where A is the column invoice numbers are(with a header row) it will give true if more than 1 false if not
drag down to end
then select every thing
then sort descending on the true/false column

[nirola]

do you mean rows with invoice numbers?
if so put in a spare column
=COUNTIF(A:A,A2)>1 where A is the column invoice numbers are(with a header row) it will give true if more than 1 false if not
drag down to end
then select every thing
then sort descending on the true/false column

Thanks that worked.... thanks a lot