Search : in
By :

Excel Column Sort

Last answer on Apr 20, 2009 1:39:16 pm BST ZaQ, on Apr 18, 2009 5:25:49 pm BST 
 Report this message to moderators

Hello,

i have a list of numbers/letters titles written like: 1KFLS921

there are around 2000 of these listed down column A.

i have the same list of titles written down column B but there are around 200 missing.

so both list contains the same titles, except 200 are missing out of column B. i need a conditional formatting or anything that will work, that will highlight the titles in column A that are NOT listed or Column B. or It could list the titles that are missing in a seperate column. either one works for me. Please Help.


zH

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Excel Column Sort » in :
Delete duplicates in an Excel column Show Delete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
COMPARING TWO COLUMNS OF NAMES IN EXCEL Show
Excel autofilter stops filtering (Solved) Show
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL �+ ;� in the chosen cell. To insert current time, press CTRL�+...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[Excel] Sorting rows only Show[Excel] Sorting rows only Microsoft Excel by default perform a sort on the columns (Data/Sort). To sort the data horizontally, just select the data to be sorted, then Data tab /Sort/ Options/ check the Sort Left to right box in the...
Ask your question Reply

1

aquarelle, on Apr 19, 2009 1:01:21 pm BST

Hi,
Try with this macro, I hope it will work as you want : 

Sub CompareColumnsAB()
    Set cl2 = Range("A:A")
    Set cl1 = Range("B:B")
        For Each c In cl2
            MyValue = c.Value
            If MyValue <> "" Then
                Set Plage = cl1.Cells.Find(MyValue, lookat:=xlWhole)
                If Not Plage Is Nothing Then
                      c.Range("A1").Interior.ColorIndex = xlNone
                Else: c.Range("A1").Interior.ColorIndex = 4
                End If
            End If
        Next
End Sub


Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle

2

 ZaQ, on Apr 20, 2009 1:39:16 pm BST
  • +1

This worked perfectly, thank you greatly.

   
Reply to ZaQ
Ask your question Reply
They need your help