SORT/FILTER ISSUE

[Munfarid]

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

 

[Eduardo]

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]

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

 

[ryguy7272]

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---

 

[Ashish Mathur]

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