Prev: Form and protect sheet
Next: The picture is too large and will be truncated."-excel Warning
From: Eduardo on 5 Apr 2010 15:01
Hi Katerinia,
in another column enter

=INDEX(CODESNEEDED!$A$1:$A$5,MATCH(C1,CODESNEEDED!$A$1:$A$5,0))

I assume that the code in sheet job_codes are in C starting in row 1
If the code is not in the other sheet it will bring #N/A
then filter the column by #N/A, higlight the rows, right click on the mouse,
delete
then go back to the filter and select all



"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.
From: Dave Peterson on 5 Apr 2010 15:38
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
First  |  Prev  | 
Pages: 1 2
Prev: Form and protect sheet
Next: The picture is too large and will be truncated."-excel Warning