On 2002-04-28 20:29, somkiat wrote:
I have a constant name : MyNum
Refers to an number array ={1;2;3;4;5}
and a range name : MyRange
Refers to =A1:A5
With vba, how to send value 1-5 to cells A1:A5
To get
A1: 1
A2: 2
A3: 3
A4: 4
A5: 5
Thank you so much
On 2002-04-29 03:56, somkiat wrote:
Nice to talk with you again, Aladin.
I make an array formula to get an unique list of Order_ID
{=INDEX(Order_ID,INDEX(SMALL(IF(ISBLANK(Order_ID),FALSE(),IF(MATCH(Order_ID,Order_ID,0)=AllRecordNum,AllRecordNum)),AllRecordNum),RecordNum,1),1)}
This formula returns an array of
{10248;10249;10250;10251;.......11747}
into cells correctly.
Order_ID ia a range of Order ID such as 10248, 10248, 10248, 10249,10249, 10250. One transaction can have many orders with the same order_id. There are 1500 orders.
AllRecordNum is a range of consecutive number from 1;2;3;4;5;....to 1500.
RecordNum is a range of consecutive number from 1;2;3;4;5;...to 20. I use these numbers to show the first 20 order_ids from its unique list.
Then I create a formula name as IdSource and refered to that formula.
With the following vba, it returns falsely only the first unique id instead of all unique list into UniqueID range:
Sub GetUniqueID()
myvar = range("IdSource")
range("UniqueID") = myvar
End Sub
I need this answer to UniqueID range:
10248
10249
10250
......+1
not
10248
10248
10248
10248
10248
10248
How comes only the first item in array formula pass to vba?
On 2002-04-29 03:56, somkiat wrote:
Nice to talk with you again, Aladin.
I make an array formula to get an unique list of Order_ID
{=INDEX(Order_ID,INDEX(SMALL(IF(ISBLANK(Order_ID),FALSE(),IF(MATCH(Order_ID,Order_ID,0)=AllRecordNum,AllRecordNum)),AllRecordNum),RecordNum,1),1)}
This formula returns an array of
{10248;10249;10250;10251;.......11747}
into cells correctly.
Order_ID ia a range of Order ID such as 10248, 10248, 10248, 10249,10249, 10250. One transaction can have many orders with the same order_id. There are 1500 orders.
AllRecordNum is a range of consecutive number from 1;2;3;4;5;....to 1500.
RecordNum is a range of consecutive number from 1;2;3;4;5;...to 20. I use these numbers to show the first 20 order_ids from its unique list.
Then I create a formula name as IdSource and refered to that formula.
With the following vba, it returns falsely only the first unique id instead of all unique list into UniqueID range:
Sub GetUniqueID()
myvar = range("IdSource")
range("UniqueID") = myvar
End Sub
I need this answer to UniqueID range:
10248
10249
10250
......+1
not
10248
10248
10248
10248
10248
10248
How comes only the first item in array formula pass to vba?
On 2002-05-01 03:44, Ivan F Moala wrote:
Note 100% sure of what you require.
Care to email workbook to me ??
I sought of know what you are after ??