Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing values
column E in sheet A has values, a different one in each row (ranging from 50
to 500 values, depending on workbook we're working in) column T in sheet B has values, thousands of them the contents of sheetB are delivered by an external source values in colT / sheetB should be named in colE / sheetA (theory) there are values in colT / sheetB that are not present in colE / sheetA (practice) these need to be pointed out so after that it can be decided to discard these lines or add the value to colE / sheetA I want to run code to check the values of colT/sheetB if a value in colT/sheetB isn't present in colE / SheetA then it should print the value in the current (different) sheet I've tried a few things now ~ I'm taking a wrong turn somewhere any good ideas out there? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Comparing values in two columns and displaying missing values in n | Excel Programming | |||
Help: Comparing two values | Excel Programming | |||
Comparing Values | Excel Programming |