View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default SORT/FILTER ISSUE

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