Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two col data & add info
Is there anyone know how I can compare the following data in Excel spread sheet
When comparing col A & Col C, If A2 (tp-2) =C4 (tp-2) then put D4 (deleted) in B2 A B C D 1 TP-1 TP-3 new 2 TP-2 deleted TP-5 xx 3 TP-3 new TP-8 4 TP-4 TP-2 deleted 5 TP-5 xx TP-10 Please help & many thanks Philip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare EE #s & Copy Info | Excel Discussion (Misc queries) | |||
Compare and group like numbers and info | Excel Worksheet Functions | |||
How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions | |||
compare columns of info | Excel Discussion (Misc queries) |