EXTRACT A LIST FROM 2 COLUMNS
Closed
                                    
                        LOMALO                    
                                    -
                            Jul  2, 2009 at 05:38 AM
                        
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 07:00 AM
        mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 07:00 AM
        Related:         
- EXTRACT A LIST FROM 2 COLUMNS
 - 텐타클 락커 2 - Download - Adult games
 - Display two columns in data validation list but return only one - Guide
 - My cute roommate 2 - Download - Adult games
 - Extract audio from video vlc - Guide
 - Fnia 2 - Download - Adult games
 
1 response
                
        
                    mubashir aziz
    
        
                    Posts
            
                
            190
                
                            Registration date
            Sunday April 12, 2009
                            Status
            Member
                            Last seen
            February 16, 2010
            
            
                    166
    
    
                    
Jul 2, 2009 at 07:00 AM
    Jul 2, 2009 at 07:00 AM
                        
                    Suppose data started from row A2:B50 then in C2 write this formula 
and drag it down ......
                
                
            C2=IF(ISERROR(MATCH(A2,$B$2:$B$50,0)),"",A2)
and drag it down ......