|
Matching Values in Two Columns
Can anyon epleae help?
I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
Matching Values in Two Columns
--Insert a column inbetween Col B and C so that 40000 data is in ColD
--In Col C cell C1 enter the below formula which will return the text if Col B data is present in ColD. Copy down the formula as required =IF(COUNTIF(D:D,B1),"Present in Col D","") If this post helps click Yes --------------- Jacob Skaria "John" wrote: Can anyon epleae help? I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
Matching Values in Two Columns
In D1, enter:
=IF(COUNTIF(C:C,B1)0,"Match","") and copy down -- Gary''s Student - gsnu200908 "John" wrote: Can anyon epleae help? I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
| All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com