F
Faye
This is my data. I will need to extract the rows for each ID that will
contain the maximum value of A and maximum value of B for that ID. I
will need to display them in another sheet.
ID Date A B
1 04/11/05 72515 12626
1 04/18/05 74289 5742
1 04/25/05 70410 1520
1 05/02/05 72536 5017
1 05/09/05 73724 8692
1 05/16/05 71348 8643
2 05/23/05 70807 8996
2 05/30/05 71125 10321
2 06/06/05 77999 16516
2 06/13/05 72273 8593
2 06/20/05 72018 6951
2 06/27/05 71319 6988
2 07/04/05 79540 11495
3 04/11/05 78988 1529
3 04/18/05 78430 1505
3 04/25/05 75618 1773
6 05/02/05 76432 1888
6 05/09/05 77610 948
6 05/16/05 77239 2503
6 05/23/05 76156 750
6 05/30/05 77547 864
6 06/06/05 80526 1649
6 06/13/05 81895 1863
6 06/20/05 77844 453
6 06/27/05 76878 1009
6 07/04/05 78346 909
What I need is:
ID Date-A Max-A Date-B Max-B
1 04/18/05 74289 04/11/05 12626
2 07/04/05 79540 06/06/05 16516
3
6
.....
Appreciate it.
contain the maximum value of A and maximum value of B for that ID. I
will need to display them in another sheet.
ID Date A B
1 04/11/05 72515 12626
1 04/18/05 74289 5742
1 04/25/05 70410 1520
1 05/02/05 72536 5017
1 05/09/05 73724 8692
1 05/16/05 71348 8643
2 05/23/05 70807 8996
2 05/30/05 71125 10321
2 06/06/05 77999 16516
2 06/13/05 72273 8593
2 06/20/05 72018 6951
2 06/27/05 71319 6988
2 07/04/05 79540 11495
3 04/11/05 78988 1529
3 04/18/05 78430 1505
3 04/25/05 75618 1773
6 05/02/05 76432 1888
6 05/09/05 77610 948
6 05/16/05 77239 2503
6 05/23/05 76156 750
6 05/30/05 77547 864
6 06/06/05 80526 1649
6 06/13/05 81895 1863
6 06/20/05 77844 453
6 06/27/05 76878 1009
6 07/04/05 78346 909
What I need is:
ID Date-A Max-A Date-B Max-B
1 04/18/05 74289 04/11/05 12626
2 07/04/05 79540 06/06/05 16516
3
6
.....
Appreciate it.