Sort numbers
Closed
                                    
                        babu                    
                                    -
                            Sep 16, 2009 at 01:29 PM
                        
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:06 PM
        Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:06 PM
        Related:         
- Sort numbers
 - Chrome sort bookmarks - Guide
 - Sort google drive - Guide
 - Spotify sort by genre - Guide
 - Android sort apps - Guide
 - Sort call - Guide
 
1 response
                
        
                    Excelguru
    
        
                    Posts
            
                
            261
                
                            Registration date
            Saturday April 11, 2009
                            Status
            Member
                            Last seen
            June 21, 2011
            
            
                    307
    
    
                    
Sep 16, 2009 at 11:06 PM
    Sep 16, 2009 at 11:06 PM
                        
                    Hello
try this
=IF(COUNTIF($A$1:$A$9,"="&B1)>0,"",B1)
            try this
=IF(COUNTIF($A$1:$A$9,"="&B1)>0,"",B1)