Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match columns
A B 1 x 1 1 x 2 1 x 3 1 x 4 1 x 5 1 x 6 2 x 7 2 x 8 2 x 9 2 x 10 2 x 2 x 3 x 3 x 3 x ETC....to 10 Actually column A goes down about 1000 rows. Number of times a numbe is reapeated in column A varies. Numbers in column C varies an determines the range of numbers in A.I need a macro that will matc column C to all the numbers in Column A. Cannot use a fill proceedur as this is part of a larger program. So result should look like. B]A B C[/b] 1 x 1 1 x 1 1 x 1 1 x 1 1 x 1 1 x 1 2 x 2 2 x 2 2 x 2 2 x 2 2 x 2 2 x 2 3 x 3 3 x 3 3 x 3.....Et -- ligh ----------------------------------------------------------------------- light's Profile: http://www.excelforum.com/member.php...nfo&userid=722 View this thread: http://www.excelforum.com/showthread.php?threadid=55048 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match columns
try Code: -------------------- Sub test() With Range("a1").CurrentRegion.Resize(,1).Offset(,2) .FormulaR1C1="=RC1" .Value=.Value End With End Sub -------------------- -- jindon ------------------------------------------------------------------------ jindon's Profile: http://www.excelforum.com/member.php...o&userid=13135 View this thread: http://www.excelforum.com/showthread...hreadid=550488 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
Match formula to match values in multiple columns | Excel Discussion (Misc queries) | |||
Match 2 columns to 2 columns in different worksheets | Excel Discussion (Misc queries) | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) |