sal21
09-02-2007, 03:05 PM
in column A have a value related column D.
In effect in D are the value of Principal Agency and in column A are the value of Sub Agency of Principal Agency.
Now based column D how to ,(with a function or macro) get and store in a variable the value of min and max of Sub Agengy?
Example:
for all 4580 in column D get the min and max from column A.
In this case the min is 4500 the max is 6552
The name of variable is MIN_Agency and MAX_Agency
Tks.
In effect in D are the value of Principal Agency and in column A are the value of Sub Agency of Principal Agency.
Now based column D how to ,(with a function or macro) get and store in a variable the value of min and max of Sub Agengy?
Example:
for all 4580 in column D get the min and max from column A.
In this case the min is 4500 the max is 6552
The name of variable is MIN_Agency and MAX_Agency
Tks.