Y
yoyo2000
19590709 27.81 28.65 27.81 27.81 27 571
19590710 27.42 27.60 27.30 27.42 92 676
19590710 27.57 27.75 27.44 27.57 119 874
19590710 27.66 27.77 27.51 27.66 105 544
19590710 27.80 27.87 27.65 27.80 19 577
19590713 27.70 27.80 27.38 27.70 64 663
above is a segment of my data,as you can see,the first col is the
date,each raw of data is a group of data,and there are several groups
of date are generated at the same day(1959-7-9)
I want to pick the "valid date" out each day,and I compare them with
data at the last col of each group at the same day,the group with the
biggest value of last col is regarded as "valid data".so I mark a "1"
next to the last col,others I mark "0" behind.
For instance,I compare 4 raws of data at the same day of 1959-7-10,
and 874 is the biggest number in the last col.so
19590710 27.57 27.75 27.44 27.57 119 874
is the valid data of 1959-7-10
The result is below
19590709 27.81 28.65 27.81 27.81 27 571 0
19590710 27.42 27.60 27.30 27.42 92 676 0
19590710 27.57 27.75 27.44 27.57 119 874 1
19590710 27.66 27.77 27.51 27.66 105 544 0
19590710 27.80 27.87 27.65 27.80 19 577 0
19590713 27.70 27.80 27.38 27.70 64 663 0
But I don't know how to perform my rules in Excel,coudl anyone help
me?
Much appreciation.
PS: I can't access colo's HTML Maker,please paste the formular on
board,thanks
additional data is in attachment
+-------------------------------------------------------------------+
|Filename: HG-standard(part1).zip |
|Download: http://www.excelforum.com/attachment.php?postid=2732 |
+-------------------------------------------------------------------+
19590710 27.42 27.60 27.30 27.42 92 676
19590710 27.57 27.75 27.44 27.57 119 874
19590710 27.66 27.77 27.51 27.66 105 544
19590710 27.80 27.87 27.65 27.80 19 577
19590713 27.70 27.80 27.38 27.70 64 663
above is a segment of my data,as you can see,the first col is the
date,each raw of data is a group of data,and there are several groups
of date are generated at the same day(1959-7-9)
I want to pick the "valid date" out each day,and I compare them with
data at the last col of each group at the same day,the group with the
biggest value of last col is regarded as "valid data".so I mark a "1"
next to the last col,others I mark "0" behind.
For instance,I compare 4 raws of data at the same day of 1959-7-10,
and 874 is the biggest number in the last col.so
19590710 27.57 27.75 27.44 27.57 119 874
is the valid data of 1959-7-10
The result is below
19590709 27.81 28.65 27.81 27.81 27 571 0
19590710 27.42 27.60 27.30 27.42 92 676 0
19590710 27.57 27.75 27.44 27.57 119 874 1
19590710 27.66 27.77 27.51 27.66 105 544 0
19590710 27.80 27.87 27.65 27.80 19 577 0
19590713 27.70 27.80 27.38 27.70 64 663 0
But I don't know how to perform my rules in Excel,coudl anyone help
me?
Much appreciation.
PS: I can't access colo's HTML Maker,please paste the formular on
board,thanks
additional data is in attachment
+-------------------------------------------------------------------+
|Filename: HG-standard(part1).zip |
|Download: http://www.excelforum.com/attachment.php?postid=2732 |
+-------------------------------------------------------------------+