Test

[Molly Brennholz]

Continued from previous post
Some notes to help me in solving this Thread:
http://www.excelfox.com/forum/showth...te-conditional


I will answer this similar to the last question for consistency to help in understanding, and also do it in a way that might not be the most efficient, but may help in further modifications or similar requirements that I would not be surprised might follow…

Regardless of, and before any checks for meeting the match criteria are done I will make an array of arrays as previously, arr3()
This will be a one dimensional array. For the test data from the previous post this will have a size of 6 main elements, ( 7 incl. Header - arr3(0) not used ) , each of which is a single row, 2 dimensional array of the original data in 2.xlsm with the addition of an extra last element.

ACC

22

1

2

3

ADANIENT

25

1

2

ADANIPORTS

15083

1

2

3

4

ADANIPOWER

17388

1

2

3

4

5

6

AMARAJABAT

100

1

2

3

4

5

ASIANPAINT

236

1

2

3

[ _____ Workbook: 2.xlsm ( Using Excel 2007 32 bit )

arr3()	=	{ arr3(1) ,	arr3(2) ,	arr3(3) ,	arr3(4) ,	arr3(5) ,	arr(6) }
		arr3(1)	=	ACC	22	1	2	3
			arr3(2)	=	ADANIENT	25	1	2
				arr3(3)	=	ADANIPORTS	15083	1	2	3	4
					arr3(4)	=	ADANIPOWER	17388	1	2	3	4	5	6
						arr3(5)	=	AMARAJABAT	100	1	2	3	4	5
							arr3(6)	=	ASIANPAINT	236	1	2	3