Vlookup
You could insert a new (temporary) column B (it's nice to be close to the column
with the data) and use a formula like:
=isnumber(match(a2,'codesneeded'!a:a,0))
(and drag down the column.)
You'll see True if there's a match and False if there is no match.
Convert to values by
selecting column B
edit|copy
edit|paste special|values
(It'll make things quicker.)
Then either filter to show the False's and delete the visible rows (and then
show all data) -- or sort by column B and delete the rows with False in that
column.
Then delete column B.
Katerinia wrote:
In worsheet JOB_CODES
C1 C2 C3
JOBCODE EFFDT DESCR DESCRSHORT
414096 1011906 DSC VP - REFINERY OPERATIONS DSCVPREFOP
414116 1011906 DSC GEN'L COUNSEL & SECTY DSCGENCNS
414126 1011906 TLNAS PRESIDENT TLNAS PRES
414146 1011906 DSC VP & AST TO PRS-GOV REL DSC GOVREL
415016 1011906 DSC DIRECTOR - INFO TECH&PLNG DIS DIR IT
415026 1011906 DSC VP - SALES DSC VP SLS
The only need to keep certain data rows which are listed in another
worksheet: "CODESNEEDED"
NEEDEDCODES
123500
410013
410014
410023
410227
410407
How can I mark worksheet Job_CODES so I can run a filter and delete the rows
I dont need the info.
--
Dave Peterson
|