Prev: Form and protect sheet
Next: The picture is too large and will be truncated."-excel Warning
From: Katerinia on 5 Apr 2010 12:49
COL of codes in A (full List of codes of about 2,000)
COL of codes in B (selection of COL A codes of about 850)

IF COL B code matches COLUMN A code, then true, else false
From: Eduardo on 5 Apr 2010 13:28
Hi,

in C1 enter

=IF(SUMPRODUCT(--(B1=$A$1:$A$2000))>0,"True","False")

copy formula down

"Katerinia" wrote:

> COL of codes in A (full List of codes of about 2,000)
> COL of codes in B (selection of COL A codes of about 850)
>
> IF COL B code matches COLUMN A code, then true, else false
From: Katerinia on 5 Apr 2010 13:42
I need to basically widdle away data in a worksheet, using the criterial of
same codes. Col A is the full list of codes followed by data relating to it.
I dont need all these rows of data, i only need the data that correlates
wtih matching codes from a shorter list currently in Col B.

"Katerinia" wrote:

> COL of codes in A (full List of codes of about 2,000)
> COL of codes in B (selection of COL A codes of about 850)
>
> IF COL B code matches COLUMN A code, then true, else false
From: Eduardo on 5 Apr 2010 14:20
Hi,
column B in another sheet?, could you post an example on how your data looks
like and what do you want to get, thanks

"Katerinia" wrote:

> I need to basically widdle away data in a worksheet, using the criterial of
> same codes. Col A is the full list of codes followed by data relating to it.
> I dont need all these rows of data, i only need the data that correlates
> wtih matching codes from a shorter list currently in Col B.
>
> "Katerinia" wrote:
>
> > COL of codes in A (full List of codes of about 2,000)
> > COL of codes in B (selection of COL A codes of about 850)
> >
> > IF COL B code matches COLUMN A code, then true, else false
From: Katerinia on 5 Apr 2010 14:47
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.
 |  Next  |  Last
Pages: 1 2
Prev: Form and protect sheet
Next: The picture is too large and will be truncated."-excel Warning