PDA

View Full Version : Comparing lists in columns?



ami3
06-06-2008, 07:19 AM
Hi,

Please write a macro seeing the attached excel sheet,i want to find for what value in BE column could equate the corresponding values in both BB Column and AX column.

i.e for what value in BE,
BB=AX

i tried to write a macro like below:

Sub guess()
Dim BE As ListColumns

Dim AXAs ListColumns

Dim BBAs ListColumns

For Each ep In d1
Set adj = d1
Next
End Sub

but it didnot work.It will be highly appriciated for writing a macro for this case.Thanks

grichey
06-06-2008, 09:09 AM
there is no attachment

mdmackillop
06-06-2008, 09:18 AM
Hi Ami
When you post code, select it and click the VBA button to format is as shown.

Bob Phillips
06-06-2008, 09:25 AM
Here's a shot at an array formula

=INDEX(BE1:BE100,MATCH(1,INDEX(--(AX1:AX100=BB1:BB100),,1),0))

ami3
06-06-2008, 11:53 AM
Here's a shot at an array formula

=INDEX(BE1:BE100,MATCH(1,INDEX(--(AX1:AX100=BB1:BB100),,1),0))


I have attached the file with it,when i put this formula it not worked.can you please re send this file by putting the formula u think.Thanks a lot for your help.

ami3
06-06-2008, 04:59 PM
Hi,

i am having trouble writing a macro ,i am attaching a file which has a three columns ax,bb,be in the worksheet .i was trying to write a macro which computes like this

i need to find what are the values in the column BE which makes the columns AX and BB equal(AX=BB)

AX,BB and BE are named as adj,do and ep respectively

i was trying this macro

Thanks a lot

there is no attachment

ami3
06-07-2008, 08:46 AM
HI THERE ARE MORE THAN 10000 ROWS.THANKS