| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing data
I have data in column A, 14 digit number; by cutting and pasting from another
data collection file place a smaller amount of data in column B also 14 digit numbers; have to find those numbers in A that are also on B column and delete the record. Is there a way of doing bulk find and delete cheers |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing data
Hi Anthony,
try this way http://www.j-walk.com/ss/excel/usertips/tip073.htm hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Anthony" escreveu: I have data in column A, 14 digit number; by cutting and pasting from another data collection file place a smaller amount of data in column B also 14 digit numbers; have to find those numbers in A that are also on B column and delete the record. Is there a way of doing bulk find and delete cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Comparing data (Before & After) | Excel Worksheet Functions | |||
| Comparing two sets data for different month | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Linear Mode
