Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 20, 08:47 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Hi, and a good evening

I need to compare two columns ; I need something
like this :

1.for each my cell in myRng1( myRng1 is BT1:BT200 )
2.compare with each my cell from myRng2 ( myRng2 is
BD11:BD42000 )
3.IF it is a match , Then , copy ,, Range.my cell from myRng2.Offset(0, 7) untill,,("
my cell from myRng2.Offset(0, 9) ,,
4. Destination (of the copy) : my cell from myRng1.Offset(0, 3)

Thank you so much for any suggestions and assistence.

  #2   Report Post  
Old December 30th 20, 10:10 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Compare two Columns , and if is it a Match , copy

Hi,

Am Tue, 29 Dec 2020 11:47:33 -0800 (PST) schrieb Xxer Xxes:

1.for each my cell in myRng1( myRng1 is BT1:BT200 )
2.compare with each my cell from myRng2 ( myRng2 is
BD11:BD42000 )
3.IF it is a match , Then , copy ,, Range.my cell from myRng2.Offset(0, 7) untill,,("
my cell from myRng2.Offset(0, 9) ,,
4. Destination (of the copy) : my cell from myRng1.Offset(0, 3)


try in BW1:
=IFERROR(INDEX($BK$11:$BM$42000,MATCH(BT1,$BD$11:$ BD$42000,0),0),"")
and copy down.


Regards
Claus B.
--
Windows10
Office 2016
  #3   Report Post  
Old December 31st 20, 09:48 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Hi

For now , I get a #NAME? result , but I'll try to work with
this function untill i'll get the wright results. In excel 2012 I haven't
this function : ,, IFERROR ,, , I only have in my list of functions a function
,,ISERROR ,, .

  #4   Report Post  
Old December 31st 20, 10:24 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

I wish you a happy blessed New Year !
  #5   Report Post  
Old January 1st 21, 10:04 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Compare two Columns , and if is it a Match , copy

Hi,

Am Thu, 31 Dec 2020 12:48:19 -0800 (PST) schrieb Xxer Xxes:

For now , I get a #NAME? result , but I'll try to work with
this function untill i'll get the wright results. In excel 2012 I haven't
this function : ,, IFERROR ,, , I only have in my list of functions a function
,,ISERROR ,, .


try in BW1:
=IF(ISNA(MATCH($BT1,$BD$11:$BD$42000,0)),"",INDEX( $BK$11:$BM$42000,MATCH($BT1,$BD$11:$BD$42000,0),CO LUMN(A1)))
and copy the formula to BY1 and then down.


Regards
Claus B.
--
Windows10
Office 2016


  #6   Report Post  
Old January 1st 21, 01:39 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Pe vineri, 1 ianuarie 2021, la 11:04:27 UTC+2, Claus Busch a scris:
Hi,


and copy the formula to BY1 and then down.


It work perfectly perfectly , as I wish you
the Year ,
Sir .
  #7   Report Post  
Old January 10th 21, 10:30 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Hi ,

try in BW1:
=IF(ISNA(MATCH($BT1,$BD$11:$BD$42000,0)),"",INDEX ($BK$11:$BM$42000,MATCH($BT1,$BD$11:$BD$42000,0), COLUMN(A1)))
and copy the formula to BY1 and then down.


for the formula above ,now I just have found it have
a miss in his task : formula, when find identical values ,
it bring the result from first number , repeting his values
from columns of BW to BY . If is not understable , I will
write here an exemple .


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare cells and copy columns after match Kcope8302 Excel Worksheet Functions 2 August 5th 09 05:37 PM
Compare Col A and Col M, if Match, Copy Col N to Col E ryguy7272 Excel Programming 5 March 21st 08 06:51 PM
Compare Col A and Col M, if Match, Copy Col N to Col E ryguy7272 Excel Worksheet Functions 1 March 21st 08 05:57 PM
Compare columns in two WBks and when match is found... DDawson Excel Programming 1 February 26th 08 08:37 PM
Compare columns, delete the rows that DO match. ryguy7272 Excel Programming 2 May 20th 07 04:34 PM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017