software

Hi all,

Perhaps you may have heard this question a thousand times but here it
is again for the thousand and one time. I have two column of IDs that I
am trying to compare and figure out which one is missing.

The IDs look like this:

KD036078AS070634
MS028846AA063405
RV009526AG059891
SG033911ak071410
AR053757AP056068
BD028031AT067547
BP044319AC054501
DC032030AP054795
DN047994AT038118
JD016833 AS048834
JW047209AS068626
MB030686AL054618
RS061603AM040365
SK005695AM047477
SL020353AQ039733
VC059131AR072148
JK038041 AC028342
RO034327AG063351
HK071317AP032493
MM050011TPAO8173
AC057342AF052939
FK053590AP035357
HP051837AB029329

So basically, I would like to match let's say ID KD036078 in the first
row to the second row to see first if it exists and then if not, send a
flag.

I've tried working with HLOOKUP, VLOOKUP, and MATCH but to no avail.
ANY assistance, advice or guidance you can provide is greatly
appreciated.

Thanks all,

ExLN00B06--
ExcelN00B06
------------------------------------------------------------------------
ExcelN00B06's Profile: www.excelforum.com/member.php...oamp;userid=33576
View this thread: www.excelforum.com/showthread...hreadid=533551Hi!

Try one of these:

=IF(COUNTIF(B$1:B$23,A1),quot;OKquot;,quot;Missingquot;)

=IF(ISNUMBER(MATCH(A1,B$1:B$23,0)),quot;OKquot;,quot;Missingquot;)

Copy down as needed.

Biff

quot;ExcelN00B06quot; gt;
wrote in message
...
gt;
gt; Hi all,
gt;
gt; Perhaps you may have heard this question a thousand times but here it
gt; is again for the thousand and one time. I have two column of IDs that I
gt; am trying to compare and figure out which one is missing.
gt;
gt; The IDs look like this:
gt;
gt; KD036078 AS070634
gt; MS028846 AA063405
gt; RV009526 AG059891
gt; SG033911 ak071410
gt; AR053757 AP056068
gt; BD028031 AT067547
gt; BP044319 AC054501
gt; DC032030 AP054795
gt; DN047994 AT038118
gt; JD016833 AS048834
gt; JW047209 AS068626
gt; MB030686 AL054618
gt; RS061603 AM040365
gt; SK005695 AM047477
gt; SL020353 AQ039733
gt; VC059131 AR072148
gt; JK038041 AC028342
gt; RO034327 AG063351
gt; HK071317 AP032493
gt; MM050011 TPAO8173
gt; AC057342 AF052939
gt; FK053590 AP035357
gt; HP051837 AB029329
gt;
gt; So basically, I would like to match let's say ID KD036078 in the first
gt; row to the second row to see first if it exists and then if not, send a
gt; flag.
gt;
gt; I've tried working with HLOOKUP, VLOOKUP, and MATCH but to no avail.
gt; ANY assistance, advice or guidance you can provide is greatly
gt; appreciated.
gt;
gt; Thanks all,
gt;
gt; ExLN00B06
gt;
gt;
gt; --
gt; ExcelN00B06
gt; ------------------------------------------------------------------------
gt; ExcelN00B06's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33576
gt; View this thread: www.excelforum.com/showthread...hreadid=533551
gt;
=IF(COUNTIF($A$1:$A$23,B1)=0,quot;Flagquot;,quot;quot;)

And fill down.

HTH
Regards,
Howard

quot;ExcelN00B06quot; gt;
wrote in message
...
gt;
gt; Hi all,
gt;
gt; Perhaps you may have heard this question a thousand times but here it
gt; is again for the thousand and one time. I have two column of IDs that I
gt; am trying to compare and figure out which one is missing.
gt;
gt; The IDs look like this:
gt;
gt; KD036078 AS070634
gt; MS028846 AA063405
gt; RV009526 AG059891
gt; SG033911 ak071410
gt; AR053757 AP056068
gt; BD028031 AT067547
gt; BP044319 AC054501
gt; DC032030 AP054795
gt; DN047994 AT038118
gt; JD016833 AS048834
gt; JW047209 AS068626
gt; MB030686 AL054618
gt; RS061603 AM040365
gt; SK005695 AM047477
gt; SL020353 AQ039733
gt; VC059131 AR072148
gt; JK038041 AC028342
gt; RO034327 AG063351
gt; HK071317 AP032493
gt; MM050011 TPAO8173
gt; AC057342 AF052939
gt; FK053590 AP035357
gt; HP051837 AB029329
gt;
gt; So basically, I would like to match let's say ID KD036078 in the first
gt; row to the second row to see first if it exists and then if not, send a
gt; flag.
gt;
gt; I've tried working with HLOOKUP, VLOOKUP, and MATCH but to no avail.
gt; ANY assistance, advice or guidance you can provide is greatly
gt; appreciated.
gt;
gt; Thanks all,
gt;
gt; ExLN00B06
gt;
gt;
gt; --
gt; ExcelN00B06
gt; ------------------------------------------------------------------------
gt; ExcelN00B06's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33576
gt; View this thread: www.excelforum.com/showthread...hreadid=533551
gt;