Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exception deleting
I have a dataset that includes a coulmn of product codes-aprox 10'000 entires e.g Prod Code Value 01023456 12 01204895 19 02857867 34 05292453 24 90235905 65 There is other data in differnet columns, with entries relavent to the product codes. As you can see in my example with the value. I have anothe list of codes - aprox 250 (that i call exceptions) that are included in the above table that i want eliminate. Is there a formula to do this e.g Exceptions 01023456 05292453 Thankyou for your help Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=505319 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows Automatically using a Text File List | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Excel.Range.Name gives error an exception | Excel Discussion (Misc queries) | |||
cell is reinserting a formula in even after deleting it. Why | Excel Discussion (Misc queries) |