HOW CAN I SORT THE FOLLOWING CELLS?

QUESTION:
A1=123
A2=343
A3=123

DESIRED RESULT:
A1=123
A3=123
SINCE IN DO NOT WANT A2 TO APPEAR

Hi,
in another column enter

=TRIM(RIGHT(A1,FIND("=",A1)))

the above will give you only the numbers then filter that column by the
numbers you want to see

if this helps please click yes thanks

"Munfarid" wrote:

HOW CAN I SORT THE FOLLOWING CELLS?

QUESTION:
A1=123
A2=343
A3=123

DESIRED RESULT:
A1=123
A3=123
SINCE IN DO NOT WANT A2 TO APPEAR

Actually the column contains the following values:

A1=8663
A2=8663
A3=8666
A4=8666
A5=8667
A6=8675
A7=8676

I WANTED TO SORT ONLY THOSE VALUES THAT ARE REPEATED, REST NEEDS TO BE
DELETED. THE RESULT I REQUIRED SHOULD BE LIKE THIS:

A1=8663
A2=8663
A3=8666
A4=8666

HOPE THIS CLARIFIES



"Eduardo" wrote:

Hi,
in another column enter

=TRIM(RIGHT(A1,FIND("=",A1)))

the above will give you only the numbers then filter that column by the
numbers you want to see

if this helps please click yes thanks

"Munfarid" wrote:

HOW CAN I SORT THE FOLLOWING CELLS?

QUESTION:
A1=123
A2=343
A3=123

DESIRED RESULT:
A1=123
A3=123
SINCE IN DO NOT WANT A2 TO APPEAR

In column B, enter:

=RIGHT(A1,4)
Fill down

In column C, enter:
=COUNTIF($B$1:$B$7,B1)

In column C, filter for €˜1, delete all with a €˜1 and unfilter


HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Munfarid" wrote:

Actually the column contains the following values:

A1=8663
A2=8663
A3=8666
A4=8666
A5=8667
A6=8675
A7=8676

I WANTED TO SORT ONLY THOSE VALUES THAT ARE REPEATED, REST NEEDS TO BE
DELETED. THE RESULT I REQUIRED SHOULD BE LIKE THIS:

A1=8663
A2=8663
A3=8666
A4=8666

HOPE THIS CLARIFIES



"Eduardo" wrote:

Hi,
in another column enter

=TRIM(RIGHT(A1,FIND("=",A1)))

the above will give you only the numbers then filter that column by the
numbers you want to see

if this helps please click yes thanks

"Munfarid" wrote:

HOW CAN I SORT THE FOLLOWING CELLS?

QUESTION:
A1=123
A2=343
A3=123

DESIRED RESULT:
A1=123
A3=123
SINCE IN DO NOT WANT A2 TO APPEAR

Hi,

Cut A1:A7 and paste it in A2:A8. IN cell A1, type heading1. In cell A12,
enter the following formula =COUNTIF($A$2:$A$8,A2)1. Now click on any cell
in A1:A8 and go to Data Filter Advanced Filter Copy to another
location. In the list range, give the range as A1:A8, criteria would be
A11:A12 and in the copy to box, specify a blank cell. Now click on OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Munfarid" wrote in message
...
Actually the column contains the following values:

A1=8663
A2=8663
A3=8666
A4=8666
A5=8667
A6=8675
A7=8676

I WANTED TO SORT ONLY THOSE VALUES THAT ARE REPEATED, REST NEEDS TO BE
DELETED. THE RESULT I REQUIRED SHOULD BE LIKE THIS:

A1=8663
A2=8663
A3=8666
A4=8666

HOPE THIS CLARIFIES



"Eduardo" wrote:

Hi,
in another column enter

=TRIM(RIGHT(A1,FIND("=",A1)))

the above will give you only the numbers then filter that column by the
numbers you want to see

if this helps please click yes thanks

"Munfarid" wrote:

HOW CAN I SORT THE FOLLOWING CELLS?

QUESTION:
A1=123
A2=343
A3=123

DESIRED RESULT:
A1=123
A3=123
SINCE IN DO NOT WANT A2 TO APPEAR