SORT/FILTER ISSUE

  • Thread starter Thread starter Munfarid
  • Start date Start date
M

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