Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish you a happy blessed New Year !
|
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare cells and copy columns after match | Excel Worksheet Functions | |||
Compare Col A and Col M, if Match, Copy Col N to Col E | Excel Programming | |||
Compare Col A and Col M, if Match, Copy Col N to Col E | Excel Worksheet Functions | |||
Compare columns in two WBks and when match is found... | Excel Programming | |||
Compare columns, delete the rows that DO match. | Excel Programming |