Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 2 Lists of Data on the same sheet
List A is detailed in Columns A-D List B is detailed in Column G-K What I want to do is compare certain Columns/Rows in both Lists and for each one that matches, place an X in Column E (covering List A) and a corresponding X in Column L (covering List B). Note the matched values will not be on the same Row in both So what will be compared? if Col B & D rows matches somewhere with Col H & K an X is placed on the appropriate Row in Cols E & L Essentially I want to do a Supplier A/c Reconciliation. Above would give me a good start point |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare two lists | Excel Worksheet Functions | |||
compare two lists | Excel Worksheet Functions | |||
Compare Two Lists | Excel Programming | |||
Compare 3 lists | Excel Programming | |||
Compare two sheets and perform action routine | Excel Programming |