J
jmbdakota
I want to assign a order value to a dollar amont in relationship to
other dollar amounts in the same colume. I don't want to move or sort
the dollar amount colume because of other data in same row.
The second colum (whole numbers) is the colume I need to generate
automaticly. It represents the first number $4.50 is the 4th smallest
number of the eight numbers in the colume,$3.00 - second smallest,
$9.00 fifth smallest etc.
Example
$4.50 ---------- 4
$3.00 ---------- 2
$9.00 ---------- 5
$25.00 --------- 8
$3.50 ---------- 3
$14.00 --------- 7
$2.00 ---------- 1
$10.00 --------- 6
other dollar amounts in the same colume. I don't want to move or sort
the dollar amount colume because of other data in same row.
The second colum (whole numbers) is the colume I need to generate
automaticly. It represents the first number $4.50 is the 4th smallest
number of the eight numbers in the colume,$3.00 - second smallest,
$9.00 fifth smallest etc.
Example
$4.50 ---------- 4
$3.00 ---------- 2
$9.00 ---------- 5
$25.00 --------- 8
$3.50 ---------- 3
$14.00 --------- 7
$2.00 ---------- 1
$10.00 --------- 6