Okay I have a table like this.
0907086 -- $40.54
0907086 -- $41.74
0907086 -- $47.70
0907095 -- $45.96
0907095 -- $47.31
0907095 -- $54.06
0907102 -- $40.54
0907102 -- $41.74
0907102 -- $47.70
0907111 -- $56.62
0907111 -- $58.28
0907111 -- $66.61
I want to pick out the biggest dollar value for each part number and
write it by the part number.
For instance
0907086 -- $40.54
0907086 -- $41.74
0907086 -- $47.70 -- 47.70
0907095 -- $45.96
0907095 -- $47.31
0907095 -- $54.06 -- 54.06
0907102 -- $40.54
0907102 -- $41.74
0907102 -- $47.70 -- 47.7
0907111 -- $66.61
0907111 -- $66.61
0907111 -- $66.61 -- 66.61
Any way of doing this ?
And something else I would like, although not necessary is on the last
section you will notice that I would like only one of them to have the
66.61 printed beside it.
Chow
---
Message posted from
http://www.ExcelForum.com/